TableCollection
Excel.TableCollection: every table of the workbook, or of one worksheet.
Import from @reductoai/xlsx/officejs.
TableCollection properties
TableCollection.add()
address; without headers Excel inserts a header row above the cells.
TableCollection.getCount()
TableCollection.getItem()
TableCollection.getItemAt()
TableCollection.getItemOrNullObject()
ExcelTable
Excel.Table. Edits apply at once and keep every formula that names the table in step.
Import from @reductoai/xlsx/officejs.
ExcelTable properties
ExcelTable.clearFilters()
ExcelTable.convertToRange()
ExcelTable.delete()
ExcelTable.getDataBodyRange()
ExcelTable.getHeaderRowRange()
ExcelTable.getRange()
ExcelTable.getTotalRowRange()
ExcelTable.reapplyFilters()
ExcelTable.resize()
newRange; its top row stays where it is and the ranges overlap.
ExcelTable.set()
TableColumn
Excel.TableColumn, keyed by its id in the table part.
Import from @reductoai/xlsx/officejs.
TableColumn properties
TableColumn.delete()
TableColumn.getDataBodyRange()
TableColumn.getHeaderRowRange()
TableColumn.getRange()
TableColumn.getTotalRowRange()
TableColumn.set()
TableRow
Excel.TableRow: a data row by position, as Office.js keys it.
Import from @reductoai/xlsx/officejs.
TableRow properties
TableRow.delete()
TableRow.getRange()
TableRow.set()
ExcelFilter
Excel.Filter of one filter column; scope finds the table’s or the sheet’s filter.
Import from @reductoai/xlsx/officejs.
ExcelFilter properties
ExcelFilter.apply()
ExcelFilter.applyBottomItemsFilter()
ExcelFilter.applyBottomPercentFilter()
ExcelFilter.applyCellColorFilter()
ExcelFilter.applyCustomFilter()
oper, And by default.
ExcelFilter.applyDynamicFilter()
ExcelFilter.applyFontColorFilter()
ExcelFilter.applyIconFilter()
ExcelFilter.applyTopItemsFilter()
ExcelFilter.applyTopPercentFilter()
ExcelFilter.applyValuesFilter()
ExcelFilter.clear()
AutoFilter
Excel.AutoFilter of a worksheet (its own filter buttons) or of one table.
Import from @reductoai/xlsx/officejs.
AutoFilter properties
AutoFilter.apply()
range (one cell takes its current region, as Excel does) and,
with columnIndex and criteria, filters that column. A new range drops the old criteria.