Node.js Excel File Format API
Aspose.Cells for Node.js via Java is a scalable and feature-rich API to process Excel spreadsheets using Node.js. API offers Excel file format conversion, worksheets styling to the most granular level, chart creation & rendering, reliable formula calculation engine and much more.
Node.js Spreadsheet API Features
- Create Pivot Tables, charts, sparklines & conditional formatting.
- Refresh existing charts & convert charts to images or PDF.
- Create & manipulate comments & hyperlinks.
- Set complex formulas & calculate results via API.
- Set protection on workbook, worksheet, cell, column or row.
- Create & manipulate named ranges.
- Populate worksheets through Smart Markers.
- Manipulate & refresh Pivot Tables via API.
- Convert worksheets to PDF, XPS & SVG formats.
- Inter-convert files to popular Excel formats.
Read & Write Excel Files
Microsoft Excel: XLS, XLSX, XLSB, XLTX, XLTM, XLSM, XML
OpenOffice: ODS
Text: CSV, Tab-Delimited, TXT
Web: HTML, MHTML
Save Excel Files As
Fixed Layout: PDF, XPS
Images: JPEG, PNG, BMP, SVG, TIFF, GIF, EMF
Getting Started with Aspose.Cells for Nodejs via Java
Installation
From the command line:
npm install aspose.cells --save
Sample Usage
var aspose = aspose || {};
aspose.cells = require("aspose.cells");
var workbook = new aspose.cells.Workbook(aspose.cells.FileFormatType.XLSX);
workbook.getWorksheets().get(0).getCells().get("A1").putValue("testing...");
workbook.save("out1.xlsx");
console.log("hello world");
Usefull Resources