May 9, 2021 Tabular data can be converted to a Table object. Excel provides all kinds of nice features related to tables: https://www.bluepecantraining.com/portfolio/convert-data-to-an-excel-table/ Tables are supported in XLSX (2007+) workbooks. Creating a table is a matter of calling XLSheetWriter.CreateTable with the defined range, name and style. You can see the various styles in Excel: = "TableStyleMedium3" It is also possible to load templates with tables and get the tables with Sheet.GetTables. You can create a template with a table, fill data and update the table area with Table.CellReferences. Notes: - Apache POI support for tables is quite basic. - Tables ranges are not really dynamic. You cannot use tables as an alternative to dynamic named ranges. You can use both features together. - Requires XLUtils v1.11+ Attachments Table.zip Table.zip 1.6 KB · Views: 1,003 Click to expand...
Tabular data can be converted to a Table object. Excel provides all kinds of nice features related to tables: https://www.bluepecantraining.com/portfolio/convert-data-to-an-excel-table/ Tables are supported in XLSX (2007+) workbooks. Creating a table is a matter of calling XLSheetWriter.CreateTable with the defined range, name and style. You can see the various styles in Excel: = "TableStyleMedium3" It is also possible to load templates with tables and get the tables with Sheet.GetTables. You can create a template with a table, fill data and update the table area with Table.CellReferences. Notes: - Apache POI support for tables is quite basic. - Tables ranges are not really dynamic. You cannot use tables as an alternative to dynamic named ranges. You can use both features together. - Requires XLUtils v1.11+
