Export DataTable to Excel?

[Guest]

Dear all,

Is there any easy way to export data from DataTable to Excel?

Thanks for any help,

Tedmond

 

[CT]

You can write the data using the WriteXml method, and then open the xml file
in Excel.

 

[Guest]

Thanks CT, but my Excel does not support XML. Is there any other way?

 

[CT]

Try this, http://www.codeproject.com/aspnet/ExportClassLibrary.asp