How to export DataTable to Excel Worksheets ?

[kelvinweb]

Hi All,

How can I export multiple datatables to multiple excel worksheets ?

For example,
10xDataTables export to 10xWorksheets at the same Ms Excel File.

Please help.

 

[Goofy]

use the write xml method of the dataset and then import them into excel

 

[Mark Rae]

How can I export multiple datatables to multiple excel worksheets ?

For example,
10xDataTables export to 10xWorksheets at the same Ms Excel File.

Goofy's suggestion is a good one. Alternatively, you could use something
like this: http://www.aspose.com/Products/Aspose.Cells/Default.aspx

Under no circumstances even contemplate using COM automation.