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

Packages that use Workbook

Package	Description
io.keikai.axyra.sheets	Public Java API for the Axyra Sheets engine.
io.keikai.axyra.sheets.io

Uses of Workbook in io.keikai.axyra.sheets

Methods in io.keikai.axyra.sheets that return Workbook

Modifier and Type	Method	Description
static Workbook	Workbook.create()	Create a new empty workbook (sparse backend — the general-purpose default).
static Workbook	Workbook.createColumnar()	Create a new empty workbook on the columnar storage backend — behaviorally identical to create() but far leaner in memory for large, dense, numeric workbooks (roughly 4.6× smaller at rest at 10M cells), and saving at or below the sparse path.
static Workbook	Workbook.open(InputStream in, String format)	Parse a workbook by reading all of in (of the given format).
static Workbook	Workbook.open(Path file)	Open a workbook from a file.
static Workbook	Workbook.open(Path file, String password)	Open a workbook from a file, decrypting with password when the file is an agile-encrypted workbook ([MS-OFFCRYPTO] §2.3.4 — what saveEncrypted(java.nio.file.Path, java.lang.String) and Excel 2013+/365 write).
static Workbook	Workbook.openBytes(byte[] data, String format)	Parse a workbook from an in-memory byte array of the given format.
static Workbook	Workbook.openBytes(byte[] data, String format, String password)	Parse a workbook from an in-memory byte array, decrypting with password when the bytes are an agile-encrypted workbook.

Methods in io.keikai.axyra.sheets with parameters of type Workbook

Modifier and Type	Method	Description
void	Workbook.combine(Workbook... sources)	Append a deep copy of EVERY sheet (visible and hidden) of each source workbook, in argument order, auto-suffixing colliding names — the cross-workbook merge counterpart of copySheetFrom(Workbook, int) (same migration semantics and exclusions, except as follows).
Sheet	Workbook.copySheetFrom(Workbook source, int sheetIndex)	Append a deep copy of sheet sheetIndex of ANOTHER workbook and return the new view.
Sheet	Workbook.copySheetFrom(Workbook source, int sheetIndex, String newName)	Append a deep copy of sheet sheetIndex of ANOTHER workbook under newName and return the new view.

Uses of Workbook in io.keikai.axyra.sheets.io

Methods in io.keikai.axyra.sheets.io with parameters of type Workbook

Modifier and Type	Method	Description
static int	Renderer.pageCount(Workbook workbook, int sheetIndex)	Number of printed pages sheetIndex paginates to — the valid range for ImageOptions.Builder.page(int) and the PDF export's page numbering.
static byte[]	Renderer.toBmp(Workbook workbook, int sheetIndex, ImageOptions options)	Render one sheet to BMP bytes.
static byte[]	Renderer.toGif(Workbook workbook, int sheetIndex, ImageOptions options)	Render one sheet to GIF bytes.
static byte[]	Renderer.toImage(Workbook workbook, int sheetIndex, String format, ImageOptions options)	Render one sheet to the given raster format — "png", "jpeg", "gif", "bmp" or "tiff".
static byte[]	Renderer.toImage(Workbook workbook, int sheetIndex, String rangeA1, String format, ImageOptions options)	Render an A1 range of a sheet to the given raster format.
static byte[]	Renderer.toJpeg(Workbook workbook, int sheetIndex, ImageOptions options)	Render one sheet to JPEG bytes (composited over white).
static byte[]	Renderer.toPdf(Workbook workbook, PdfOptions options)	Render the workbook to PDF bytes honoring options (null = defaults).
static void	Renderer.toPdf(Workbook workbook, Path file)	Render the whole workbook to a PDF file.
static void	Renderer.toPdf(Workbook workbook, Path file, PdfOptions options)	Render the workbook to a PDF file honoring options.
static byte[]	Renderer.toPng(Workbook workbook, int sheetIndex, ImageOptions options)	Render one sheet to PNG bytes — page 1 of its print layout, or the page selected in options.
static byte[]	Renderer.toPng(Workbook workbook, int sheetIndex, String rangeA1, ImageOptions options)	Render an A1 range (e.g.
static byte[]	Renderer.toSvg(Workbook workbook, int sheetIndex, ImageOptions options)	Render one sheet (first page of its print layout) to SVG bytes (UTF-8).
static byte[]	Renderer.toSvg(Workbook workbook, int sheetIndex, String rangeA1, ImageOptions options)	Render an A1 range of a sheet to SVG bytes (UTF-8).
static byte[]	Renderer.toTiff(Workbook workbook, int sheetIndex, ImageOptions options)	Render one sheet to TIFF bytes.