B4J Tutorial [XLUtils] Creating Tables

1620565159754.png


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:

1620565573282.png


= "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
    1.6 KB · Views: 322
Top