Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

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

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.

      How did using ->OpenXML() fail for you? What was the error message? What was the script you used?

        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:\ line 9

A reply falls below the community's threshold of quality. You may see it by logging in.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1180433]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (1)
As of 2023-03-31 00:37 GMT
Find Nodes?
    Voting Booth?
    Which type of climate do you prefer to live in?

    Results (74 votes). Check out past polls.