Re^3: Reading Excel

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

Comment on Re^3: Reading Excel Download Code

Replies are listed 'Best First'.
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
Normally if i open in Excel it is opening.When iam trying to open it using Perl Script it is not opening	[reply]
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
Re^8: Reading Excel by ravi179 (Novice) on Jan 30, 2017 at 04:45 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]