wood burning stoves*
The moose likes Java in General and the fly likes Dynamically export data from database to excel Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » Java in General
Bookmark "Dynamically export data from database to excel" Watch "Dynamically export data from database to excel" New topic
Author

Dynamically export data from database to excel

Mary Sushma
Greenhorn

Joined: Nov 20, 2012
Posts: 2


Hi,

I am working on a requirement from which i need to export the report data to an excel sheet. The data on the UI is displayed by getting the data from a database table. Here the table headers are also dynamically taken.

How can i get that table data and convert it to an object which has some data and render it in an excel sheet.

Please provide the response.
Steve Luke
Bartender

Joined: Jan 28, 2003
Posts: 4181
    
  21

You will need to use a library which knows how to write Excel files. There are a couple including Aspose and Apache POI


Steve
Mary Sushma
Greenhorn

Joined: Nov 20, 2012
Posts: 2
Hi,

Thank you for the URL. It was usefull, however in some demos given i was not able to view the source code as in how they have implemented it.

In this URL http://www.aspose.com/demos/ssrs-rendering-extensions/aspose.cells/demo.aspx

they have given a very good demo but i was not able to view the code. Can you please share me the code to my above query to export the excel dynamically from the database table.
Steve Luke
Bartender

Joined: Jan 28, 2003
Posts: 4181
    
  21

Hi Mary,

If you want the code for the demo you quote - you should look on the Aspose site or contact their support to see if it is provided someplace.
 
Consider Paul's rocket mass heater.
 
subject: Dynamically export data from database to excel