Uses of Package
io.keikai.axyra.sheets
Packages that use io.keikai.axyra.sheets
Package
Description
Public Java API for the Axyra Sheets engine.
User-defined formula functions and the built-in function catalog.
Options for saving and rendering a workbook, and a streaming writer for
large exports.
Data binding with template markers.
-
Classes in io.keikai.axyra.sheets used by io.keikai.axyra.sheetsClassDescriptionAggregate function for a pivot table data (values) field.Base type for engine and API failures surfaced from the native layer.One cell of a sheet: a lightweight
(sheet, row, column)view, 0-based, that holds no native resource.A workbook-wide cell coordinate: a 0-based sheet index plus 0-based row and column.One cell's value: a number, text, boolean, error or blank, or a matrix passed to and from a user-defined function.The empty cell value; use the sharedCellValue.BLANK.A boolean cell value.A view of one existing chart, obtained withSheet.chart(int)for a chart on a worksheet, or withWorkbook.chartSheetChart(int)for the chart of a chart-sheet tab.Aggregation function forSheet.consolidate(int, int, io.keikai.axyra.sheets.ConsolidateFunction, io.keikai.axyra.sheets.Range...).A custom document property — one entry of the workbook's custom file properties part (docProps/custom.xml, ECMA-376 Part 1 §22.3).The typed value of a custom document property.One date grouping item of a date auto-filter (ECMA-376 §18.3.2.4dateGroupItem, §18.18.24ST_DateTimeGrouping): selects every date/time cell inside the period named bygrouping.Dynamic auto-filter kind (ECMA-376 §18.18.26 ST_DynamicFilterType).Comparison operator for a custom auto-filter condition.A style predicate for format-restricted find/replace (Excel's Find & Replace → Format...Options forSheet.importData(int, int, java.util.List, ImportOptions), which writes a list of Java objects onto a sheet, one object per row and one property per column.Fluent builder forImportOptions.A snapshot of the engine's licensing status.WhatWorkbook.setLicense(String, LicenseMode)does with a token that is not in force.The runtime licensing status of the engine (process-global).A defined name (named range).The six page margins of a sheet, in inches (Excel semantics; ECMA-376 Part 1 §18.3.1.62pageMargins).A pivot calculated-field definition: a virtual source column computed from a formula over the other source columns (ECMA-376 Part 1 §18.10.1.13cacheField@formula).A pivot calculated-item definition: a virtual item of a row/column field computed from the field's other items (ECMA-376 Part 1 §18.10.1.9calculatedItem).Date component a pivot row/column field is grouped by (ECMA-376 Part 1 §18.10.1.81rangePr@groupBy).One placed pivot field, as returned by thePivotTableViewarea read-backs (rowFields(),columnFields(),dataFields(),filterFields()).The grouping of a pivot row/column field, read back viaPivotTableView.fieldGroup(String): either a date-component grouping (PivotFieldGroup.dateBy()non-null) or numeric range bins.The declared sort of a pivot row/column field, read back viaPivotTableView.fieldSort(String).A caption (label) filter on a pivot row/column field, read back viaPivotTableView.labelFilter(String).Caption (label) filter condition for a pivot row/column field — Excel's "Label Filters" menu (ECMA-376 Part 1 §18.18.72ST_PivotFilterType, caption subset).Report layout of a pivot table (ECMA-376 Part 1 §18.10.1.73 — thecompact/outline/compactDataattribute trio).The Show-Values-As state of a pivot values-area field, read back viaPivotTableView.showDataAs(int).Show-Values-As display mode for a pivot values-area field — Excel's "Show Values As" menu (ECMA-376 Part 1 §18.10.1.18dataField@showDataAs).A named pivot-table style plus banding flags (<pivotTableStyleInfo>— ECMA-376 Part 1 §18.10.1.88), read back viaPivotTableView.style().A view of one pivot table: its definition (fields, filters, sorts, layout, style) and thePivotTableView.refresh()that writes its output into the sheet.The Top-N ("Top 10") filter of a pivot row/column field, read back viaPivotTableView.topNFilter(String): items rank by their aggregate of a values-area entry and only the top (or bottom)valueitems / percent survive a refresh.A value filter on a pivot row/column field, read back viaPivotTableView.valueFilter(String).Value filter condition for a pivot row/column field — Excel's "Value Filters" menu (ECMA-376 Part 1 §18.18.72ST_PivotFilterType, value subset).A rectangle of cells on one sheet: the bulk API.A worksheet: a lightweight view bound to one tab of aWorkbook.Sheet protection options — the checkboxes of Excel's "Protect Sheet" dialog.Builder forSheetProtection; every setter takestrue= allowed.What kind of tab aSheetis.Direction that surrounding cells move when inserting or deleting a cell range.Validation report for one package digital signature — an OPC (ECMA-376 Part 2 §13) XML signature found in the workbook file when it was opened.Verification outcome of a package signature.One sort key: a 0-based range-relative index and its direction, optionally carrying a custom ordering list (Excel's "Custom Lists").Aggregate function forSheet.subtotal(int, int, int, io.keikai.axyra.sheets.SubtotalFunction, int...), by ExcelSUBTOTALcode.Table totals-row aggregation (ECMA-376 §18.18.92 ST_TotalsRowFunction).A sheet's three-state visibility.A spreadsheet workbook: the top-level container of sheets and the owner of the native engine workbook. -
Classes in io.keikai.axyra.sheets used by io.keikai.axyra.sheets.formulaClassDescriptionOne cell's value: a number, text, boolean, error or blank, or a matrix passed to and from a user-defined function.
-
Classes in io.keikai.axyra.sheets used by io.keikai.axyra.sheets.ioClassDescriptionA spreadsheet workbook: the top-level container of sheets and the owner of the native engine workbook.
-
Classes in io.keikai.axyra.sheets used by io.keikai.axyra.sheets.template