Since you are on Linux and can password protect the worksheets I'm going to guess that you are using Spreadsheet::WriteExcel. In which case, password protection of a workbook isn't supported.
Currently, there isn't any available workaround using Spreadsheet::WriteExcel.
--
John.
| [reply] |
Correct, I am using the Spreadsheet::WriteExcel module; but it is not quiet what I am looking for. Are you aware of any other method that can be used?
| [reply] |
thimi3,
Are you aware of any other method that can be used?
Perhaps you missed where jmcnamara, the author of the module said - "Currently, there isn't any available workaround using Spreadsheet::WriteExcel."
The documentation has this to say:
Note, the worksheet level password in Excel provides very weak protection. It does not encrypt your data in any way and it is very easy to deactivate. Therefore, do not use the above method if you wish to protect sensitive data or calculations. However, before you get worried, Excel's own workbook level password protection does provide strong encryption in Excel 97+. For technical reasons this will never be supported by Spreadsheet::WriteExcel.
I am not aware of any module that doesn't run on Win32 that does what you want. If you find one, please share.
| [reply] |
How about encrypt the file. Leave it up to the user to decrypt, and then use as a regular file. Oh, wait- your bosses that be just want this to work in their magical fantasy land, right?
This would be a solution that actually works, there's no crazyness about it or losing sleep about if you did it right or not.
Here's some stuff worth looking over..
| [reply] |