alibaba/easyexcelArchived

Features

• Excel Processing Libraries - Provides a comprehensive Java library for memory-efficient reading and writing of XLS, XLSX, and CSV files.
• Spreadsheet Generators - Creates spreadsheet files from data objects or raw values using simple grids or multi-level headers.
• Stream-Based Parsing - Implements event-driven parsing of large spreadsheet files to minimize memory consumption.
• Large Scale Processing - Handles massive spreadsheet files in Java without memory overflow errors via streaming data processing.
• Template Engines - Populates predefined spreadsheet files with dynamic data while preserving original layouts and styles.
• Spreadsheet Template Population - Populates predefined spreadsheet files with dynamic data while preserving original layouts and styles.
• Column Mappings - Binds spreadsheet columns to Java class fields using annotations or indices to automate data conversion.
• Layout Templates - Fills pre-existing files with data while preserving the original layout and formatting.
• Spreadsheet Data Exchange - Facilitates importing and exporting data using Excel and CSV formats while mapping to Java objects.
• Event-Driven Row Parsers - Processes large files row-by-row via listeners to prevent Java heap memory overflow.
• Spreadsheet-to-Object Mappers - Binds spreadsheet columns to Java class fields through annotations for automated data mapping.
• Object Mapping - Binds spreadsheet columns to class properties using runtime reflection and annotations.
• SAX Parsers - Implements a SAX-based event parsing model to process spreadsheet files as a stream and minimize memory usage.
• Spreadsheet Parsers - Processes large spreadsheet files row-by-row via listeners to prevent Java heap memory overflow.
• Spreadsheet Stream Processing - Processes oversized spreadsheet files via streams and caching to prevent Java heap memory overflow.
• Spreadsheet Data Injection - Injects simple values, lists, and complex objects into predefined template files.
• Spreadsheet Template Injection - Populates predefined spreadsheet files by replacing placeholders with dynamic values while preserving original layouts.
• Parsing Callback Handlers - Triggers callback functions during the reading process to process data rows as they are parsed.
• Cell Value Formatters - Transforms date and numeric cells into strings using custom patterns and rounding modes.
• Data Export - Writes only specified data fields to the output spreadsheet based on provided configuration parameters.
• Worksheet Data Extraction - Targets specific sheets by name or index and skips defined header rows during processing.
• Disk Caching Systems - Utilizes disk-backed caching to offload cell data to temporary files, preventing memory overflow with massive datasets.
• Dynamic Column Header Generators - Generates column headers in real-time based on the provided input data.
• Memory-Optimized Processing - Reduces memory consumption during high-speed parsing through optimized data manipulation.
• Stream-Based Exporters - Streams data objects directly to files or HTTP responses to handle high-volume spreadsheet exports.
• Data-Driven Report Generators - Generates formatted spreadsheets from data objects using templates and dynamic headers for business reports.
• Media and Hyperlink Embedders - Inserts images, hyperlinks, formulas, and comments directly into targeted spreadsheet cells.
• Cell Styling Systems - Applies custom colors, borders, and dimensions to cells using specific styles or automatic adjustments.
• Number Formatting - Converts dates and numbers into specific spreadsheet formats to ensure correct data representation.
• Cell Merging - Combines multiple neighboring cells into a single larger cell for visual organization of reports.
• Streaming File Responses - Streams spreadsheet data directly to HTTP responses for efficient web-based file downloads.
• Java and JVM Ecosystem - Memory-efficient library for processing Excel files.

Star history