Dynamically export data from database to excel

[Mary Sushma]

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]

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]

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]

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.