in reply to Reading Excel

My guess is also that opening the file fails.

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.