You can use this package it can do every thing for excel , it's very easy for use.
NuGet Gallery | EPPlus 4.5.3.1[
^]
e.g. if you want to export DataTable to Excel
using (ExcelPackage pck = new ExcelPackage(newFile))
{
ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Accounts");
ws.Cells["A1"].LoadFromDataTable(dataTable, true);
pck.Save();
}