qax-os/excelize
Excelize
Excelize is a library for reading and writing spreadsheet files in the Office Open XML format. It provides a comprehensive suite of tools for programmatically creating, modifying, and analyzing workbooks, worksheets, and cell data, ensuring compatibility across various office software suites through structured XML serialization.
The library distinguishes itself with a built-in formula calculation engine that evaluates complex mathematical and logical expressions directly against workbook data. It also features a memory-mapped streaming architecture, which allows for the efficient processing of massive spreadsheet files by handling data in chunks, thereby maintaining low memory usage during document manipulation.
Beyond basic file operations, the project supports advanced document features including style-driven formatting, conditional rules, and the embedding of graphical elements like charts and pivot tables. It also provides security capabilities, allowing users to encrypt and decrypt protected spreadsheet files to manage sensitive information.
The project is implemented in Go and is available for integration into applications requiring automated spreadsheet generation, data import and export, or complex document transformation.
Features
- Spreadsheet Generation Libraries - Provides a comprehensive library for reading and writing spreadsheet files while preserving data, styles, and formatting.
- Data Import and Export - Transfers structured information between database systems and spreadsheet formats to facilitate bulk data migration.
- Spreadsheet Automation - Provides a comprehensive suite of tools for programmatically creating, modifying, and analyzing spreadsheet data.
- Spreadsheet Generators - Provides programmatic creation and modification of spreadsheet files.
- Spreadsheet Processing Engines - Embeds and maintains graphical charts and pivot tables within spreadsheet documents.
- Spreadsheet Formula Engines - Evaluates complex mathematical and logical expressions directly against workbook data using a built-in engine.
- Workbook Encryption - Protects sensitive spreadsheet data by applying encryption to the workbook file to restrict unauthorized access.
- Streaming Processors - Processes massive spreadsheet files using memory-efficient streaming modes to maintain low memory usage.
- Data Serialization and Parsing - Parses and generates spreadsheet documents including XLSX, XLSM, and XLTM formats.
- XML Spreadsheet Parsers - Parses Office Open XML spreadsheet formats to enable programmatic interaction with complex document structures and embedded assets.
- Mathematical Calculators - Provides a built-in formula calculation engine that evaluates complex mathematical and logical expressions directly against workbook data.
- XML Serialization Formats - Encodes spreadsheet data into structured XML schemas to ensure compatibility and interoperability across office software suites.
- Spreadsheet Visualizations - Supports embedding graphical elements like charts and pivot tables, as well as applying conditional formatting to spreadsheet data.
- Memory-Mapped File Access - Features a memory-mapped streaming architecture for efficient processing of massive spreadsheet files with low memory usage.
- Buffered Input Output Managers - Accumulates data in intermediate buffers to reduce expensive system calls during high-volume write operations.
- Data Visualization Charts - Embeds graphical representations of data including charts and pivot tables to summarize information within spreadsheets.
- Chart Preservation - Maintains existing charts and visual elements when modifying spreadsheet files to ensure data integrity.
- Pivot Table Aggregators - Aggregates and groups large datasets into summary tables using configurable statistical functions.
- Document Security Tools - Provides encryption and decryption capabilities for protecting sensitive spreadsheet files and managing access to workbook data.
- Conditional Formatting - Applies visual rules to automatically change cell styling based on underlying data values.
- Data Models - Maps database tables to application objects for structured data interaction.
- Spreadsheet Styling - Supports style-driven formatting and conditional rules to decouple data content from presentation metadata.
- Encryption - Encrypts files for specific recipients and restores access to encrypted content using private keys.
- Data Encryption - Protects sensitive information by transforming plaintext into ciphertext using public and private key encryption.
- Large Dataset Optimizations - Ships memory-efficient streaming modes for processing massive spreadsheet files without loading them entirely into memory.
