The Excel packages are in private preview with alpha customers. Contact us to get access.
.xlsx workbooks in Node and the browser, without Microsoft Excel, LibreOffice or a server.
What you can do
- Edit a workbook with a JS API.
ExcelWorkbookis Office.js-like: it follows the names in the Office JavaScript API for worksheets, ranges, formats, tables and charts. See Concepts. - Calculate formulas. The formula engine recalculates what an edit changes. Read a cell and you get the new value. See Recalculation.
- Export PDF or PNG. One page or one image for each sheet, or one range. PDF is in Node only. A PNG of a range works in the browser too. See PDF and PNG.
- Show a workbook in a page. A canvas grid with charts, pictures and the sheet tabs. See View.
- Add a spreadsheet editor to your app.
@reductoai/xlsx-editorgives the Home tab, the editable grid, and windows and menus that work like those in Microsoft Excel, in one mount call. See Editor.
Example
Packages
Entry points
Not supported
- 3D references (
Sheet1:Sheet3!A1) - Add-in functions and external references keep their cached values
FORECAST.ETSand its forms- Functions that need a server:
CUBE*,WEBSERVICE,STOCKHISTORY,RTD,IMAGEandTRANSLATEgive#NAME? - Pivot refresh with ungrouped dates or calculated fields
- Flash Fill, and Paste Special other than Paste Values