Skip to main content

LinkedWorkbook

Excel.LinkedWorkbook: another workbook the formulas read, keyed by its address. Import from @reductoai/xlsx/officejs.

LinkedWorkbook properties

Formulas that read the workbook become their last values.

LinkedWorkbook.refresh()

The file holds no copy of the linked book, so the cached values stay as they are.

LinkedWorkbookCollection

Excel.LinkedWorkbookCollection: the xl/externalLinks books. Import from @reductoai/xlsx/officejs.

LinkedWorkbookCollection properties

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

Values are entered as typed when the scenario is shown, so "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()

VBA’s ChangeScenario: new cells and values, and Excel’s “Modified by” line under the comment.

WorksheetScenario.delete()

WorksheetScenario.show()

Enters the values in the changing cells, as typed, and marks the scenario as shown.