in reply to Re: Read XLSX Files
in thread Read XLSX Files

I have the XLSX.pm module installed in C:\Perl\site\lib\Spreadsheet
Also Utility2007.pm & Fmt2007.pm are installed in C:\Perl\site\lib\Spreadsheet\XLSX

I tried modifing the 4th line as shown below:
#my $workbook = $xl_app->Workbooks->Open($xls_file);
my $workbook = $xl_app->XLSX->Open($xls_file);

But received the following error when the script ran:
Can't call method "Open" on an undefined value at "script location"

So this is where I was thinking I needed something else to open the file instead of just the word Open.

Replies are listed 'Best First'.
Re^3: Read XLSX Files
by Corion (Patriarch) on Apr 22, 2009 at 15:58 UTC

    You didn't read the documentation of Spreadsheet::XLSX, did you?

    Win32::OLE is a vastly different thing that Spreadsheet::XLSX. You can't easily replace one by the other without rewriting at least parts of your program. Maybe it's time for you to understand what your old program is doing and to rewrite the parts according to the Spreadsheet::XLSX documentation.

[reply]

In Section Seekers of Perl Wisdom