DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006

    saving html table into excel

    Hi all,

    I am generating one html table by fetching the data from backend now i want to save it in the excel file means how to download that content into excel on the client machine

    Rahul Vyas

  2. #2
    Join Date
    Feb 2006
    Cologne - Germany
    you will have to set the content-type of your response by setting it to "application/???", have a look at the mimetype definitions in the internet (eg. rfc). when you set the right mimetype to the clientside, you can stream the binary excelsheet through the servlets ouputstream. however, an easier way is to send it as a comma seperated values.

  3. #3
    Join Date
    Feb 2006
    Cologne - Germany
    by the way, the displaytag jsp library at http://displaytag.sourceforge.net/ supports to generate fantastic sortable views of any data (eg from database), with support of conversion to csv, xml and many other formats. it also supports paging for results. give it a try.

Similar Threads

  1. query tuning
    By dhaya in forum Database
    Replies: 11
    Last Post: 08-25-2003, 05:24 PM
  2. Saving XML data into a table
    By Prasanna in forum XML
    Replies: 2
    Last Post: 11-19-2002, 07:28 PM
  3. Save figure table to Excel file
    By Mahendra Gunawan in forum VB Classic
    Replies: 1
    Last Post: 05-02-2001, 07:55 AM
  4. Stored Proc and Excel table
    By Mario Morin in forum Database
    Replies: 0
    Last Post: 01-12-2001, 10:50 AM
  5. Saving a recordset to a table
    By John in forum VB Classic
    Replies: 2
    Last Post: 04-14-2000, 01:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.