Re^5: win32::ole runs under cmd line but not cgi

Running an Excel spreadsheet macro inside the webserver seems a very bad idea to me. It will involve so much overhead that response times will suffer.

Can you log in on the server using the credentials of the web-server? Are you then able to open the spreadsheet and run the macro?

CountZero

A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

My blog: Imperial Deltronics

Comment on Re^5: win32::ole runs under cmd line but not cgi

Replies are listed 'Best First'.
Re^6: win32::ole runs under cmd line but not cgi by Anonymous Monk on Apr 18, 2013 at 08:18 UTC
It will involve so much overhead that response times will suffer. Sure, if you do it without Proc::Background, Highlander: one instance at a time (Oct 00), Watching long processes through CGI (Aug 02)	[reply]
Re^7: win32::ole runs under cmd line but not cgi by suzun30 (Acolyte) on Apr 18, 2013 at 19:08 UTC
Hi, Thanks for the response. I am able to open and run the macro when Iam logged in the server using the same windows authentication. Thanks for the pointers to the other perl modules for faster execution. But this problem seems to be getting too big than it needs to be :( ..Appreciate any insights! Thanks!	[reply]
Re^8: win32::ole runs under cmd line but not cgi by Anonymous Monk on Apr 19, 2013 at 07:49 UTC
But this problem seems to be getting too big than it needs to be :( ..Appreciate any insights! Get professional help :) win32/ole/...everything is a PITA if you don't have the right kind of experience (I don't have it)	[reply]
Re^9: win32::ole runs under cmd line but not cgi by suzun30 (Acolyte) on Apr 23, 2013 at 22:00 UTC
Re^10: win32::ole runs under cmd line but not cgi by Anonymous Monk on Sep 19, 2015 at 18:17 UTC
Re^8: win32::ole runs under cmd line but not cgi by suzun30 (Acolyte) on Apr 19, 2013 at 17:34 UTC
Also, it is a windows server on which I have apache. My webpage needs to generate excel reports with huge bulk of data, so going this route. appreciate any inputs to the right direction to getting this issue resolved. Appreciate it much.	[reply]