How to export the html table contents (records) to an Excel file.

Hi, I have webpage (.jsp) which lists out 4 to 5 records (having say 4 to 5 columns) inside html table tag. This page, has an Export button, at the bottom. On click of this button, I need to export the records (that the current page is displaying) to an .xls (Excel format) file. Shall be

Re: How to export the html table contents (records) to an Excel file.

Hi, The following link is a very good solution - http://jakarta.apache.org/poi/hssf/index.html Regards, Janarthan S [EMAIL PROTECTED] wrote: Hi, I have webpage (.jsp) which lists out 4 to 5 records (having say 4 to 5 columns) inside html table tag. This page, has an Export button, at the

Re: How to export the html table contents (records) to an Excel file.

Hi! Same question as mine!!! Well, I am currently trying to use Jakarta- POI classes. Do have a look . By the looks of it, you would need to use HFFS which is a set of classes to create/edit xls files. I have just started on it and seems promising. Viva Open Source! Richie At 02:36 PM 2/4/2004

RE: How to export the html table contents (records) to an Excel file - Are there are any POI jar from jakarta to be downloaded?.

hi, are there any .jar files for using jakarta-poi, that need to be placed in lib folder? thanks and regards, s.srikanth Jesse Alexander (KAID

RE: How to export the html table contents (records) to an Excel file - Are there are any POI jar from jakarta to be downloaded?.

Hi! Yes, you need to download the following and use the jar file present. http://nagoya.apache.org/poi/news/ This is the link for the 2.0 version. Use the jakarta-poi-1.5.1-final-20020615.jar jar . Put in WEB-INF/lib folder of your webapp. Richie At 03:31 PM 2/4/2004 +0530, you wrote: hi, are

Re: How to export the html table contents (records) to an Excel file.

response.setContentType(application/vnd.ms-excel); Assuming the end user has Excel installed and their browser accepts application/vnd.ms-excel, the data will be streamed to the client and the content will be opened by Excel. -- James Mitchell Software Engineer / Struts Evangelist

RE: How to export the html table contents (records) to an Excel file.

You could try the displaytag tag library on sourcefourge: http://displaytag.sourceforge.net. It includes nice table export functionality for excel, csv and xml. Regards, Andy Peck -Original Message- From: [EMAIL PROTECTED] pache.org [mailto:[EMAIL PROTECTED] akarta.apa che.org]On