ExcelWorksheet
Excel.Worksheet.
Import from @reductoai/xlsx/officejs.
ExcelWorksheet properties
ExcelWorksheet.activate()
ExcelWorksheet.calculate()
ExcelWorksheet.copy()
ExcelWorksheet.defaultColumnWidthPx()
ExcelWorksheet.defaultRowHeightPt()
ExcelWorksheet.delete()
#REF!; this handle and its ranges stop working.
ExcelWorksheet.evaluate()
formula computes on this sheet: a value, or the rows of a reference or array.
ExcelWorksheet.findAll()
ExcelWorksheet.findAllOrNullObject()
ExcelWorksheet.getCell()
ExcelWorksheet.getNext()
ExcelWorksheet.getNextOrNullObject()
ExcelWorksheet.getPrevious()
ExcelWorksheet.getPreviousOrNullObject()
ExcelWorksheet.getRange()
ExcelWorksheet.getRangeByIndexes()
ExcelWorksheet.getRanges()
ExcelWorksheet.getUsedRange()
ExcelWorksheet.getUsedRangeOrNullObject()
ExcelWorksheet.replaceAll()
ExcelWorksheet.set()
ExcelWorksheet.showOutlineLevels()
rowLevels and columnLevels outline levels (0 to 8); 0 leaves that direction as it is.
WorksheetFreezePanes
Excel.WorksheetFreezePanes.
Import from @reductoai/xlsx/officejs.
WorksheetFreezePanes.freezeAt()
WorksheetFreezePanes.freezeColumns()
WorksheetFreezePanes.freezeRows()
WorksheetFreezePanes.getLocation()
WorksheetFreezePanes.getLocationOrNullObject()
WorksheetFreezePanes.unfreeze()
WorksheetProtection
Excel.WorksheetProtection: <sheetProtection>; passwords are stored as Excel’s SHA-512 hash.
Import from @reductoai/xlsx/officejs.
WorksheetProtection properties
WorksheetProtection.checkPassword()
WorksheetProtection.pauseProtection()
WorksheetProtection.protect()
WorksheetProtection.resumeProtection()
WorksheetProtection.setPassword()
WorksheetProtection.unprotect()
WorksheetProtection.updateOptions()
PageLayout
Excel.PageLayout: <printOptions>, <pageMargins>, <pageSetup>, <headerFooter> and the print names.
Import from @reductoai/xlsx/officejs.
PageLayout properties
PageLayout.getPrintArea()
PageLayout.getPrintAreaOrNullObject()
PageLayout.getPrintTitleColumns()
PageLayout.getPrintTitleColumnsOrNullObject()
PageLayout.getPrintTitleRows()
PageLayout.getPrintTitleRowsOrNullObject()
PageLayout.set()
PageLayout.setPrintArea()
PrintArea = "".