Node.js via Java Excel File Format APIs

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 using Smart Markers

Manipulate and refresh Pivot Tables via API

Convert worksheets to PDF, XPS & SVG formats

Rendering Excel Spreadsheets

Aspose.Cells for Node.js via Java uses its rendering engine for rendering to the Microsoft Excel with the highest of fidelity. While using Node.js via Java Excel Processing library, one can convert whole sheets, individual files or charts to multiple images and fixed-layout formats.

Flexible Display Options

Aspose.Cells for Node.js via Java provides full control of the worksheet's page setup one can manipulate worksheet's display options like page orientation, breaks, size, scaling, headers, footers, and zoom level. Furthermore, developers can control the data visibility with the help of print area and freeze panes to suit application specifications.

Security Options

Aspose.Cells for Node.js via Java offers a wide range of security features including spreadsheet encryption/decryption, content, object & scenario protection as well as the ability to hide and unhide rows, columns & worksheets.

Manipulate Rows & Columns

Aspose.Cells for Node.js via Java allows you to manipulate rows and columns in many different ways. You can easily adjust row height & column width, auto-size the cells according to the contents, insert & delete, hide & un-hide as well as group & un-group rows & columns.

Comprehensive Support for Worksheet Formatting

Aspose.Cells for Node.js via Java provides advanced formatting features that allow you to control the presentation of your data. You can apply formatting to a worksheet, column, row or a cell or add Rich Text to a single cell, apply borders, set background patterns and font styling. The API also allows to add, manipulate & calculate conditional formatting rules on the fly.

Chart Creation, Manipulation & Rendering

Aspose.Cells for Node.js via Java provides full support for charting. One can easily add customized or standard charts using the API, and dynamically set the data in order to refresh the charts.