Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

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
Replies are listed 'Best First'.
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?

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

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (7)
As of 2016-02-09 12:32 GMT
Find Nodes?
    Voting Booth?

    How many photographs, souvenirs, artworks, trophies or other decorative objects are displayed in your home?

    Results (313 votes), past polls