Here is little class that I wrote some time ago that helps you export data from DataTable into Excell xls file. It format fields in xls file based on data type from data table.
It’s not a perfect but it will help you to quickly save data from Data Table to Excel file.
Example of usage:
Common.Data.Export2Excel(dataTableWithData, "exported.xls");