File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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.
, 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
I agree. Here's the link:
subject: saving report as an excel file
Problem while uploading an image using UploadBean
Html to database
Data Display problem in JSP.
JSP Help Regarding the Radio Button
How to keep the selected value ?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015