Axyra Sheets Guides

Task-oriented walkthroughs. Each one starts from an empty project and ends with a complete, runnable program, and each links into the Developer Reference for the full API rather than restating it.

If you are new to Axyra Sheets, start with the Quick Start instead — it is shorter and covers the object model these guides assume.

Guides

Guide What it covers
How to Create an Excel File in Java An .xlsx from scratch: values, formulas, formatting, column widths
How to Read an Excel File in Java Opening a workbook, reading typed values in bulk, handling formula errors
Read Excel Cell Values in Java Text, numbers, dates, blanks, errors, and formula results mapped to typed Java fields
Read Large Excel Files Efficiently in Java Bulk range reads, bounded row batches, numeric fast paths, memory and concurrency limits
Recalculate Excel Formulas in Java Automatic and manual calculation, recalculate() vs recalculateDirty(), expression evaluation, formula errors
How to Convert Excel to PDF in Java Server-side PDF rendering, page setup, fonts, watermarks
How to Write Data to Excel in Java Populating a sheet from a ResultSet or JSON, including very large exports
Export Database Data to Excel with Java and JDBC Mapping JDBC results to typed cells and streaming large database exports
Import Excel Data into a Database with Java Validating uploaded rows, inserting batches, and returning an annotated error workbook
Spring Boot Excel Import and Export XLSX and PDF download endpoints, workbook uploads, and production deployment settings
How to Export Excel Files in Java XLSX, XLS, CSV, ODS, JSON, PDF, HTML, encryption, and values-only output
Automate Excel Reports in Java with Templates Filling a designed template with template markers, totals, PDF output, and scheduling
Populate a Profit and Loss Excel Template from Java Querying database totals, filling a fixed P&L template, and verifying formulas

Where to go next

Get code at GitHub