in reply to Re^3: win32::ole runs under cmd line but not cgi
in thread win32::ole runs under cmd line but not cgi

I know this has been a long time, I am facing similar issue. Is there a common approach for this issue? Although I am not getting the error as stated here, I am still not able to open the file and my code dies when executed via the webserver. Also, I am authenticating my users using SSPI. So I do have the remote_user variable set. But does not seem to help in authenticating for file access via Win32::OLE. Any other way to run a macro from .xlsm file in perl?
  • Comment on Re^4: win32::ole runs under cmd line but not cgi

Replies are listed 'Best First'.
Re^5: win32::ole runs under cmd line but not cgi
by CountZero (Bishop) on Apr 16, 2013 at 18:13 UTC
    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
[reply]
[reply]
        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]

In Section Seekers of Perl Wisdom