Hi,
I am sending the data from jsp to excel. When I try to open the saved excel file,excel pops up the error message saying
HTML Import Errors
Problems came up in the following areas during load
Cell data too large
And then the file opens with all the data messed up.
How do I fix this issue?
Thanks
-
JSP to excel error (4 messages)
- Posted by: w d
- Posted on: August 28 2003 21:18 EDT
Threaded Messages (4)
- JSP to excel error by Paul Strack on August 29 2003 10:39 EDT
- JSP to excel error by wang ping on September 01 2003 21:23 EDT
- jsp to excel transfer of data by umesh gohil on April 14 2004 07:26 EDT
- a <table> tag is to blame by Vladimir Alexiev on February 03 2004 18:28 EST
-
JSP to excel error[ Go to top ]
- Posted by: Paul Strack
- Posted on: August 29 2003 10:39 EDT
- in response to w d
I find that the easiest way to get information into Excel is to save data as a tab-delimited file with the .xls extension. Maybe you should drop the HTML code. -
JSP to excel error[ Go to top ]
- Posted by: wang ping
- Posted on: September 01 2003 21:23 EDT
- in response to w d
use XML or jxl.jar -
jsp to excel transfer of data[ Go to top ]
- Posted by: umesh gohil
- Posted on: April 14 2004 07:26 EDT
- in response to wang ping
hello friends is there any one who can help me out of this problem
i want to transfer my data from my oracle database to excel file, is
there any way or not plz help me to solve this problem
thanks i adva my email id is [email protected] -
a <table> tag is to blame[ Go to top ]
- Posted by: Vladimir Alexiev
- Posted on: February 03 2004 18:28 EST
- in response to w d
Problems came up in the following areas during load
> Cell data too large
> And then the file opens with all the data messed up.
I got this error, but it says "HTML ERROR in Cell data too large" (Excel 2000).
The reason is a <table> tag in a cell text. Stupid excel tries to interpret the <table> tag. I suppose you need to escape (mangle) such tags somehow, eg turn them into "[table]".
My file is named TDV and is tab-delimited. But whether you name the file TXT or XLS makes no difference. I haven't tried with CSV.
> use XML
Maybe the guy is right: if Excel is so brazen as to try to interpret our plain text as <table>, we should play by its stupid rules and do XML. But for now, I'll try to disable its stupid interpretation of <table>.