A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
saving report as an excel file
Joined: Sep 27, 2004
Dec 13, 2006 09:40:00
I have a report, which I need to save as an
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.
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.
Author and ninkuma
Joined: Jan 10, 2002
Dec 13, 2006 10:00:00
I don't think that you are missing anything. Excel is probably providing its own formatting of the data.
Asking smart questions
Books by Bear
Did you see how Paul
cut 87% off of his electric heat bill with 82 watts of micro heaters
subject: saving report as an excel file
Data Display problem in JSP.
Problem while uploading an image using UploadBean
Html to database
How to keep the selected value ?
JSP Help Regarding the Radio Button
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013