Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Dynamically export data from database to excel

 
Mary Sushma
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


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
Posts: 4181
22
IntelliJ IDE Java Python
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You will need to use a library which knows how to write Excel files. There are a couple including Aspose and Apache POI
 
Mary Sushma
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 4181
22
IntelliJ IDE Java Python
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic