Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options

Re^2: Problems opening an Excel file...

by olivierp (Hermit)
on Feb 10, 2005 at 11:33 UTC ( #429662=note: print w/replies, xml ) Need Help??

in reply to Re: Problems opening an Excel file...
in thread Problems opening an Excel file...

To complement lmcmanamra's point, 2 other things that can cause this are "/" in the path instead of "\", and opening twice the same file name.
  • Comment on Re^2: Problems opening an Excel file...

Replies are listed 'Best First'.
Re^3: Problems opening an Excel file...
by mrdowns (Initiate) on Feb 10, 2005 at 15:50 UTC
    Thanks for your comments. Unfortunately, after some double-checking, none of these seem to be the problem. Here's what the command line looks like:
    c:\perl\bin\perl.exe c:\perl\excel\ "c:\test.xls"
    When I run this from the command line, it works perfectly. When I call it from SQL Server, it fails with the above error.
    I'm especially weirded out by the fact that I'm not getting an error description. That or the description is a series of 4 spaces, which is the crappiest description ever. I blame Microsoft.
      c:\perl\excel\ "c:\test.xls"
      Wild guess. Could \t be perchance translated to a tab, leading your script to open c:\   est.xls
      Try  my $file = "c:\test.xls" in your snippet, and you should get something like this:
      P:\>c:\temp\ "c:\temp\test.xls" OLE exception from "Microsoft Office Excel": 'c: emp est.xls' could not be found. Check the spelling of the + file name, and verify that the file location is correct. If you are trying to open the file from your list of most recently use +d files on the File menu, make sure that the file has not been renamed, +moved, or deleted. Win32::OLE(0.1702) error 0x800a03ec in METHOD/PROPERTYGET "Open" at c:\temp\ line 10

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://429662]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (6)
As of 2017-10-22 01:48 GMT
Find Nodes?
    Voting Booth?
    My fridge is mostly full of:

    Results (271 votes). Check out past polls.