Can CoolSpools password-protect an Excel file?

Yes, the latest version of CoolSpools includes a standalone command LCKXLS.  This command allows you to apply native Excel password protection to any spreadsheet stored on your IFS, whether it was created by CoolSpools or by some other method.

An alternative option is to use password-protected, encrypted zip files to distribute files such as Excel spreadsheets.  This approach also supports file types that do not offer native password protection, such as CSV text files.

Using zip files when emailing output

When you use the EMAIL(*YES) option to email a file from CVTSPLXLS, CVTDBFXL and other similar commands, there is an option on the EMAILOPT parameter to tell CoolSpools to email the file inside a zip. This helps minimize the size of the attachment you're sending.

That option also allows you to specify a password for the zip file in which the attachment is emailed. If you specify a password, the zip file will be encrypted, giving you a good level of security.

Using the ZIPDTA and UNZIPDTA commands

The ZIPDTA ("Zip Data") command that is provided as part of the CoolSpools Base option also supports the creation of password-protected, encrypted zip files and can be used to zip up stream files from the IFS or save file and database files from the /QSYS.LIB file system.

The UNZIPDTA ("Unzip Data") command can unzip password-protected, encrypted zip files on entry of the correct password.