Skip to main content

TableColumnCollection

Excel.TableColumnCollection. Import from @reductoai/xlsx/officejs.

TableColumnCollection properties

TableColumnCollection.add()

Inserts a column at 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()

By name or by id.

TableColumnCollection.getItemAt()

TableColumnCollection.getItemOrNullObject()

TableRowCollection

Excel.TableRowCollection: the data rows. Import from @reductoai/xlsx/officejs.

TableRowCollection properties

TableRowCollection.add()

Inserts one row per row of 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()

Deletes data rows by index or handle, all against the indexes before the call.

TableRowCollection.deleteRowsAt()

Deletes 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()

The table nearest the top-left; throws when there is none.

TableScopedCollection.getFirstOrNullObject()

TableScopedCollection.getItem()

TableScopedCollection.getItemOrNullObject()

TableSort

Excel.TableSort. Import from @reductoai/xlsx/officejs.

TableSort properties

TableSort.apply()

Sorts the shown rows by fields, the first one outermost.

TableSort.clear()

Forgets the sort, as the header buttons show it; the rows keep their order.

TableSort.reapply()

Reapplies the filters, as Excel’s Reapply does after a sort.

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()

A copy named “<name> 2”; a built-in table or pivot style copies its formats.

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()

A blank style; makeUniqueName numbers a name already in use instead of throwing.

TableStyleCollection.getCount()

TableStyleCollection.getDefault()

TableStyleCollection.getItem()

TableStyleCollection.getItemOrNullObject()

TableStyleCollection.setDefault()