I've used this method a few times, but I thought that you needed to include
the data in an HTML table to make it work - or so it says in Marty Halls
Core Servlets. Has anyone been able to use this method to include, in
addition to the data, formatting instructions (i.e. change the color of a
cell) or formulae.
Regards
Roger Varley
-----Original Message-----
From: Kevin Lin <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: 05 October 2001 17:59
Subject: Re: Java to excel
If you are talking about use Servlet to generate Excel file on the Web.
Here is another way without use a .CSV file.
1. set your output content type as something like this:
response.setHeader("Content-Disposition","attachment");
response.setContentType("application/vnd.ms-excel");
2. use '\t' and '\n' as something like this:
m_ObjectData(iRow,iCol,i,allObjs);
sb.append("\r\n");
3. output to screen as something like this:
out.println(sb.toString());
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
___________________________________________________________________________
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
