Re: Reading Excel


P is for Practical
	PerlMonks

Re: Reading Excel

by Ratazong (Monsignor)

on Jan 27, 2017 at 07:06 UTC ( #1180433=note: print w/replies, xml )

Need Help??

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

Log In^?

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://1180433]
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others cooling their heels in the Monastery: (1)

Tux

As of 2023-03-31 00:37 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

Notices^?