Skip to content
- Load Excel files straight into a model, with no separate conversion step
Model.fromXLSX() and Model.fromXLSXFile() create a model from XLSX data or a file path
Model.addWorkbookFromXLSX() and Model.addWorkbookFromXLSXFile() add a workbook to an
existing model
Model.addWorkbook() now returns the added Workbook
- Defined names in external workbooks that have no value now read as
#NAME?, as in Apiary
- Bump dependencies
- Breaking change:
WorkSheet.getCellByCoords() is now internal; use the new
WorkSheet.getCellByRange() instead
- Breaking change:
Table.jsf is now internal; the new Table.style field exposes the
table’s visual style
- Breaking change: tables, comments and notes are now accessed through workbook managers
Workbook.getTable() and getTables() are replaced by Workbook.tables, a TableManager
whose get() returns Table instances (matched case-insensitively) instead of raw JSF tables
WorkSheet.getComments() and getNotes() are replaced by the Workbook.comments and
Workbook.notes managers
WorkSheet.comments and WorkSheet.notes are now always arrays
- Bump dependencies
- Breaking change: update to JSF v2
- Colours are now typed objects rather than
#-prefixed strings
showGridLines has moved from WorkSheet to the workbook views
StyleManager updated to handle new colour format; style value strings are now matched
case-insensitively
- Add
ThemeManager to expose theme data from the workbook
- Rows and columns are now
GridSize definitions and no longer guaranteed to include a size
- Add
upgradeExternal helper to handle the distinction between Workbook and External
- Fix
WorkSheet.getComments() to exclude replies to resolved parent comments when
excludeResolved is true
- Bump dependencies
- Add API for cell comments and notes
- Bump dependencies
- Support exporting workbooks to JSF format
- Include only required files in distributed package
- Type
Model._writes as Map<string, CellValue>
- JSF internals
Cell.id should not be optional
- Depend on @jsfkit/types and remove @borgar/xslx-convert
- Bump dependencies
- Fix 1904 epoch bug when converting JSF to CSF
- Adding Apiary’s row/col interface emulation
- Enable TypeScript strict mode
- Check cell value is not null rather than truthy
- Handle tables like Apiary does
- Don’t automatically change cells to errors