Hi all,
Sorry I bring up this question again. I didn't find the exactly answer from the
archive.
I have a servlet that retrieve result from the database. I want to export the
result to Excel.
Here is my partial code:
response.setContentType("application/cnd.ms-excel");
pw.println("<PRE>");
response.setHeader( "Content-disposition", "attachment;filename=file.xls");
pw.println("</PRE>");
This code works fine in terms of launching the Excel sheet. But the problem I
have is that
all the results appear in the first cell on each row, rather that one item per
cell. I tried comma, tab to delimited each data but failed. Can any one help?
Thanks a lot.
Tiana
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html