Excel and password protection

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • timkenx
    New Member
    • Dec 2006
    • 4

    Excel and password protection

    hi guys, i am new to perl and I have a question about excel.

    I am using the Spreadsheet:Par seexcel module to open a workbook and read data from it. My problem is that the workbook is password protected and I cannot access it. Does anyone have any solutions to this? There is no way that I can remove the protection.
  • miller
    Recognized Expert Top Contributor
    • Oct 2006
    • 1086

    #2
    Originally posted by timkenx
    hi guys, i am new to perl and I have a question about excel.

    I am using the Spreadsheet:Par seexcel module to open a workbook and read data from it. My problem is that the workbook is password protected and I cannot access it. Does anyone have any solutions to this? There is no way that I can remove the protection.
    No.

    There is no utility currently available to access a password protected excel workbook.

    Obviously you know the password, so open the workbook and save-as without the password. I've had to do this myself.

    Comment

    Working...