You should ask questions on the list ([EMAIL PROTECTED]), instead
of pulling individual people off the list.

The simplest way to do what you ask is just to add the following near the
top of your JSP page

<% response.setContentType( �application/vnd-msexcel�); %>

Then just make the web page contain a single table. You can apply most
formatting styles, and you can use thead elements. The setContentType will
make the page open in Excel.

If you need more than a single sheet, or if you need something more
complicated than a single table, you can use POI. You can even use POI for
the simple case but the steps might be more complicated. If you are new to
Java, you have a big learning curve. You might start with

http://www.devx.com/Java/Article/17301?




-----Original Message-----
From: Terrence Lai Mun Tak [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 08, 2004 10:16 PM
To: [EMAIL PROTECTED]
Subject: RE: jsp data into Excel

Hi Michael

I found the thread which you replied to Srilatha dated 30 Dec 2003 on the
export of HTML content from JSP to Excel.

I am currently trying to do the same with a JSP form that will append
information to an Excel file upon clicking on the Submit button.

However, I am not familiar with the codes as to how to create the objects,
and appending to the file (I am ASP-trained but the server we have is Unix,
which is why I have to use JSP). Would appreciate it if you could guide me
on this or direct me to a site where I can find the relevant code references
that I require.

Thanks in advance!

Regards
Terrence Lai
Singapore

Reply via email to