aspose.cells

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

• Product Page
• Product Documentation
• Blog
• API Reference
• Source Code Samples
• Free Support