The Artima Developer Community
Articles | News | Weblogs | Books | Forums
Artima Forums | Articles | Weblogs | Java Answers | News
Sponsored Link •

Java Answers Forum
JSP to excel error

4 replies on 1 page. Most recent reply: Aug 31, 2003 7:23 PM by Charles Bell

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 4 replies on 1 page
WD

Posts: 4
Nickname: webdevil
Registered: Aug, 2003

JSP to excel error Posted: Aug 28, 2003 6:15 PM
Reply to this message Reply
Advertisement
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


David

Posts: 150
Nickname: archangel
Registered: Jul, 2003

Re: JSP to excel error Posted: Aug 29, 2003 4:01 AM
Reply to this message Reply
Can you open the excel file normally?

WD

Posts: 4
Nickname: webdevil
Registered: Aug, 2003

Re: JSP to excel error Posted: Aug 29, 2003 7:45 AM
Reply to this message Reply
Yes,I can open other excel files without any problem.

Senthoorkumaran Punniamoorthy

Posts: 335
Nickname: senthoor
Registered: Mar, 2002

Re: JSP to excel error Posted: Aug 29, 2003 6:39 PM
Reply to this message Reply
Did you try to use POI from Jakarta?

Here is a small description about POI from the site itself.

-----------------------------------

Set of APIs for creating, reading, and writing files based upon the OLE 2 Compound Document Format using only Java (no native stuff). Currently, OLE 2 Compound Document Format itself and Microsoft Excel (XLS) file formats are provided.

-------------------------------------

http://jakarta.apache.org/poi/index.html

Charles Bell

Posts: 519
Nickname: charles
Registered: Feb, 2002

Re: JSP to excel error Posted: Aug 31, 2003 7:23 PM
Reply to this message Reply
If you export your data as a comma separated value text file, you can read it in Excel.

Flat View: This topic has 4 replies on 1 page
Topic: game programming Previous Topic   Next Topic Topic: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorExcept
Sponsored Links


Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use