Skip to main content

NamedItemCollection

Excel.NamedItemCollection: the workbook’s names, or one worksheet’s. Import from @reductoai/xlsx/officejs.

NamedItemCollection properties

NamedItemCollection.add()

reference is a range or a formula such as “=Sheet1!AA1:BB2” or “=0.2”.

NamedItemCollection.addFormulaLocal()

Extension of Office.js: formula is a formula with or without its ”=”.

NamedItemCollection.getCount()

NamedItemCollection.getItem()

NamedItemCollection.getItemOrNullObject()

NamedItem

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

NamedItem properties

NamedItem.delete()

NamedItem.getRange()

NamedItem.getRangeOrNullObject()

NamedItem.set()

Sets several properties at once; a navigation member takes a nested batch.

Functions

Excel.Functions: each worksheet function, computed against the workbook as it stands. Import from @reductoai/xlsx/officejs.

Functions properties

Functions.call()

name(args) on the active sheet; a function the engine lacks gives #NAME?.

FunctionResult

Excel.FunctionResult: error holds the error code, such as “#DIV/0!”, when the call fails. Import from @reductoai/xlsx/officejs.

FunctionResult properties