how to export datatable to excel in window application

Here is the code through which you can easily done this.just you need to copy this function in your application and pass "DataTable" and excel "FileName" to export the excel.

void ExportToExcel(DataTable ResultDataTable,string FileName)
{
try
{
Microsoft.Office.Interop.Excel.ApplicationClass excel = new Microsoft.Office.Interop.Excel.ApplicationClass();

Microsoft.Office.Interop.Excel.Worksheet wSheet;

wBook = excel.Workbooks.Add(true);
wSheet = wBook.ActiveSheet as Microsoft.Office.Interop.Excel.Worksheet;
System.Data.DataTable dt = ResultDataTable;
//System.Data.DataColumn dc;
//System.Data.DataRow dr;
int colIndex = 0;
int rowIndex = 0;
foreach (DataColumn dc in dt.Columns)
{
colIndex = (colIndex + 1);
excel.Cells[1, colIndex] = dc.ColumnName;
}
foreach (DataRow dr in dt.Rows)
{
rowIndex = (rowIndex + 1);
colIndex = 0;
foreach (DataColumn dc in dt.Columns)
{
colIndex = (colIndex + 1);
excel.Cells[(rowIndex + 1), colIndex] = dr[dc.ColumnName];
}
}
wSheet.Columns.AutoFit();

if (!Directory.Exists(AppDomain.CurrentDomain.BaseDirectory + "ImportError"))
{
Directory.CreateDirectory(AppDomain.CurrentDomain.BaseDirectory + "ImportError");
}
wSheet.SaveAs(AppDomain.CurrentDomain.BaseDirectory + "ImportError\\" +FileName+ "_" + DateTime.Now.ToString().Replace("/", "_").Replace(":", "_") + ".xlsx", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

excel.Visible = false;
}
catch { }
}


Happy Coding...