PERL CGI Beginners - Help needed with Spreadsheet::ParseExcel

Author

Help needed with Spreadsheet::ParseExcel

Roland L Maynard

2004-05-22, 11:32 am

Hi, I am new to this list, but thought you all might be able to help me out.

I am trying to write a perl script to upload an excel spreadsheet to the server then parse certain information into a database. Anyhow, the trouble is that the Spreadsheet::ParseExcel module hangs when I try to parse the file (it uploads fine without pars
ing). I am able to upload other spreadsheet files just fine and parse them. Also, I opened the excel file that hangs in Open Office and saved it under a different name and that uploads and parses fine. Any suggestions on what might be causing this problem
? The hanging excel file is generated by "Webtrends" as a report. I tried just changing its name, but that does not work.

Thanks in advance for any suggestions.

Roland

________________________________________
____________________
Find what you are looking for with the Lycos Yellow Pages
http://r.lycos.com/r/yp_emailfooter...asp?SRC=lycos10

Brad Lhotsky

2004-05-22, 11:32 am

I had a similar experience with a spreadsheet that I had saved from Open
Office. Oddly enough, if I opened it in MS Excel, and saved it, and
reran said script, all was fine. I don't know what caused it.

I'd look into configuring a CellHandler subroutine and using that to
print how far along the parse gets before it hangs, then you could
atleast narrow the problem down. Actually, that's what I'm gonna do too
that next time I get chance..

sorry I couldn't be more of a help

On Tue, Apr 27, 2004 at 04:13:59PM -0400, Roland L Maynard wrote:
>
> Hi, I am new to this list, but thought you all might be able to help me out.
>
> I am trying to write a perl script to upload an excel spreadsheet to the server then parse certain information into a database. Anyhow, the trouble is that the Spreadsheet::ParseExcel module hangs when I try to parse the file (it uploads fine without pa
rsing). I am able to upload other spreadsheet files just fine and parse them. Also, I opened the excel file that hangs in Open Office and saved it under a different name and that uploads and parses fine. Any suggestions on what might be causing this probl
em? The hanging excel file is generated by "Webtrends" as a report. I tried just changing its name, but that does not work.
>
> Thanks in advance for any suggestions.
>
> Roland
>
>
>
>
>
>
> ________________________________________
____________________
> Find what you are looking for with the Lycos Yellow Pages
> http://r.lycos.com/r/yp_emailfooter...asp?SRC=lycos10
>
> --
> To unsubscribe, e-mail: beginners-cgi-unsubscribe@perl.org
> For additional commands, e-mail: beginners-cgi-help@perl.org
> <http://learn.perl.org/> <http://learn.perl.org/first-response>
>
>

--
Brad Lhotsky <brad@divisionbyzero.net>

Sponsored Links