Problems of Perl program with Spreadsheet::ParseExcel module

[goomania]

My php script is to call Perl program which makes use of
Spreadsheet:arseExcel module to parse Excel file. I am able to launch

php script from command line so that Perl program run and properly
parse Excel file. However, when I put php script on server side and
then launch php through client request, perl program can't run.

My server does have Spreadsheet:arseExcel module and Perl installed.
Indeed I ran the Perl program that uses Spreadsheet:arseExcel module
on command line on server machine, and it ran smoothly. However, when I

called the same Perl program from PHP (using exec()) through web
request, Perl program can't run (but PHP produced no error message to
the client browser). I got rid of "use Spreadsheet:arseExcel;" in
Perl program, and then call the modified Perl program from PHP through
web request, the Perl program ran smoothly.

Not only this happened when I include Spreadsheet:arseExcel module,
but also for modules like Tk. Whenever I use Tk or Tk:ialogBox
modules, the Perl program can't run properly when I call it through web
request even though they run perfectly from the command line on the
same server machine.

Any suggestion re how to fix this problem? Thanks a lot,

-Ying

 

[rajeev]

sorry this may sound silly, but did you happen to run the script from
command without the perl interpreter.

My guess is that either your file is not set as executable or
interpreter is spelled out in the first line correctly.

 

[goomania]

Thanks for suggestions. I had no problem running Perl scripts from
command line, therefore it should not be a problem with Perl
interpreter or not setting file executable. And I put the Perl script
on the web server that runs Apache and use PHP to call those Perl
script upon user's request on client side. I don't have problem running
Perl script through PHP via web request, as long as the Perl script
does not use modules like Spreadsheet:arseExcel or Tk:ialogBox .
However, when I did use those modules in my Perl scripts and launch
those Perl script through PHP via web request, then Perl script stopped
running.

I am guessing this probably has something to do with the fact that the
Perl environment is not the same between being invoked by command line
and being invoked through web server. But I am not sure about the true
reason and re how to fix the problem.

Help...

-Ying

 

[bate_G]

Hi,
I have the same problem, but with some excel files works, with other
not. The excel format is the same. Any ideas!?

thanks,

bate_G