File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
    Bookmark Topic Watch Topic
  • New Topic

Exporting Excel from jsp: response.setContentType();

 
Alicia Logan
Greenhorn
Posts: 14
  • 0
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
Posts: 13411
Firefox Browser Redhat VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Report post to moderator
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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
    Bookmark Topic Watch Topic
  • New Topic