Bug 40846 - Write Excel file failed either with large data or lots of columns
Write Excel file failed either with large data or lots of columns
Status: RESOLVED INVALID
Product: POI
Classification: Unclassified
Component: HSSF
unspecified
PC Windows XP
: P1 major (vote)
: ---
Assigned To: POI Developers List
:
Depends on:
Blocks:
  Show dependency tree
 
Reported: 2006-10-30 21:31 UTC by FENG WAN
Modified: 2006-10-31 02:43 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description FENG WAN 2006-10-30 21:31:49 UTC
I am using POI to create an Excel file using the data from SQL statement. 
First error scneario: I have roughly 40 columns and if I tried to run report 
of 900 rows, the web browser flashed by and displayed a blank page. No error 
message in server log, just showing getting a connection and hang in there...
Largest value inserted into cells is like 200 byttes...
Second error scenrio: A new requirement asks for 67 columns. Now even with 
just one row, the web browser flashed by and displayed a blank page. No error 
message in server log, just showing getting a connection and hang in there...
Comment 1 Nick Burch 2006-10-31 02:43:31 UTC
You should first try fetching your file with something like wget, and trying to
open the saved file. That'll tell you if it's a problem with your excel
generation, or with how you're passing it to the browser.

If wget works, then you'll need to check the list archives. There's lots on
there on the best way to tell browsers (especially IE) that it's an excel file.

If it doesn't work via wget, then you need to fix your generation logic.