in reply to Password Protect Excel File


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.

Replies are listed 'Best First'.
Re^2: Password Protect Excel File
by thimi3 (Initiate) on Nov 25, 2009 at 14:16 UTC
    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.

      Cheers - L~R

[reply]
        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