saving html table into excel


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: saving html table into excel

  1. #1
    Join Date
    Apr 2006
    Posts
    16

    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

    Regards
    Rahul Vyas

  2. #2
    Join Date
    Feb 2006
    Location
    Cologne - Germany
    Posts
    271
    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
    Location
    Cologne - Germany
    Posts
    271
    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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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