|jsp data into Excel|
jsp data into Excel 2004-01-08 - By Michael Zalewski
You should ask questions on the list (poi-user@(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
-- --Original Message-- --
From: Terrence Lai Mun Tak [mailto:terence_lai@(protected)]
Sent: Thursday, January 08, 2004 10:16 PM
Subject: RE: jsp data into Excel
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!
Earn $52 per hosting referral at Lunarpages.