Bug 40846 – Write Excel file failed either with large data or lots of columns

Bug 40846 - Write Excel file failed either with large data or lots of columns


Summary:	Write Excel file failed either with large data or lots of columns

Status:	RESOLVED INVALID

Product:	POI
Classification:	Unclassified
Component:	HSSF
Version:	unspecified
Hardware:	PC Windows XP

Importance:	P1 major (vote)
Target Milestone:	---
Assigned To:	POI Developers List

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree

Reported:	2006-10-30 21:31 UTC by FENG WAN
Modified:	2006-10-31 02:43 UTC (History)
CC List:	0 users

Attachments
Add an attachment (proposed patch, testcase, etc.)

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.