jQuery in Action, 3rd edition
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
JavaRanch » Java Forums » Engineering » HTML, CSS and JavaScript
Bookmark "saving report as an excel file" Watch "saving report as an excel file" New topic

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

Joined: Jan 10, 2002
Posts: 63344

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
jQuery in Action, 3rd edition