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

["Jesse Alexander (KAID 11)" <al...@credit-suisse.com>]

Hi,

three choices:

- export the stuff to a CSV (comma separated value) file. Excelt usually
  reads that stuff perfectly
  - do not need any further libraries
  - does not support formatting of the data from the server side
- use POI (<http://jakarta.apache.org/poi/>)
  - exports real excel-files
- use OpenOffice
  - allows to export as excel
  - needs a X-Server on the server
  - needs special care (not all methods are thread save)

hth
Alexander

-----Original Message-----
From: ssrinivasrao@worldbank.org [mailto:ssrinivasrao@worldbank.org]
Sent: Mittwoch, 4. Februar 2004 10:07
To: Struts-User@jakarta.apache.org
Subject: 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 greatful if anyone can tip me on this.

Thanks,
S.Srikanth



---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org