worksheets, names and the other collections. Concepts explains the model.
ExcelWorkbook
Office.js-shaped facade over an .xlsx (Excel.Workbook). Handles read the live workbook and
every edit applies at once: there is no load()/sync() protocol. Members Office.js lacks are
marked as extensions.
Import from @reductoai/xlsx/officejs.
ExcelWorkbook properties
ExcelWorkbook.create()
ExcelWorkbook.fromBytes()
ExcelWorkbook.getActiveCell()
ExcelWorkbook.getChartSheetChart()
name, as VBA’s
Workbook.Charts(name) gives it. Its position and size are the sheet’s and cannot change.
ExcelWorkbook.getRange()
ExcelWorkbook.insertWorksheetsFromBase64()
ExcelWorkbook.set()
ExcelWorkbook.toBytes()
Node additions
ExcelWorkbook.create() (node)
ExcelWorkbook.fromBytes() (node)
ExcelWorkbook.open() (node)
ExcelWorkbook.save() (node)
path; the facade never writes the source file in place.
ExcelWorkbook.toPdf() (node)
path when given.
ExcelWorkbook.toPng() (node)
SheetPictureOptions
Import from @reductoai/xlsx/node.
ToPngOptions
Import from @reductoai/xlsx/node.
RenderedSheet
Import from @reductoai/xlsx/node.
WorksheetCollection
Excel.WorksheetCollection: getItem takes a name or an id.
Import from @reductoai/xlsx/officejs.
WorksheetCollection properties
WorksheetCollection.add()
WorksheetCollection.getActiveWorksheet()
WorksheetCollection.getCount()
WorksheetCollection.getFirst()
WorksheetCollection.getItem()
WorksheetCollection.getItemAt()
WorksheetCollection.getItemOrNullObject()
isNullObject before other members.
WorksheetCollection.getLast()
ExcelApplication
Import from @reductoai/xlsx/officejs.
ExcelApplication properties
ExcelApplication.calculate()
ExcelApplication.set()
ExcelApplication.suspendApiCalculationUntilNextSync()
ExcelApplication.suspendScreenUpdatingUntilNextSync()
ExcelApplication.union()
IterativeCalculation
Excel.IterativeCalculation: the workbook’s calcPr iteration settings. Setting one recalculates.
Import from @reductoai/xlsx/officejs.