How can I create an Excel table in version 7.0.40.226.
WorkbookManager wbm = new WorkbookManager();
Workbook wb = wbm.Workbooks.Add(ExcelVersion.Excel2016);
IWorksheet sheet = (Worksheet)wb.Worksheets[0];
sheet.ImportDataTable(dt, true, 1, 1);
sheet.Columns[9].CellStyle.NumberFormat = "0.00";
Range r = new Range(wbm, sheet, 1, 100, 1, 200);
sheet.ListObjects.Add(new ListObject("Journal", r, 0)); //problem is here
wb.SaveAs(filename);
wb.Close();
Thank you.
asked 6/5/2020 9:47:28 PM