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()); } }