aspose file tools*
The moose likes JSP and the fly likes Exporting Excel from jsp:  response.setContentType(); Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Reply locked New topic
Author

Exporting Excel from jsp: response.setContentType();

Alicia Logan
Greenhorn

Joined: Aug 24, 2005
Posts: 14
Actually, iam exporting data from a jsp using response.setContentType("application/vnd") and the format of the data for example i have a field named Model Number which is say 4-4-3, it is getting converted into 04/04/2003 when i open the Excel to view the exported data. Now what you have suggested is something that a user can do after the excel has been saved but i want a solution that will retain the format of the data just as it is written onto the Excel sheet. Hope i get the solution ASAP.
Ben Souther
Sheriff

Joined: Dec 11, 2004
Posts: 13410

Your original thread (which asks this question) got moved to General Computing because this has nothing to do with JSP. Your Excel sheet would have this issue no matter what server side technology created it.

http://www.coderanch.com/t/132206/gc/excel-formatting
[ August 24, 2005: Message edited by: Ben Souther ]

Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Exporting Excel from jsp: response.setContentType();
 
Similar Threads
help me Xsl in struts2?
JSP to Excel - beginner
Export data to Excel in Websphere Portals
Character Encoding
Excel-format report