xuri/excelize
Excelize
Excelize is a Go library designed for reading, writing, and modifying Microsoft Excel files in XML-based formats. It functions as a spreadsheet file parser and generator that enables the programmatic extraction and modification of data.
The library includes a streaming spreadsheet processor to handle massive datasets incrementally, preventing system memory exhaustion during large-scale read and write operations. It also provides a chart generator to convert worksheet values or external data sources into visual representations within the spreadsheet.
Beyond core file processing, the project covers automated data extraction and the programmatic production of reports and structured data tables.
Features
- Spreadsheet Processing Engines - Provides a comprehensive engine for reading, modifying, and generating standard spreadsheet files.
- Spreadsheet Automation - Updates specific cells, formulas, and formatting in existing files without manual software intervention.
- Automated Data Extraction - Extracts and processes information from existing spreadsheets for data migration and analysis.
- Excel File Parsers - Programmatically extracts and modifies data within Microsoft Excel spreadsheet files.
- Large Dataset Streaming - Handles massive spreadsheet files through incremental streaming to minimize memory usage.
- Spreadsheet Generators - Programmatically creates Microsoft Excel files to automate report and data table production.
- XML Spreadsheet Parsers - Parses and generates the Open XML structures required for modern spreadsheet files.
- Go Spreadsheet Libraries - Provides a comprehensive Go library for reading and writing Microsoft Excel files in XML formats.
- Streaming Processors - Implements an incremental data reader to handle massive Excel datasets without exhausting system memory.
- Spreadsheet Document Models - Maintains a structured in-memory representation of spreadsheets for fast random access to cells and sheets.
- Spreadsheet Visualizations - Embeds charts and visual representations directly into spreadsheet documents.
- Chart Generators - Provides utilities to render visual charts from programmatic data definitions within spreadsheets.
- Excel - Provides a programmatic way to create visual data representations within Excel worksheets.
- Office Document Tools - Library for reading and writing Excel files.
