Aspose.Cells for Node.js via Java is a feature‑rich and scalable Excel spreadsheet processing API designed for Node.js applications that run via the Java bridge. It enables developers to programmatically generate, modify, convert, and render Excel files with high fidelity, without requiring Microsoft Excel. The library offers deep control over workbook elements including worksheets, rows, columns, cells, formatting, tables, charts, Pivot Tables, formulas, named ranges, hyperlinks, and Smart Markers. The API supports a broad range of input/output formats, such as XLS, XLSX, XLSB, XLT, XLTX, XLTM, XLSM, XML, OTS, ODS, CSV, TSV, JSON, HTML, MHTML, Numbers, SXC, FODS, and EPUB. Output‑only formats include PDF, PDF/A, XPS, image formats (JPEG, PNG, BMP, SVG, TIFF, EMF, GIF), SQL, MARKDOWN, and XHTML. Aspose.Cells for Node.js via Java comes with a built‑in rendering engine that produces high‑quality outputs when converting worksheets, charts, and entire spreadsheets to PDF, XPS, SVG, and raster images. Developers can leverage advanced worksheet formatting, protection mechanisms, encryption, display configuration, and print layout customization. It is optimized for performance and offers strong scalability for enterprise-grade spreadsheet processing.

Features

• Pivot Tables & Charts: Create Pivot Tables, charts, sparklines, and conditional formatting rules.
• Chart Rendering: Refresh charts and convert them to images or PDF formats.
• Comments & Hyperlinks: Create and manipulate cell comments and hyperlinks.
• Formula Engine: Set and calculate complex formulas with a reliable calculation engine.
• Protection Features: Protect workbooks, worksheets, cells, rows, and columns.
• Named Ranges: Create and manipulate named ranges programmatically.
• Smart Markers: Populate worksheets using Smart Markers for automated report generation.
• Pivot Table Manipulation: Manipulate and refresh Pivot Tables through the API.
• Document Conversion: Convert worksheets to PDF, XPS, and SVG formats.
• Rendering Engine: Render sheets, files, or charts with Excel‑like fidelity.
• Display Configuration: Control page orientation, breaks, paper size, scaling, headers, footers, zoom level, print area, and freeze panes.
• Security: Encrypt/decrypt spreadsheets and manage content, object, and scenario protection.
• Rows & Columns Manipulation: Adjust row height and column width, auto‑size cells, insert/delete/hide/unhide, group/ungroup rows and columns.
• Advanced Formatting: Apply worksheet, row, column, and cell formatting; add rich text; apply borders, patterns, and styles; configure conditional formatting.
• Chart Creation & Manipulation: Add customized or standard charts and dynamically refresh chart data.

Benefits

• No Excel Required: Works without Microsoft Excel or Office automation.
• Full Spreadsheet Automation: Enables end‑to‑end spreadsheet manipulation directly in Node.js environments.
• High‑Fidelity Rendering: Produces Excel‑accurate output when converting to PDF, images, or XPS.
• Broad Format Compatibility: Supports nearly all major spreadsheet, text, web, image, and fixed-layout formats.
• Enterprise‑Ready: Scalable for large data processing, reporting, and spreadsheet automation tasks.
• Powerful Formula Processing: Handles advanced Excel formulas with high precision.
• Enhanced Security: Supports encryption, workbook/worksheet protection, and content security.
• Rich Visualization: Comprehensive support for charts, sparklines, and graphic elements.