Aspose.Cells for Node.js via Java is a feature-rich and scalable 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.
Aspose.Cells for Node.js via Java supports most popular spreadsheet formats including XLS, XLSX, ODS, SpreadsheetML, CSV, TSC & HTML.
At a Glance
An overview of Aspose.Cells for Node.js via Java capabilities.
- Convert Chart to Image
- Convert Worksheet to Image
- Convert Spreadsheet to PDF
- Formula Calculation
- Smart Markers
- Pivot Tables
- Conditional Formatting
Supported File Formats
Aspose.Cells for Node.js via Java supports popular spreadsheet file formats along with the most commonly used image & fixed-layout formats.
- Microsoft Excel: XLS, XLSX, XLSB, XLT, XLTX, XLTM, XLSM, XML, OTS
- OpenOffice: ODS
- Text: CSV, TSV, JSON
- Web: HTML, MHTML
- Numbers: Apple's iWork office suite Numbers app documents
- Others: SXC, FODS, EPUB
- Fixed Layout: PDF, PDF/A, XPS
- Data Interchange: DIF
- Images: JPEG, PNG, BMP, SVG, TIFF, EMF, GIF
- Others: MARKDOWN, SQL, XTHML
Advanced Node.js Excel 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 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 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.
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.
Aspose.Cells offers individual Excel APIs for other popular development environments as listed below: