Using Perl to access Excel File

[chicateer]

I am trying to read an Excel file that has a password. When I use the Workbooks->Open(filename,,,,password,) statement, i get an error ""unable to get the Open property of the Workbooks class"

any help would be appreciated

thanks

 

[PaulTEG]

This would seem to be a problem with the spreadsheet not wanting to open to unauthorised users

Code would help, of course, obfuscate usernames and password details

--Paul

 

[chicateer]

Paul, thanks for your response.
I enclose a sample version of the code that keeps failing
Appreciate any help that you can give on this one.

thanks,

use Win32::OLE qw(in with);
use Win32::OLE::Const 'Microsoft Excel';
$Win32::OLE::Warn = 3; # die on errors...
$test = 0;
$filename = 'c:\test.xls';
$ps = 'xx';
my $Excel = Win32::OLE->GetActiveObject('Excel.Application')|| Win32::OLE->new('Excel.Application', 'Quit');
my $Book = $Excel->Workbooks->Open($filename,,,,$ps);
$k = $Excel->Workbooks->Count;
print "$k\n";

 

[siberian]

Does it fail on ALL workbooks or just this particular workbook?

If you want ot use Excel::WorkBook over the ActiveX objects it may bypass windows security features and do what you need it to

 

[chicateer]

yes, it fails on all workbooks - Did not quite understand your comment of using the Excel::Workbook over ActiveX objects. Would appreciate some further details

thanks

 

[siberian]

Here are some links. I have used these on many projects with great success but under UNIX and not Windows.

http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-0.42/WriteExcel.pm

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

 

[Swamphen]

You may or may not have noticed that using
"my $Book = $Excel->Workbooks->Open($filename);"
apparently works fine.

Where do you find a list of the functions to be called on the OLE objects and their syntax? I suppose this can't be found with perldoc.

Greetings,
Swamphen

 

[chicateer]

yes, I am able to open workbooks that do not have a password, it's the one's with the password that fail me.

You can get OLE related documentation from the ActiveState site

http://aspn.activestate.com/ASPN/docs/ActivePerl/OLE-Browser/Browser.html