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\TestRead.pl "c:\test.xls"` [download] 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.	[reply] [d/l]
Re^4: Problems opening an Excel file... by olivierp (Hermit) on Feb 10, 2005 at 16:23 UTC
c:\perl\excel\TestRead.pl "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\openxl.pl "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\openxl.pl line 10` [download] HTH -- Olivier	[reply] [d/l] [select]