Bug 40846

Summary: Write Excel file failed either with large data or lots of columns
Product: POI Reporter: FENG WAN <MIKE6930>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED INVALID    
Severity: major    
Priority: P1    
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   

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.