Dynamically export data from database to excel

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.

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

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.

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.