Exporting date from DataTable to Excel-file

[Dries]

Hello everyone,

I would like to export data from a DataTable to an Excel-file. I have
tried this using Interop (with the Microsoft.Inter op.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

[KJ]

Re: Exporting date from DataTable to Excel-file

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).