E
exceljs/exceljs
Exceljs
ExcelJS is a Node.js spreadsheet engine and manipulation library used for reading, writing, and modifying XLSX and CSV files. It functions as a formatting tool and asynchronous streaming parser for generating complex workbooks containing formulas, rich text, and custom styles.
The library is distinguished by its ability to process large datasets using asynchronous data streaming and incremental processing, which minimizes memory usage during data extraction and file generation.
Its capability surface covers comprehensive data management, including structured tables, named ranges, and cell data manipulation. It provides extensive visual formatting options such as conditional formatting, image embedding, page setup configuration, and worksheet view controls. Additionally, the project includes security and integrity features like data validation constraints and password-protected worksheet modifications.
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.
