|Just another Perl shrine|
Win32::OLE Excel issueby sgp_perl_user (Initiate)
|on Feb 02, 2012 at 06:03 UTC||Need Help??|
sgp_perl_user has asked for the
wisdom of the Perl Monks concerning the following question:
I encountered a problem while developing my PERL script which reads Excel files and do some calculations. I use ActivePerl 5.14.2 Build 14R02 on Windows XP (I am not asking you to help debug ActivePerl but just to provide full info).
Is there a bug list for Win32::OLE that documents issues with Excel?
If there is a more appropriate forum to raise this question, please let me know.
Note that the code was working before (and I saved old versions of the working code).
All of a sudden the script fails on opening the Excel workbook using the call $in_Excel->Workbooks->open($workbook) & $workbook is the workbook filename . This is the error message: "Can't call method "Worksheets" on an undefined value at xls2csv.pl line 15"
I put a "print $workbook; " statement before the call and the proper filename (residing in the same directory). Running the old working code gets me the same error.