Reading Excel file protected

[danvzla]

Hi experts,

I'm trying to read an excel file password protected using the module "Spreadsheet:arseExcel::Simple". Somebody did this question before but nobody answered

It works fine if the excel file is unprotected. But, if it has the option "Protect and Share workbook activated, the script fails"


use Spreadsheet:arseExcel::Simple;
use OLE::Storage_Lite;


my $workbook = Spreadsheet:arseExcel::Simple->read($excel_file);
my $worksheet = ($workbook->sheets())[2];

while ($worksheet->has_data()) {
my @fields = $worksheet->next_row();
$field1="$fields[1]";
$field2="$fields[2]";
$field3="$fields[3]";
}

I am using Excel 2000.

Thank you

 

[philote]

Looks like you can't access protected spreadsheets yet. Look at the ToDo section in the doc:

http://search.cpan.org/~kwitknr/Spreadsheet-ParseExcel-0.2602/ParseExcel.pm#TODO