PHPOffice/PHPExcelArchived

Features

• Excel Automation - Provides a comprehensive PHP library for programmatically reading and writing Excel spreadsheet files.
• Spreadsheet Document Models - Utilizes an in-memory spreadsheet model that maps workbook structures to a hierarchy of objects for programmatic manipulation.
• Open XML Libraries - Implements a programmatic interface for manipulating documents using the Office Open XML standard.
• Spreadsheet Data Extractors - Extracts structured data from specific cell ranges and formats within spreadsheet files for programmatic use.
• Spreadsheet Manipulation Libraries - Provides a comprehensive PHP library for reading, writing, and manipulating spreadsheet files across multiple formats.
• In-Memory Object Models - Maintains an internal object hierarchy representing spreadsheet structures for programmatic manipulation before serialization.
• XLSX File Generation - Generates and saves spreadsheet workbooks specifically in the Office Open XML XLSX format.
• XLSX Serialization - Provides bidirectional conversion of spreadsheet state to and from the binary XML XLSX format.
• Excel-to-CSV Converters - Includes tools to convert Excel spreadsheets into CSV format and vice versa.
• Spreadsheet Import Managers - Provides utilities for uploading and parsing local Excel or CSV files as structured data sources.
• Legacy Spreadsheet Readers - Implements a reader for extracting data and structure from legacy binary XLS files.
• Spreadsheet Generators - Provides capabilities for programmatically creating and populating spreadsheet files for export.
• File Format Writers - Translates the internal object model into specific binary or XML spreadsheet file specifications via dedicated writer classes.
• Custom File Format Readers - Provides extensible reader modules that parse external spreadsheet files into the internal object model.
• Automated Report Generators - Provides capabilities to generate downloadable spreadsheet reports from application data for portable analysis.
• Automated Spreadsheet Report Generators - Enables the creation of downloadable spreadsheet documents from application data for portable reporting.
• Spreadsheet Data Exchange - Facilitates data exchange by converting between CSV files and complex spreadsheet structures.
• Memory-Efficient Data Streaming - Implements chunk-based processing to minimize memory consumption when reading or writing large spreadsheet datasets.
• External Data Importers - Converts uploaded spreadsheet files into structured formats suitable for import into databases or applications.
• Legacy Spreadsheet Parsers - Extracts data and structural information from legacy binary XLS files for use in modern applications.
• Reader-Writer Architectures - Decouples the parsing logic used to read files from the generation logic used to write them.
• Format-Specific Drivers - Uses dedicated driver classes to handle the unique structural specifications of different spreadsheet file types.
• Spreadsheet Abstractions - Provides an architectural abstraction layer that decouples spreadsheet operations from specific file format implementations.
• Spreadsheet Stream Processing - Employs streaming and caching techniques to prevent memory overflow when handling massive XLS, XLSX, and CSV files.

Star history