public static void SaveTable(IXLWorksheet sheet, DataTable dataTable, string start, bool showColumnHeaders)
{
if (showColumnHeaders)
{
int colStart = XLHelper.GetColumnNumberFromAddress(start);
var rowPos = 0;
while (start[rowPos] > '9')
{
rowPos++;
}
int rowStart = int.Parse(start.Substring(rowPos));
for (int i = 0; i < dataTable.Columns.Count; i++)
{
sheet.Cell(rowStart, colStart + i).Value = dataTable.Columns[i].ColumnName;
}
sheet.Cell(rowStart + 1, colStart).InsertData(dataTable.AsEnumerable());
}
else
{
sheet.Cell(start).InsertData(dataTable.AsEnumerable());
}
}