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()
    The cells this name points at.
    Range
    Sheet.autoFilterRange()
    The filtered block, or null when this sheet has no autofilter.
    Range
    Sheet.range(int r1, int c1, int r2, int c2)
    A range over the inclusive rectangle (r1,c1)..(r2,c2), 0-based.
    Range
    Sheet.range(String a1)
    A range parsed from A1 notation, e.g.
    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()
    The used-cell bounding range, or null if the sheet is empty.
    Methods in io.keikai.axyra.sheets that return types with arguments of type Range
    Modifier and Type
    Method
    Description
    List<Range>
    Sheet.mergedRegions()
    The merged-cell regions on this sheet.
    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)
    Auto-fill: detect a pattern in this range (linear numeric series, or a cyclic copy for text and mixed content) and extend it across destination — Excel's fill-handle drag.
    int[]
    Sheet.consolidate(int destRow, int destColumn, ConsolidateFunction function, Range... sources)
    Consolidate several equally-shaped source ranges (possibly on other sheets) into this sheet at (destRow, destColumn) using function, aggregating by position.
    boolean
    Sheet.resizeTable(String name, Range newRange)
    Resize the named table to newRange (Excel's Table Design > Resize Table).
    void
    Sheet.setAutoFilter(Range range)
    Define an auto-filter over range (its top row is the filter header).
    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).