Creating an Excel Table... ListObject Class doesn't exist in 7.0.40.226

0
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
add a comment

1 Answers

0
Please use the following code to create a table: IListObject table = worksheet.ListObjects.Create("Table1", worksheet["A1:C18"]);
 
answered 7/9/2020 9:02:09 AM
add a comment

Your Answer

Not the answer you're looking for? Browse other questions tagged excel or ask your own question.