Uses of Class
io.keikai.axyra.sheets.Sheet
Packages that use Sheet
Package
Description
Public Java API for the Axyra Sheets engine.
-
Uses of Sheet in io.keikai.axyra.sheets
Methods in io.keikai.axyra.sheets that return SheetModifier and TypeMethodDescriptionWorkbook.activeSheet()The active (selected) sheet.Append a deep copy ofsourceundernewNameand return it.Workbook.copySheetFrom(Workbook source, int sheetIndex) Append a deep copy of sheetsheetIndexof ANOTHER workbook and return the new view.Workbook.copySheetFrom(Workbook source, int sheetIndex, String newName) Append a deep copy of sheetsheetIndexof ANOTHER workbook undernewNameand return the new view.Workbook.createSheet(String name) Append a new sheet and return a view of it.Workbook.insertSheet(int index, String name) Insert a new empty sheet atindex(0..sheetCount inclusive), shifting later sheets right, and return a view of it.Workbook.sheet(int index) The sheet atindex(0-based).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 SheetModifier and TypeMethodDescriptionWorkbook.sheets()A snapshot list of all sheet views, in order.Methods in io.keikai.axyra.sheets with parameters of type SheetModifier and TypeMethodDescriptionvoidAdd or replace a name scoped to a sheet.Workbook.allDependents(Sheet sheet, int row, int column) All transitive dependents of a cell (does not include the cell itself).Append a deep copy ofsourceundernewNameand return it.voidCopy this rectangle to(dstRow, dstCol)ondstSheet(Excel's Copy → Paste).voidCopy this rectangle with an Excel Paste-Special mode:"all"/"values"/"formulas"/"formats"/"comments".Workbook.dependents(Sheet sheet, int row, int column) The direct dependents of a cell — the cells whose formulas read it.Evaluate an ad-hoc formula in the given sheet's context.Workbook.precedents(Sheet sheet, int row, int column) The direct precedents of a cell — the cells its formula reads (may be cross-sheet). -
Uses of Sheet in io.keikai.axyra.sheets.template
Methods in io.keikai.axyra.sheets.template with parameters of type Sheet