can we add password protection to the sheet?

[jcquarto]

guys, I'm reading through the documentation and don't see anything that refers to password-protecting the XLS file. Is that possible? Is it possible but not part of the gem?

[jmcnamara]

This is from the XlsxWriter (a sister library) docs:

Although it is possible to password protect a worksheet using the Worksheet
protect method it isn't possible to password protect the entire
workbook/file using XlsxWriter.

The reason for this is that a protected/encrypted xlsx file is in a different
format from an ordinary xlsx file. This would require a lot of additional work,
and testing, and isn't something that is on the XlsxWriter roadmap.

However, it is possible to password protect an XlsxWriter generated file using
a third party open source tool called msoffice-crypt. This works for macOS, Linux and Windows:

    msoffice-crypt.exe -e -p password clear.xlsx encrypted.xlsx