API Reference
Auto-generated API documentation.
Functions
- api/aoa - addArrayToSheet, arrayToSheet
- api/book - addCellComment, appendSheet, createSheet, createWorkbook, getSheetIndex, setArrayFormula, setCellHyperlink, setCellInternalLink, setCellNumberFormat, setSheetVisibility, sheetToFormulae
- api/csv - csvToSheet, sheetToCsv, sheetToTxt
- api/format - formatCell
- api/html - htmlToSheet, sheetToHtml
- api/json - addJsonToSheet, jsonToSheet, sheetToJson
- read - read
- ssf/format - formatNumber
- utils/cell - decodeCell, decodeCol, decodeRange, decodeRow, encodeCell, encodeCol, encodeRange, encodeRow
- write - write
Type Aliases
- types - DenseSheetData, ExcelDataType, NumberFormat
Interfaces
- AOA2SheetOpts - Options for creating a worksheet from a 2D array (Array of Arrays)
- AutoFilterInfo - AutoFilter definition for a worksheet
- CellAddress - Zero-based cell address with column (c) and row (r) indices
- CellObject - Worksheet Cell Object containing value, format, formula, and metadata
- ColInfo - Column properties for worksheet column metadata
- Comment - A single comment entry within a cell's comment thread
- Comments - Array of comments attached to a cell, with optional visibility flag
- DefinedName - Defined Name (named range or named formula)
- FullProperties - Extended file properties (combines Core Properties with App-specific metadata)
- Hyperlink - Hyperlink target and optional tooltip
- JSON2SheetOpts - Options for creating a worksheet from an array of JSON objects
- MarginInfo - Page margin settings in inches
- Properties - Basic file properties from the OPC Core Properties part
- ProtectInfo - Sheet protection settings controlling what users can do on a protected sheet
- Range - Range defined by start (s) and end (e) cell addresses
- ReadOptions - Options for reading/parsing workbook files
- RowInfo - Row properties for worksheet row metadata
- Sheet - Base sheet object supporting both sparse and dense storage modes.
- Sheet2CSVOpts - Options for converting a worksheet to CSV
- Sheet2HTMLOpts - Options for converting a worksheet to an HTML table string
- Sheet2JSONOpts - Options for converting a worksheet to an array of JSON objects
- SheetProps - Properties of a single sheet within the workbook
- WBProps - Workbook-level attributes (sheets, names, views, properties)
- WBView - Workbook view settings
- WorkBook - Top-level Workbook object containing all sheets, properties, and metadata
- WorkbookProperties - Workbook-level calculation and date system properties
- WorkSheet - Worksheet object with column, row, merge, protection, and filter metadata
- WriteOptions - Options for writing/serializing workbook files