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.
| [reply] |
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] |