LinkedWorkbook
Excel.LinkedWorkbook: another workbook the formulas read, keyed by its address.
Import from @reductoai/xlsx/officejs.
LinkedWorkbook properties
LinkedWorkbook.breakLinks()
LinkedWorkbook.refresh()
LinkedWorkbookCollection
Excel.LinkedWorkbookCollection: the xl/externalLinks books.
Import from @reductoai/xlsx/officejs.
LinkedWorkbookCollection properties
LinkedWorkbookCollection.breakAllLinks()
LinkedWorkbookCollection.getItem()
LinkedWorkbookCollection.getItemOrNullObject()
LinkedWorkbookCollection.refreshAll()
NamedItemArrayValues
Excel.NamedItemArrayValues.
Not exported by name. You get it from the API.
NamedItemArrayValues properties
ScenarioCollection
Worksheet.Scenarios: the sheet’s scenarios, in the order Scenario Manager lists them.
Not exported by name. You get it from the API.
ScenarioCollection properties
ScenarioCollection.add()
"12" gives a number.
ScenarioCollection.getItem()
WorksheetScenario
Scenario: one <scenario>; its name is its key.
Not exported by name. You get it from the API.
WorksheetScenario properties
WorksheetScenario.change()
ChangeScenario: new cells and values, and Excel’s “Modified by” line under the comment.