Exporting date from DataTable to Excel-file

  • Thread starter Thread starter Dries
  • Start date Start date
D

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

C# export excel chart to image and send it an email 5
Adding Reference to Excel - which one? 3
Adding datatable data to sql database. 1
Excel Interop problem 4
Excel datatable row limit? Please help! 5
DataTable date issue 3
Merging two DataTables in same data row 1
DataTable Subset to new DataTable 1

Back
Top