Aspose.Cells for Node.js via C++ is a feature-rich and scalable API designed to process Excel spreadsheets programmatically within Node.js applications using C++. The API provides extensive capabilities including Excel file format conversion, granular worksheet styling, chart creation and rendering, complex formula calculation, and advanced spreadsheet manipulation — all without requiring Microsoft Excel. The library supports a wide range of popular spreadsheet, text, web, and image formats. Supported input/output formats include: XLS, XLSX, XLSB, XLT, XLTX, XLTM, XLSM, XML, OTS, ODS, CSV, TSV, JSON, HTML, MHTML, Numbers, SXC, FODS, and EPUB. Export-only formats include fixed-layout PDF, PDF/A, XPS, DIF, and image formats such as JPEG, PNG, BMP, SVG, TIFF, EMF, and GIF, as well as MARKDOWN, SQL, and XHTML. Aspose.Cells for Node.js via C++ includes a powerful rendering engine to generate high-fidelity visual outputs, enabling conversion of sheets, files, and charts into images and fixed-layout documents. Developers can customize worksheet display settings, manipulate rows/columns, apply security and protection settings, manage data visibility, and perform advanced formatting. It is engineered to support production-level spreadsheet processing across diverse application requirements.

Features

• Pivot Tables & Visualizations: Create Pivot Tables, charts, sparklines, and conditional formatting rules.
• Chart Rendering: Refresh charts and convert them to images or PDF.
• Comments & Hyperlinks: Create and manipulate cell comments and hyperlinks.
• Formula Engine: Set and calculate complex formulas programmatically.
• Protection Features: Apply protection at workbook, worksheet, cell, column, or row levels.
• Named Ranges: Create and manipulate named ranges.
• Smart Markers: Populate worksheets through Smart Markers for automated reporting.
• Pivot Table Refresh: Manipulate and refresh Pivot Tables.
• Document Conversion: Convert worksheets to PDF, XPS, and SVG formats.
• Rendering Engine: Render whole sheets, files, or charts to multiple image and fixed-layout formats with high fidelity.
• Display Configuration: Configure page orientation, breaks, paper size, scaling, headers, footers, zoom level, print area, and freeze panes.
• Security Options: Apply spreadsheet encryption/decryption, content protection, object protection, and scenario protection.
• Rows & Columns Manipulation: Adjust row heights and column widths, auto-size cells, insert/delete, hide/unhide, group/ungroup rows and columns.
• Worksheet Formatting: Apply formatting to sheets, columns, rows, or cells; add rich text; apply borders, patterns, and fonts; configure conditional formatting.
• Chart Creation & Manipulation: Create all standard and custom charts and refresh data dynamically.

Benefits

• No Excel Required: Perform complete Excel processing without Microsoft Excel installation.
• High-Fidelity Rendering: Converts spreadsheets, worksheets, and charts to PDF, images, and XPS with excellent visual accuracy.
• Broad Format Compatibility: Supports nearly all widely used spreadsheet, text, JSON, web, and image formats.
• Enterprise Scalability: Optimized for high-performance spreadsheet operations in production applications.
• Advanced Formula Support: Handles complex Excel formulas with a powerful calculation engine.
• Full Worksheet Control: Configure page setup, display options, scaling, and data visibility settings.
• Strong Security: Provides encryption, protection controls, and working with hidden cells, rows, and worksheets.
• Rich Visualization Tools: Comprehensive charting, sparklines, and graphics options for professional reporting.