Re^2: password protet excel sheet

Replies are listed 'Best First'.
Re^3: password protet excel sheet by Mr. Muskrat (Canon) on May 11, 2012 at 21:20 UTC
No, it doesn't prompt for the password. If you want a password, simply pass it as the only argument to protect. In the code you supplied, you protected the worksheet with a password of 'test123'. Update: I may have misunderstood your question but runrig answered nicely.	[reply]
Re^3: password protet excel sheet by runrig (Abbot) on May 11, 2012 at 21:20 UTC
When I try to edit any cell, it does not prompt for password, but there is a popup that says something like "this worksheet is protected, you have to unprotect it to edit...". Maybe it depends on version of Excel?	[reply]
Re^3: password protet excel sheet by molecules (Monk) on May 11, 2012 at 21:32 UTC
For my copy of MS Excel 2010 (32-bit) on Windows 7 (64-bit), it works fine. Under this version, to unprotect it, click on "Review" and then click on "Unprotect worksheet". Then it prompts for a password.	[reply]
Re^4: password protet excel sheet by mangrove (Acolyte) on May 14, 2012 at 19:20 UTC
<Thanks for help.>	[reply]
Re^5: password protet excel sheet by mangrove (Acolyte) on May 14, 2012 at 19:26 UTC
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.	[reply]
Re^6: password protet excel sheet by molecules (Monk) on May 14, 2012 at 21:37 UTC