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

With a direct path I get the same error. Also I have my CGI script in the same directory as my Excel file.
  • Comment on Re^2: Spreadsheet::BasicRead - Open XLS Error???

Replies are listed 'Best First'.
Re^3: Spreadsheet::BasicRead - Open XLS Error???
by dragonchild (Archbishop) on Sep 23, 2005 at 13:08 UTC
    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?