Re^2: Reading Excel

Replies are listed 'Best First'.
Re^3: Reading Excel by poj (Abbot) on Jan 27, 2017 at 09:27 UTC
Can you open the file in Excel ?. Run this to show the versions you have `#!perl use strict; use warnings; use Win32::OLE qw(in with); # get already active Excel application or open new my $Excel = Win32::OLE->GetActiveObject('Excel.Application') \|\| Win32::OLE->new('Excel.Application', 'Quit'); print "Perl $] Win32::OLE Version ${Win32::OLE::VERSION}\n"; print "Running Excel $Excel->{'Version'} on $Excel->{'OperatingSystem +'}\n";` [download] poj	[reply] [d/l]
Re^4: Reading Excel by ravi179 (Novice) on Jan 27, 2017 at 10:07 UTC
perl 5.008009 Win32::OLE version 0.1709....Running Excel 15.0 on. I am unable to deal with Excel also..Same error is coming in both the cases.	[reply]
Re^5: Reading Excel by Corion (Patriarch) on Jan 27, 2017 at 10:09 UTC
If Excel cannot open the file, Perl-using-Excel will not be able to open the file either.	[reply]
Re^5: Reading Excel by marto (Cardinal) on Jan 27, 2017 at 10:34 UTC
The lesson here is to check your input data and not make assumptions. If Excel can't open the file how would calling Excel using Perl be any different?	[reply]
Re^6: Reading Excel by ravi179 (Novice) on Jan 27, 2017 at 11:52 UTC
Re^7: Reading Excel by marto (Cardinal) on Jan 27, 2017 at 11:57 UTC
Re^7: Reading Excel by poj (Abbot) on Jan 27, 2017 at 12:03 UTC
Some notes below your chosen depth have not been shown here
Re^5: Reading Excel by huck (Prior) on Jan 27, 2017 at 11:55 UTC
perl 5.8.9 is rather old, you should try updating your perl	[reply]