public void ExportToExcel(DataTable resultTable, string fileLocation, string sheetName, string color = "", int numberOfLastRow = 0, int startingCellIndex = 1) { XLWorkbook Workbook = new XLWorkbook(fileLocation); IXLWorksheet Worksheet = Workbook.Worksheet(sheetName); //Gets the last used row if (numberOfLastRow == 0) { numberOfLastRow = Worksheet.LastRowUsed().RowNumber(); } //Defines the starting cell for appeding (Row , Column) IXLCell CellForNewData = Worksheet.Cell(numberOfLastRow + 1, startingCellIndex); if (!color.Equals("")) { for (int i = 0; i < resultTable.Rows.Count; i++) { IXLRow RowForNewData = Worksheet.Row(numberOfLastRow + 1 + i); RowForNewData.Style.Font.FontColor = XLColor.Red; } } //InsertData - the data from the DataTable without the Column names ; InsertTable - inserts the data with the Column names CellForNewData.InsertData(resultTable); Workbook.SaveAs(fileLocation); }