File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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/"); %>

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: 63866

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

[Asking smart questions] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: saving report as an excel file
It's not a secret anymore!