Skip to main content

ExcelWorksheet

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

ExcelWorksheet properties

ExcelWorksheet.activate()

ExcelWorksheet.calculate()

ExcelWorksheet.copy()

A copy named as Excel names one (“Sheet1 (2)”); “None” puts it right after this sheet.

ExcelWorksheet.defaultColumnWidthPx()

Extension: the default column width in pixels.

ExcelWorksheet.defaultRowHeightPt()

Extension: the default row height in points.

ExcelWorksheet.delete()

References to the sheet become #REF!; this handle and its ranges stop working.

ExcelWorksheet.evaluate()

What formula computes on this sheet: a value, or the rows of a reference or array.

ExcelWorksheet.findAll()

Every cell whose formula or constant matches; throws when none does.

ExcelWorksheet.findAllOrNullObject()

ExcelWorksheet.getCell()

ExcelWorksheet.getNext()

The next sheet in tab order; throws at the last one.

ExcelWorksheet.getNextOrNullObject()

ExcelWorksheet.getPrevious()

ExcelWorksheet.getPreviousOrNullObject()

ExcelWorksheet.getRange()

The whole sheet without an address; otherwise an A1 address on this sheet or a defined name.

ExcelWorksheet.getRangeByIndexes()

ExcelWorksheet.getRanges()

Comma- or semicolon-separated addresses or names; the whole sheet without one.

ExcelWorksheet.getUsedRange()

The smallest rectangle holding every value or format; A1 on an empty sheet.

ExcelWorksheet.getUsedRangeOrNullObject()

ExcelWorksheet.replaceAll()

Replace All over the sheet; returns the number of cells changed.

ExcelWorksheet.set()

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

ExcelWorksheet.showOutlineLevels()

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

Freezes the rows above and the columns left of the range’s bottom-right corner, inclusive.

WorksheetFreezePanes.freezeColumns()

WorksheetFreezePanes.freezeRows()

WorksheetFreezePanes.getLocation()

The frozen cells; throws when nothing is frozen.

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

Lifts protection for this session only; the file stays protected.

WorksheetProtection.protect()

Throws when the sheet is already protected, as Excel does.

WorksheetProtection.resumeProtection()

WorksheetProtection.setPassword()

Changes the password of a protected sheet; none removes it.

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

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

PageLayout.setPrintArea()

A range, areas, or an address such as “A1:D20, F1:G5”; "" clears it, as VBA’s PrintArea = "".

PageLayout.setPrintMargins()

PageLayout.setPrintTitleColumns()

PageLayout.setPrintTitleRows()

Whole rows such as “1:2”; other ranges use their rows; "" clears them.