in reply to Spreadsheet::BasicRead - Open XLS Error???

You are using a relative path to open the Excel file. That is wrong. Your CGI program may have a different current directory when it is run.

  • Comment on Re: Spreadsheet::BasicRead - Open XLS Error???

Replies are listed 'Best First'.
Re^2: Spreadsheet::BasicRead - Open XLS Error???
by awohld (Hermit) on Sep 23, 2005 at 06:25 UTC
    With a direct path I get the same error. Also I have my CGI script in the same directory as my Excel file.
      While your CGI script may be in the same directory as the Excel file, the script may be running with a different directory as its current working directory. You can check this by adding:
      use Cwd; print cwd(), $/;
      to your CGI script.

      Additionally, your CGI script may be run as a user with less permissions on the system than you have. This is actually extremely common, especially to the directories which contain CGI scripts. This is a security measure against unauthorized people on the internet reading the code for your CGI scripts.

      I would recommend running the script from the Windows commandline and seeing if you still get the same error. If you don't, then it's a problem with how the webserver is running your script. If you get the same error, then it's something we can help investigate.


      My criteria for good software:
      1. Does it work?
      2. Can someone else come in, make a change, and be reasonably certain no bugs were introduced?