Exporting date from DataTable to Excel-file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dries - 30 Dec 2005 23:34 GMT

Hello everyone,

I would like to export data from a DataTable to an Excel-file. I have
tried this using Interop (with the Microsoft.Interop.Office.Excel.dll)
but that seems to be a hard job.

Does any of you know another way to do this?

If not, I will have to get trough the Interop...

Kind regards,
Dries

Reply to this Message

KJ - 31 Dec 2005 02:02 GMT

You might consider serializing the datatable (or dataset) contents to
xml, then transforming the xml to html, which excel understands (excel
may also understand specific dialects of xml as well).

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...