How to zipfile/unzipfile an excel file with password

[fu gang]

hello,
I want to zipfile/unzipfile an excel file with password compression. Now I have two ways of encrypting and compressing files One is to use shellout to call the software, and then operate to zipfile/unzipfile with password and the other is to directly compress with the command, zipfile/unzipfile, but I don’t find the password added in the help file., zipfile file|directory [file|directory] ..., saving(zipfilename[, replace]),
Are there any another commands or options in zipfile/unzipfile command to zipfile/unzipfile with password?
Of course, the password is known to us, such as 123.

Thank your very much.

[William Lisowski]

I'd guess that Stata chose to not encourage placing passwords used to secure information in insecure do-files. If your computer is compromised then the password no longer secures your data.

f you are working on a personal computer I'd suggest securing your data by placing it on removable media in an unencrypted version, and better yet, encrypting the removable media so a password is required when the media is mounted. That's how I handle data that I'm required to secure. And I keep the removable media physically secured when it's not mounted.

[fu gang]

Thank you for reply, Thank you very much.

[Jared Greathouse]

Sounds like a good project for Stata/Python integration.

[fu gang]

I agree with your point of view, Jared
Because sometimes we need to keep files confidential and require a password when packaging. Worried that dofile will leak the password, we can put the zipfiles and dofile separately, or continue to encrypt or hide the dofile, replace it with a certain symbol, and add it when using it. Because if a large number of files are packaged and distributed to many people, it is efficient and relatively confidential