Spreadsheets
This section covers SpreadsheetML packages (.xlsx, .xlsm, .xltx) with ooxmlsdk.
Spreadsheet packages are made of a workbook part, worksheet parts, optional shared strings, styles, tables, charts, pivot caches, drawings, and relationships between those parts. In ooxmlsdk, the entry point is usually ooxmlsdk::parts::spreadsheet_document::SpreadsheetDocument.
Use the parts feature, enabled by default, to open and save packages. Examples in this section are backed by tested Rust code in listings/spreadsheet.
In this section
- Structure of a SpreadsheetML document
- Open a spreadsheet document for read-only access
- Retrieve a list of the worksheets in a spreadsheet document
- Get worksheet information from a package
- Retrieve the values of cells in a spreadsheet
- Working with sheets
- Working with the shared string table
- Working with formulas
- Working with the calculation chain
- Working with conditional formatting
- Working with PivotTables
- Working with SpreadsheetML tables
Writer-focused chapters are being ported only when the code has a fixture in listings/ and passes cargo test --workspace.