public void WriteDataTableToCells() { WorkBook wb = WorkBook.CreateNew(); WorkSheet sheet = wb.Sheets["sheet1"]; sheet.Name = "FirstSheet"; DataTable table = PrepareDataTable(); FillDataTableData(table, 10240); sheet.LoadFromDataView(table.DefaultView); wb.Save("WriteDateTableToCells.xlsx"); CheckColumnDataType("WriteDateTableToCells.xlsx", table); }