I already established connection to Excel 2007 using the following connection string:
string ExcelConnectionString =
@"Data Source=" + DBExcel.ExportPath + ";" +
"Extended Properties=\"Excel 12.0;HDR=YES\";";
excel_con = new OleDbConnection(ExcelConnectionString);
I also had the Excel file (export.xlsx) under my DBExcel.ExportPath path.
My question is how will i populate my excel file with the data from my datatable?