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

Packages that use Sheet
Package
Description
io.keikai.axyra.sheets
Public Java API for the Axyra Sheets engine.
io.keikai.axyra.sheets.template
Data binding with template markers.

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

    Methods in io.keikai.axyra.sheets that return Sheet
    Modifier and Type
    Method
    Description
    Sheet
    Workbook.activeSheet()
    The active sheet: the tab Excel shows when the file opens.
    Sheet
    Workbook.copySheet(Sheet source, String newName)
    Appends a deep copy of source under newName and returns a view of the copy.
    Sheet
    Workbook.copySheetFrom(Workbook source, int sheetIndex)
    Appends a deep copy of sheet sheetIndex (0-based) of another workbook and returns a view of the copy.
    Sheet
    Workbook.copySheetFrom(Workbook source, int sheetIndex, String newName)
    Appends a deep copy of sheet sheetIndex (0-based) of another workbook under newName and returns a view of the copy.
    Sheet
    Workbook.createSheet(String name)
    Appends a new empty worksheet after the last tab and returns a view of it.
    Sheet
    Workbook.insertSheet(int index, String name)
    Inserts a new empty sheet at index (0..sheetCount inclusive), shifting later sheets right, and return a view of it.
    Sheet
    Workbook.sheet(int index)
    A view of the tab at index (0-based, in tab order).
    Sheet
    Workbook.sheet(String name)
    The sheet with the given name, compared ignoring case as Excel compares sheet names; a sheet whose name matches exactly wins.
    Methods in io.keikai.axyra.sheets that return types with arguments of type Sheet
    Modifier and Type
    Method
    Description
    List<Sheet>
    Workbook.sheets()
    A view of every tab, in tab order, chart-sheet tabs included.
    Methods in io.keikai.axyra.sheets with parameters of type Sheet
    Modifier and Type
    Method
    Description
    void
    Workbook.addName(String name, String formula, Sheet scope)
    Adds a defined name scoped to scope, or replaces one; the rules of Workbook.addName(String, String) apply.
    List<CellRef>
    Workbook.allDependents(Sheet sheet, int row, int column)
    Every cell that depends on a cell directly or through other cells; the cell itself is not included.
    Sheet
    Workbook.copySheet(Sheet source, String newName)
    Appends a deep copy of source under newName and returns a view of the copy.
    void
    Range.copyTo(Sheet dstSheet, int dstRow, int dstCol)
    Copies this rectangle to (dstRow, dstCol) on dstSheet, as Excel's Copy and Paste do.
    void
    Range.copyTo(Sheet dstSheet, int dstRow, int dstCol, String pasteType)
    Copies this rectangle with an Excel Paste Special mode.
    List<CellRef>
    Workbook.dependents(Sheet sheet, int row, int column)
    The direct dependents of a cell: the cells whose formulas read it.
    CellValue
    Workbook.evaluate(String formula, Sheet sheet)
    Evaluates an ad-hoc formula in sheet's context: references without a sheet name read that sheet.
    List<CellRef>
    Workbook.precedents(Sheet sheet, int row, int column)
    The direct precedents of a cell: the cells its formula reads, on any sheet.

  • Uses of Sheet in io.keikai.axyra.sheets.template

    Methods in io.keikai.axyra.sheets.template with parameters of type Sheet
    Modifier and Type
    Method
    Description
    static void
    TemplateMarkers.process(Sheet sheet, Map<String,Object> data)
    Replaces every ${...} marker in the used range of sheet with values from data, in place.