in reply to Re^2: Password Protect Excel File
in thread Password Protect Excel File

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.

Cheers - L~R

Replies are listed 'Best First'.
Re^4: Password Protect Excel File
by davies (Monsignor) on Nov 26, 2009 at 12:38 UTC
    To reiterate the point about the weakness of worksheet passwords, there is a brief description here of the weakness and a macro to remove all internal passwords. Sometimes, people at work send me (or my boss) spreadsheets to complete with protection that makes it more work than necessary. They get them back without protection but with this macro in a code module! And yes, I quote the URL in the comments.

    Regards,

    John Davies
[reply]

In Section Seekers of Perl Wisdom