in reply to Re^4: password protet excel sheet
in thread password protet excel sheet

So is there any way in perl that I can password protect the excel file? I don't want to use the zip password protect either. So what I am trying to achieve is password protect a excel file that is created using Spreadsheet::WriteExcel. This code is written in unix platform but posted the file in windows.

Replies are listed 'Best First'.
Re^6: password protet excel sheet
by molecules (Monk) on May 14, 2012 at 21:37 UTC
    Not using Spreadsheet::WriteExcel. See the following clip from the POD for version 2.37:
    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.