exceljs/exceljs

Features

• Spreadsheet Engines - Functions as a backend engine for generating professional workbooks with formulas and rich text in Node.js.
• Spreadsheet Cell Manipulators - Provides programmatic methods to set, get, and manipulate values within individual cells and merged ranges.
• Spreadsheet File I/O - Enables reading, manipulating, and writing spreadsheet data and styles to XLSX and CSV files.
• Spreadsheet Manipulation Libraries - Provides a programmatic library for reading, updating, and saving modifications to existing spreadsheet files.
• In-Memory Object Models - Maintains an in-memory hierarchy of workbooks and cells to enable precise random access manipulation of data.
• Row and Column Manipulations - Enables structural layout operations including defining widths, heights, and visibility for rows and columns.
• Zip-Compressed Serialization - Serializes internal data structures into Open XML format and packages them into compressed zip archives.
• Incremental Data Streaming - Implements memory-efficient streaming by writing data in chunks to avoid memory overflow when generating large files.
• Spreadsheet Generators - Enables programmatic generation of complex Excel files with custom styles, formulas, and layouts.
• Spreadsheet Styling - Provides extensive visual formatting including cell styles, conditional formatting, and page setups.
• Spreadsheet Data Flushing - Provides incremental processing of workbook data to minimize memory usage while reading or writing files.
• Formula Insertion - Implements mechanisms for placing mathematical or logical expressions and expected results into cells.
• Cell Styling Systems - Provides comprehensive controls over cell appearance including fonts, colors, borders, and alignment.
• Spreadsheet Row Streaming - Allows reading large workbooks using asynchronous iteration to process rows without loading the entire file into memory.
• Spreadsheet Stream Processing - Processes large XLSX and CSV files using asynchronous streaming to maintain a low memory footprint.
• Worksheet Organization - Provides management of individual worksheets including their creation, removal, and access by name or ID.
• Spreadsheet Report Exports - Allows exporting application data into formatted spreadsheets for users to download and analyze offline.
• Header and Footer Management - Enables the addition of formatted text, page numbers, and dates to the top and bottom margins of printed pages.
• Page Setup Configurations - Configures printing properties including paper size, orientation, margins, and designated print areas.
• I/O Stream Managers - Provides utilities for efficiently reading and writing binary XLSX components between memory buffers and files.
• Structured Spreadsheet Tables - Supports the definition of structured tables with headers and totals rows within a spreadsheet.
• Row Manipulations - Implements operations for adding and duplicating rows with inherited styles within a spreadsheet.
• Spreadsheet Data Validation - Implements input constraints such as dropdown lists and numeric ranges for spreadsheet cells.
• Named Range Creation - Assigns custom alphanumeric names to specific cell ranges for use in formulas and data validation.
• Data Filters - Defines cell ranges to act as filters for organizing and manipulating tabular data.
• Conditional Formatting - Applies visual styles to cell ranges based on expressions, value comparisons, or color scales.
• Rich Text Styling - Supports applying different font properties to individual sub-strings within a single cell.
• XML Style Mappings - Maps high-level styling objects to a shared styles table to minimize redundancy in the generated XML structure.
• Document Processing - Comprehensive management and manipulation of Excel worksheets.

Star history