Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re^3: password protet excel sheet

by molecules (Monk)
on May 11, 2012 at 21:32 UTC ( #970106=note: print w/ replies, xml ) Need Help??


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

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.


Comment on Re^3: password protet excel sheet
Re^4: password protet excel sheet
by mangrove (Novice) on May 14, 2012 at 19:20 UTC
    <Thanks for help.>

      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.

        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.
        

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://970106]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (8)
As of 2015-07-06 07:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (70 votes), past polls