Re: Reading Excel

in reply to Reading Excel

My guess is also that opening the file fails.

Is the .xlsm-file you want to open really there? Have you tried opening it from the same directory your perl-script is in (so without a path)? In my experience Excel is sometimes picky related to path and path delimiters (slash vs. backslash).
In my scripts I always use $Excel->Workbooks->OpenXML instead of $Excel->Workbooks->Open. Maybe this works for you?

HTH, Rata

Comment on Re: Reading Excel Select or Download Code

Replies are listed 'Best First'.
Re^2: Reading Excel by ravi179 (Novice) on Jan 27, 2017 at 08:22 UTC
I want to open .XLSM only.i tried using OpenXML.But it didn't help.	[reply]
Re^3: Reading Excel by Corion (Patriarch) on Jan 27, 2017 at 09:17 UTC
How did using `->OpenXML()` fail for you? What was the error message? What was the script you used?	[reply] [d/l]
Re^4: Reading Excel by ravi179 (Novice) on Jan 27, 2017 at 09:29 UTC
I already posted the script i used.i changed only open to OpenXML.The error was ...Win32::OLE(0.1709) error 0x800a03ec in METHOD/PROPERTYGET "OpenXML" atC:\Read_XLSX.pl line 9	[reply]
Re^5: Reading Excel by Corion (Patriarch) on Jan 27, 2017 at 09:35 UTC
A reply falls below the community's threshold of quality. You may see it by logging in.

In Section Seekers of Perl Wisdom