qax-os/excelize

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.

Star history