jimijq has asked for the wisdom of the Perl Monks concerning the following question:

After using ParseExcel for 14 months, I've finally encountered an .xls file with a password. How do I open/parse it? I see no mention of passwords in ParseExcel.pm or its documentation. Jim Fox

2006-06-27 Retitled by Corion, as per Monastery guidelines
Original title: 'ParseExcel: PW's'

Replies are listed 'Best First'.
Re: ParseExcel: files with passwords
by Limbic~Region (Chancellor) on Jun 26, 2006 at 22:36 UTC
    jimijq,
    I see no mention of passwords in ParseExcel.pm or its documentation.

    Perhaps you missed the TODO section where it states this is unimplemented. Unfortunately, I do not believe this module is being actively maintained. One option on a Win32 machine is to use Win32::OLE but I do not have an example for you.

    Cheers - L~R

      ... or help to implement this on 'Spreadsheet::ParseExcel' :) !!

      Solli Moreira Honorio
      Sao Paulo - Brazil
Re: ParseExcel: files with passwords
by shonorio (Hermit) on Jun 26, 2006 at 22:37 UTC
    If you are talking of Spreadsheet::ParseExcel, password protected data is not supported for now. It's on "To do" section.

    Solli Moreira Honorio
    Sao Paulo - Brazil