Uses of Class
io.keikai.axyra.sheets.Range

Packages that use Range
Package
Description
io.keikai.axyra.sheets
Public Java API for the Axyra Sheets engine.

  • Uses of Range in io.keikai.axyra.sheets

    Methods in io.keikai.axyra.sheets that return Range
    Modifier and Type
    Method
    Description
    Range
    NamedRange.asRange()
    Returns the cells this name points at, resolved from the formula held by this object.
    Range
    Sheet.autoFilterRange()
    Returns the filtered block, header row included, or null when this sheet has no auto-filter.
    Range
    Sheet.range(int r1, int c1, int r2, int c2)
    Returns a range over the rectangle from (r1, c1) to (r2, c2), both corners inclusive and 0-based.
    Range
    Sheet.range(String a1)
    Returns a range parsed from A1 notation on this sheet: "A1", "$A$1:C10", a column band "B:D" or a row band "2:5".
    Range
    Workbook.range(String ref)
    A range parsed from a sheet-qualified A1 reference — the spelling a defined name stores, e.g.
    Range
    Sheet.usedRange()
    Returns the smallest range that covers every stored cell, or null when the sheet has no cells.
    Methods in io.keikai.axyra.sheets that return types with arguments of type Range
    Modifier and Type
    Method
    Description
    List<Range>
    Sheet.mergedRegions()
    Returns the merged-cell regions on this sheet, one Range per region.
    Methods in io.keikai.axyra.sheets with parameters of type Range
    Modifier and Type
    Method
    Description
    int
    Sheet.applyAdvancedFilter(Range listRange, Range criteriaRange, boolean uniqueOnly)
    Run an advanced filter (Excel's Data > Advanced) over listRange in place, hiding the data rows that do not match criteriaRange.
    int
    Sheet.applyAdvancedFilterCopyTo(Range listRange, Range criteriaRange, Range destination, boolean uniqueOnly)
    Advanced filter in "Copy to another location" mode: instead of hiding source rows, writes the list header plus each matching row (see Sheet.applyAdvancedFilter(Range, Range, boolean) for the criteria semantics) starting at the top-left cell of destination.
    void
    Range.autoFill(Range destination)
    Detects a pattern in this range and extends it over destination, as Excel's fill handle does: a linear numeric series, or a cyclic copy for text and mixed content.
    int[]
    Sheet.consolidate(int destRow, int destColumn, ConsolidateFunction function, Range... sources)
    Consolidates several source ranges of the same shape, possibly on other sheets, into this sheet at (destRow, destColumn), as Excel's Data > Consolidate does by position.
    boolean
    Sheet.resizeTable(String name, Range newRange)
    Resizes the named table to newRange, as Excel's Table Design > Resize Table does.
    void
    Sheet.setAutoFilter(Range range)
    Defines an auto-filter over range; its top row holds the filter buttons.
    void
    Sheet.sortByColor(Range range, int sortColumnIndex, boolean cellColor, boolean hasHeader, Color... colors)
    Sort the rows of range by cell fill color (or font color when cellColor is false) at sortColumnIndex (0-based, relative to the range start).