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 parsing). 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/http://yellowpages.lycos.com/default.asp?SRC=lycos10 > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > <http://learn.perl.org/> <http://learn.perl.org/first-response> > > -- Brad Lhotsky <[EMAIL PROTECTED]> -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
