aspose file tools*
The moose likes HTML, CSS and JavaScript and the fly likes saving report as an excel file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Engineering » HTML, CSS and JavaScript
Bookmark "saving report as an excel file" Watch "saving report as an excel file" New topic
Author

saving report as an excel file

JayaSiji Gopal
Ranch Hand

Joined: Sep 27, 2004
Posts: 303
I have a report, which I need to save as an excel file.

The data is in a bean.
I retrieve the data from the bean, store in an arraylist. set the arraylist as an attribute of request.

in the jsp, i retrieve the list from the request attribute, iterate and store the contents in a stringbuffer.

the string buffer is as follows:

<TR><TD align='center' bgcolor='#C0C0C0'>09-05</TD><TD align='center' bgcolor='#C0
C0C0'>036EL0509662B</TD><TD align='center' bgcolor='#C0C0C0'>036</TD><TD align='center' bgcolor='#C0C0C0'>03605626</TD><TD align='center' bgcolor='#C0C0C0'>11
/28/2006</TD><TD align='center' bgcolor='#C0C0C0'>BP</TD><TD align='center' bgcolor='#C0C0C0'>09/22/2006</TD><TD align='center' bgcolor='#C0C0C0'>MOUNTAIN STA
TES </TD> </TR>

The response type is :

<% response.setContentType("application/vnd.ms-excel"); %>

However, when I see the data in the excel file, 09-05 becomes 5-sep, 036 becomes 36 and 03605626 becomes 3605626.

What am i missing?


SCJP 1.4, SCWCD 1.4<br /> <br />Thanks in advance!<br />Jayashree.
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61064
    
  66

I don't think that you are missing anything. Excel is probably providing its own formatting of the data.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: saving report as an excel file