ExcelRange
Excel.Range: a fixed rectangle of one sheet. Reads are current; writes apply at once.
Import from @reductoai/xlsx/officejs.
ExcelRange properties
ExcelRange.advancedFilter()
Range.AdvancedFilter): filters this list in place by a criteria range, or copies
the records under the header row of copyToRange. Returns the number of records shown or copied.
ExcelRange.autoFill()
destinationRange, which holds this range and grows it along one side, as dragging the fill handle does.
ExcelRange.calculate()
ExcelRange.clear()
ExcelRange.clearOrResetContents()
ExcelRange.consolidate()
Range.Consolidate): one block summarizing the sources by place or by their labels, from this range’s top-left cell; gives the block.
ExcelRange.copyFrom()
sourceRange here as Excel’s copy and paste (special) does; tiles when this range holds it a whole number of times.
ExcelRange.delete()
Up) or the right (Left); whole rows or columns go entirely.
ExcelRange.find()
ExcelRange.findOrNullObject()
ExcelRange.getAbsoluteResizedRange()
ExcelRange.getBoundingRect()
ExcelRange.getCell()
ExcelRange.getCellProperties()
options asks for; true on a branch loads all of it.
ExcelRange.getColumn()
ExcelRange.getColumnProperties()
ExcelRange.getColumnsAfter()
ExcelRange.getColumnsBefore()
ExcelRange.getDependents()
ExcelRange.getDirectDependents()
ExcelRange.getDirectPrecedents()
ExcelRange.getDisplayedCellProperties()
getCellProperties, with fonts, fills and borders as conditional formats show them.
ExcelRange.getEntireColumn()
ExcelRange.getEntireRow()
ExcelRange.getExtendedRange()
ExcelRange.getImage()
{ labels: true } adds column letters and row numbers, so a model can name the
cell under a mark. In a browser, import @reductoai/xlsx/view once; @reductoai/xlsx/node
brings its own painter.
ExcelRange.getIntersection()
ExcelRange.getIntersectionOrNullObject()
ExcelRange.getLastCell()
ExcelRange.getLastColumn()
ExcelRange.getLastRow()
ExcelRange.getMergedAreasOrNullObject()
ExcelRange.getOffsetRange()
ExcelRange.getPivotTables()
fullyContained.
ExcelRange.getPrecedents()
ExcelRange.getRangeEdge()
ExcelRange.getResizedRange()
ExcelRange.getRow()
ExcelRange.getRowProperties()
ExcelRange.getRowsAbove()
ExcelRange.getRowsBelow()
ExcelRange.getSpecialCells()
ExcelRange.getSpecialCellsOrNullObject()
ExcelRange.getSpillingToRange()
ExcelRange.getSpillingToRangeOrNullObject()
ExcelRange.getSpillParent()
ExcelRange.getSpillParentOrNullObject()
ExcelRange.getSurroundingRegion()
ExcelRange.getTables()
ExcelRange.getUsedRange()
ExcelRange.getUsedRangeOrNullObject()
ExcelRange.getVisibleView()
ExcelRange.group()
ExcelRange.hideGroupDetails()
ExcelRange.insert()
shift pushes the cells below (Down) or to the right (Right).
References, merges, formats and anchors follow the moved cells as in Excel.
ExcelRange.merge()
across; only the top-left value is kept.
ExcelRange.moveTo()
destinationRange’s, as Excel’s cut and paste does.
ExcelRange.removeDuplicates()
ExcelRange.replaceAll()
ExcelRange.select()
select moves the UI selection; a file has none to move.
ExcelRange.set()
ExcelRange.setCellProperties()
ExcelRange.setColumnProperties()
ExcelRange.setDirty()
ExcelRange.setRowProperties()
ExcelRange.showGroupDetails()
ExcelRange.ungroup()
ExcelRange.unmerge()
RangeValueType
Import from @reductoai/xlsx/officejs.
RangeAreas
Excel.RangeAreas: rectangles of one sheet, kept in the order given.
Import from @reductoai/xlsx/officejs.
RangeAreas properties
RangeAreas.calculate()
RangeAreas.clear()
RangeAreas.clearOrResetContents()
RangeAreas.copyFrom()
RangeAreas.getEntireColumn()
RangeAreas.getEntireRow()
RangeAreas.getIntersection()
RangeAreas.getIntersectionOrNullObject()
RangeAreas.getOffsetRangeAreas()
RangeAreas.getSpecialCells()
RangeAreas.getSpecialCellsOrNullObject()
RangeAreas.getTables()
RangeAreas.getUsedRangeAreas()
RangeAreas.getUsedRangeAreasOrNullObject()
RangeAreas.select()
RangeAreas.set()
RangeAreas.setDirty()
RangeSort
Excel.RangeSort.
Import from @reductoai/xlsx/officejs.
RangeSort.apply()
orientation “Columns”) by fields, the first
outermost. A header row (column) stays on top; formulas move as a copy would.
parseAddress()
Sheet!; undefined when it is not an A1 address.
Import from @reductoai/xlsx/officejs.
formatAddress()
@reductoai/xlsx/officejs.