TableColumnCollection
Excel.TableColumnCollection.
Import from @reductoai/xlsx/officejs.
TableColumnCollection properties
TableColumnCollection.add()
index (the end when omitted); values fill it top to bottom, header first.
TableColumnCollection.addAsJson()
add with CellValue objects; each cell takes its basicValue.
TableColumnCollection.getCount()
TableColumnCollection.getItem()
TableColumnCollection.getItemAt()
TableColumnCollection.getItemOrNullObject()
TableRowCollection
Excel.TableRowCollection: the data rows.
Import from @reductoai/xlsx/officejs.
TableRowCollection properties
TableRowCollection.add()
values (one blank row without) at index, the end when omitted.
TableRowCollection.addAsJson()
add with CellValue objects. alwaysInsert false writes below the table, which then grows over the rows.
TableRowCollection.deleteRows()
TableRowCollection.deleteRowsAt()
count data rows from index on.
TableRowCollection.getCount()
TableRowCollection.getItemAt()
TableScopedCollection
Excel.TableScopedCollection: the tables a range overlaps, or holds whole.
Not exported by name. You get it from the API.
TableScopedCollection properties
TableScopedCollection.getCount()
TableScopedCollection.getFirst()
TableScopedCollection.getFirstOrNullObject()
TableScopedCollection.getItem()
TableScopedCollection.getItemOrNullObject()
TableSort
Excel.TableSort.
Import from @reductoai/xlsx/officejs.
TableSort properties
TableSort.apply()
fields, the first one outermost.
TableSort.clear()
TableSort.reapply()
TableStyle
A table, pivot, slicer or timeline style: built-in ones are read-only.
Import from @reductoai/xlsx/officejs.
TableStyle properties
TableStyle.delete()
TableStyle.duplicate()
TableStyle.set()
TableStyleCollection
The styles of one kind: built-in ones, then the workbook’s own.
Import from @reductoai/xlsx/officejs.
TableStyleCollection properties
TableStyleCollection.add()
makeUniqueName numbers a name already in use instead of throwing.