I am trying to add a blank row and then a datatable with headers in an excel sheet. Problem is if I try to add blank row it comes as a blank entry in second row but header is still there.
Actual output:
Code:
using (XLWorkbook wb = new XLWorkbook())
{
var tempdata = tableData.Tables[0];
DataRow blankRow = tempdata.NewRow();
tempdata.Rows.InsertAt(blankRow, 0);
wb.Worksheets.Add(tempdata);
using (MemoryStream stream = new MemoryStream())
{
//save as excel
}
}

