tealeg/xlsxArchived

Features

• Go Spreadsheet Libraries - Provides a comprehensive Go library for reading and writing XLSX files with support for styles and formulas.
• Cell Data Writing - Writes strings, integers, floats, booleans, and formulas directly into specific spreadsheet cells.
• OOXML Structure Parsing - Reads and writes the XML structure of a workbook to manage properties and ranges.
• Range Reference Conversion - Translates between numeric coordinate pairs and alphanumeric range strings for cell referencing.
• Shared String Tables - Maps repetitive text values to a central reference table to optimize spreadsheet file size and memory.
• Struct-to-Cell Mapping - Populates spreadsheet rows by mapping fields from data structures to cell coordinates.
• Spreadsheet File I/O - Provides full read and write lifecycle support for opening existing or creating new spreadsheet files.
• Spreadsheet Relationship Mapping - Tracks internal and external associations between workbook elements using standardized relationship maps.
• In-Memory Object Models - Maintains the spreadsheet hierarchy in memory to enable fast random access and programmatic modifications.
• XLSX File Generation - Creates and saves spreadsheet workbooks in the XLSX archive format with custom data and layouts.
• XLSX Read and Write Support - Supports reading from and writing to XLSX spreadsheet files by parsing their underlying binary XML format.
• Cell Notation Writing - Supports writing and accessing data using both row-column indices and A1-style alphanumeric notation.
• Row and Column Manipulations - Performs structural layout operations including adding, removing, and retrieving rows at specific indices.
• Worksheet Data Extraction - Extracts cell values, metadata, and worksheet structures from existing XLSX files for data processing.
• XML Serialization - Translates internal memory structures into the OpenXML standard for file persistence.
• Formatted Value Extraction - Extracts cell contents as raw strings or preserves visual formatting during retrieval.
• Spreadsheet Field Matchers - Automatically aligns spreadsheet columns with Go struct fields using reflection and metadata tags.
• Spreadsheet-to-Object Mappers - Binds spreadsheet columns to Go struct fields using tags to automate data mapping.
• XML Spreadsheet Parsers - Implements a parser for extracting data and structures from modern compressed XML spreadsheet containers.
• Spreadsheet Row Mapping - Implements mapping between spreadsheet rows and Go language data structures using reflection and struct tags.
• Struct Tags - Uses reflection and metadata tags to automatically align spreadsheet columns with struct fields.
• Table Row Management - Provides structural definitions for adding, retrieving, and indexing cells within spreadsheet rows.
• Worksheet Management - Creates new worksheets and adds rows and cells to organize spreadsheet data.
• Autofilter Configurations - Defines data ranges and criteria for sorting and visibility via spreadsheet autofilters.
• Spreadsheet Data Validations - Provides predefined selection lists and input constraints within cells to control user data entry.
• Worksheet Element Management - Implements management for non-scalar spreadsheet components including hyperlinks, data validation rules, auto-filters, and merged cell ranges.
• Excel Workbook Exports - Writes the workbook state to a writer or retrieves content as a byte buffer for export.
• In-Memory Caches - Maintains workbook rows and cells in system memory to ensure fast random access and modifications.
• Spreadsheet Data Validation - Provides mechanisms for restricting the type and range of data users can enter into spreadsheet cells.
• Spreadsheet Styling - Provides capabilities for applying visual formatting like fonts, colors, and borders to exported spreadsheet files.
• Cell Coordinate Mapping - Provides translation between numeric indices and alphanumeric A1 notation for precise cell and range addressing.
• Slice-to-Row Writing - Populates spreadsheet rows efficiently by iterating over slices of data values.
• Cell Styling Systems - Defines and reuses styles for font, color, alignment, background fills, and borders within cells.
• Tabular Row Iterators - Iterates over cells within a row, providing a mechanism to process data while skipping empty cells.
• Text Run Segmenting - Supports mixed fonts and colors within a single cell by segmenting content into styled text runs.
• File Storage Systems - Library for reading and writing Excel files.
• Office Document Processing - Read modern Microsoft Excel files.
• Office Document Tools - Simplify reading of modern Excel XML formats.
• Office Document Tools - Library for reading XML-based Excel files.

Star history