Re: Spreadsheet:: WriteExcel

If nothing has changed in the script or the Perl version on the server - could it realistically be the code or the Spreadsheet::WriteExcel module?

I've converted websites from IIS5 (Win2k) to IIS6 (Win2k3) and magically my scripts (.BAT, .PL, etc...) stop working. It had to do with permissions on the directories the scripts were in, the fact that the .BAT scripts specifically execute via CMD.EXE (which lives in %systemroot%\system32 - a NO-NO for IIS6) and the permissions for the user account running the IIS WWWW service.

Once I straightened out M$ security issues, my scripts ran fine again

Comment on Re: Spreadsheet:: WriteExcel

Replies are listed 'Best First'.
Re^2: Spreadsheet:: WriteExcel by gb123z (Initiate) on Mar 12, 2009 at 18:11 UTC
I probably titled this node incorrectly and/or explained my issue incorrectly. I agree, I don't think the issue is with the code itself or Spreadsheet::WriteExcel. I have set the permission on the directory where I have the scripts for now to give 'everyone' full control to try to resolve the issue. My original code runs, but saves the excel file to the server and doesn't make it available to the client. Does it sound like I still have a permission issue somewhere?	[reply]
Re^3: Spreadsheet:: WriteExcel by VinsWorldcom (Prior) on Mar 13, 2009 at 14:13 UTC
It's been a while since I used IIS - or any web server for that matter - but does IIS understand the MIME type you're using and how to handle it? Also, the client side browser is going to have to launch an ?ActiveX control? to view the Excel sheet in the browser? I will need to understand how to handle Excel files, correct?	[reply]