# avadim483/fast-excel-reader architecture

> Architecture diagram of the GitHub repository avadim483/fast-excel-reader, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-18). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/avadim483/fast-excel-reader
- Repository: https://github.com/avadim483/fast-excel-reader

## Overview

FastExcelReader is a PHP library for reading spreadsheet and CSV files. A caller opens a file through the Excel facade, which selects a format-specific book; the book exposes sheets, whose shared reading API supports arrays and streaming rows. Format readers parse XLSX-family, XLS, ODS, or CSV data, with shared XML/package and BIFF/OLE helpers beneath them. The README also documents styles, dates, images, metadata, and CSV parsing. Edges reflect README statements and source-index references; unsampled implementation details are not inferred.

Main entry points: [`src/FastExcelReader/Excel.php`](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Excel.php) (Excel facade), [`src/FastExcelReader/Xls/XlsBook.php`](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xls/XlsBook.php) (XLS book), [`src/FastExcelReader/Xls/XlsSheet.php`](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xls/XlsSheet.php) (XLS sheet), [`src/FastExcelReader/Ods/OdsBook.php`](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Ods/OdsBook.php) (ODS book)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_entry["Opening and shared API"]
  node_excel["Excel facade<br/>[Excel.php]"]
  node_book["Workbook API<br/>[AbstractBook.php]"]
  node_sheet_api["Sheet API<br/>[AbstractSheet.php]"]
  node_exceptions["Reader exceptions<br/>[Exception.php]"]
end

subgraph group_formats["Format readers"]
  node_xlsx_sheet["XLSX sheet<br/>[Sheet.php]"]
  node_xlsx_book["XLSX book<br/>[XlsxBook.php]"]
  node_xls_book["XLS book<br/>[XlsBook.php]"]
  node_xls_sheet["XLS sheet<br/>[XlsSheet.php]"]
  node_ods_book["ODS book<br/>[OdsBook.php]"]
  node_ods_sheet["ODS sheet<br/>[OdsSheet.php]"]
end

subgraph group_parsing["Parsing internals"]
  node_xml_reader["XML reader<br/>[Reader.php]"]
  node_package_paths["Package paths<br/>[PackagePath.php]"]
  node_spreadsheet_package["Package checks"]
  node_stream_io["Stream I/O<br/>[StreamIO.php]"]
  node_ole_reader["OLE reader<br/>[OleReader.php]"]
  node_biff_reader["BIFF reader<br/>[BiffReader.php]"]
  node_biff_records["BIFF records<br/>[BiffRecord.php]"]
  node_biff_strings["BIFF strings<br/>[BiffString.php]"]
  node_formula_parser["Formula parser<br/>[FormulaParser.php]"]
  node_xls_style["XLS styles<br/>[XlsStyle.php]"]
  node_xls_images["XLS images<br/>[XlsEscher.php]"]
end

subgraph group_csv["CSV engine"]
  node_csv_book["CSV book<br/>[CsvBook.php]"]
  node_csv_sheet["CSV sheet<br/>[CsvSheet.php]"]
  node_csv_reader["CSV reader<br/>[CsvReader.php]"]
  node_csv_options["CSV options<br/>[CsvOptions.php]"]
  node_csv_helper["CSV helpers<br/>[CsvHelper.php]"]
end

node_caller(("Library caller"))

node_caller -->|"opens file"| node_excel
node_excel -->|"selects XLSX"| node_xlsx_book
node_excel -->|"selects XLS"| node_xls_book
node_excel -->|"selects ODS"| node_ods_book
node_excel -->|"selects CSV"| node_csv_book
node_excel -->|"opens reader"| node_csv_reader
node_xlsx_book -->|"extends"| node_book
node_xls_book -->|"extends"| node_book
node_ods_book -->|"extends"| node_book
node_csv_book -->|"extends"| node_book
node_book -->|"uses"| node_sheet_api
node_xlsx_book -->|"creates"| node_xlsx_sheet
node_xls_book -->|"creates"| node_xls_sheet
node_ods_book -->|"creates"| node_ods_sheet
node_csv_book -->|"creates"| node_csv_sheet
node_xlsx_sheet -->|"extends"| node_sheet_api
node_xls_sheet -->|"extends"| node_sheet_api
node_ods_sheet -->|"extends"| node_sheet_api
node_csv_sheet -->|"extends"| node_sheet_api
node_xlsx_book -->|"creates reader"| node_xml_reader
node_ods_book -->|"validates package"| node_spreadsheet_package
node_ods_book -->|"opens content"| node_xml_reader
node_xml_reader -->|"resolves paths"| node_package_paths
node_xml_reader -->|"copies streams"| node_stream_io
node_excel -->|"checks package"| node_spreadsheet_package
node_excel -->|"writes input"| node_stream_io
node_xls_book -->|"opens container"| node_ole_reader
node_xls_book -->|"reads workbook"| node_biff_reader
node_xls_sheet -->|"reads records"| node_biff_reader
node_xls_sheet -->|"parses formulas"| node_formula_parser
node_xls_book -->|"decodes styles"| node_xls_style
node_xls_book -->|"handles images"| node_xls_images
node_biff_reader -->|"reads records"| node_biff_records
node_biff_reader -->|"reads stream"| node_ole_reader
node_xls_sheet -->|"uses records"| node_biff_records
node_xls_sheet -->|"decodes text"| node_biff_strings
node_formula_parser -->|"reads tokens"| node_biff_records
node_formula_parser -->|"uses strings"| node_biff_strings
node_formula_parser -.-> node_xls_style
node_csv_book -->|"creates reader"| node_csv_reader
node_csv_book -->|"provides sheet"| node_csv_sheet
node_csv_sheet -->|"reads rows"| node_csv_reader
node_csv_reader -->|"uses options"| node_csv_options
node_csv_reader -->|"uses helpers"| node_csv_helper

click node_excel "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Excel.php"
click node_book "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/AbstractBook.php"
click node_sheet_api "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/AbstractSheet.php"
click node_xlsx_sheet "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Sheet.php"
click node_xlsx_book "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xlsx/XlsxBook.php"
click node_xls_book "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xls/XlsBook.php"
click node_xls_sheet "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xls/XlsSheet.php"
click node_ods_book "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Ods/OdsBook.php"
click node_ods_sheet "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Ods/OdsSheet.php"
click node_csv_book "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Csv/CsvBook.php"
click node_csv_sheet "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Csv/CsvSheet.php"
click node_csv_reader "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Csv/CsvReader.php"
click node_csv_options "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Csv/CsvOptions.php"
click node_csv_helper "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Csv/CsvHelper.php"
click node_xml_reader "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Reader.php"
click node_package_paths "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Internal/PackagePath.php"
click node_spreadsheet_package "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Internal/SpreadsheetPackage.php"
click node_stream_io "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Internal/StreamIO.php"
click node_ole_reader "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xls/OleReader.php"
click node_biff_reader "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xls/BiffReader.php"
click node_biff_records "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xls/BiffRecord.php"
click node_biff_strings "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xls/BiffString.php"
click node_formula_parser "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xls/FormulaParser.php"
click node_xls_style "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xls/XlsStyle.php"
click node_xls_images "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xls/XlsEscher.php"
click node_exceptions "https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Exception.php"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_excel,node_book,node_sheet_api,node_exceptions toneBlue
class node_xlsx_sheet,node_xlsx_book,node_xls_book,node_xls_sheet,node_ods_book,node_ods_sheet toneAmber
class node_xml_reader,node_package_paths,node_spreadsheet_package,node_stream_io,node_ole_reader,node_biff_reader,node_biff_records,node_biff_strings,node_formula_parser,node_xls_style,node_xls_images toneMint
class node_csv_book,node_csv_sheet,node_csv_reader,node_csv_options,node_csv_helper toneRose
class node_caller toneIndigo
```

## Components

### Opening and shared API

- [Excel facade](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Excel.php): `src/FastExcelReader/Excel.php`
- [Workbook API](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/AbstractBook.php): `src/FastExcelReader/AbstractBook.php`
- [Sheet API](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/AbstractSheet.php): `src/FastExcelReader/AbstractSheet.php`
- [Reader exceptions](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Exception.php): `src/FastExcelReader/Exception.php`

### Format readers

- [XLSX sheet](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Sheet.php): `src/FastExcelReader/Sheet.php`
- [XLSX book](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xlsx/XlsxBook.php): `src/FastExcelReader/Xlsx/XlsxBook.php`
- [XLS book](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xls/XlsBook.php): `src/FastExcelReader/Xls/XlsBook.php`
- [XLS sheet](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xls/XlsSheet.php): `src/FastExcelReader/Xls/XlsSheet.php`
- [ODS book](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Ods/OdsBook.php): `src/FastExcelReader/Ods/OdsBook.php`
- [ODS sheet](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Ods/OdsSheet.php): `src/FastExcelReader/Ods/OdsSheet.php`

### Parsing internals

- [XML reader](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Reader.php): `src/FastExcelReader/Reader.php`
- [Package paths](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Internal/PackagePath.php): `src/FastExcelReader/Internal/PackagePath.php`
- [Package checks](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Internal/SpreadsheetPackage.php): `src/FastExcelReader/Internal/SpreadsheetPackage.php`
- [Stream I/O](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Internal/StreamIO.php): `src/FastExcelReader/Internal/StreamIO.php`
- [OLE reader](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xls/OleReader.php): `src/FastExcelReader/Xls/OleReader.php`
- [BIFF reader](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xls/BiffReader.php): `src/FastExcelReader/Xls/BiffReader.php`
- [BIFF records](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xls/BiffRecord.php): `src/FastExcelReader/Xls/BiffRecord.php`
- [BIFF strings](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xls/BiffString.php): `src/FastExcelReader/Xls/BiffString.php`
- [Formula parser](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xls/FormulaParser.php): `src/FastExcelReader/Xls/FormulaParser.php`
- [XLS styles](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xls/XlsStyle.php): `src/FastExcelReader/Xls/XlsStyle.php`
- [XLS images](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Xls/XlsEscher.php): `src/FastExcelReader/Xls/XlsEscher.php`

### CSV engine

- [CSV book](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Csv/CsvBook.php): `src/FastExcelReader/Csv/CsvBook.php`
- [CSV sheet](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Csv/CsvSheet.php): `src/FastExcelReader/Csv/CsvSheet.php`
- [CSV reader](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Csv/CsvReader.php): `src/FastExcelReader/Csv/CsvReader.php`
- [CSV options](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Csv/CsvOptions.php): `src/FastExcelReader/Csv/CsvOptions.php`
- [CSV helpers](https://github.com/avadim483/fast-excel-reader/blob/main/src/FastExcelReader/Csv/CsvHelper.php): `src/FastExcelReader/Csv/CsvHelper.php`

### Other components

- **Library caller**

## Connections

- Library caller → Excel facade: opens file (evidence: `README.md`)
- Excel facade → XLSX book: selects XLSX (evidence: `src/FastExcelReader/Excel.php`)
- Excel facade → XLS book: selects XLS (evidence: `src/FastExcelReader/Excel.php`)
- Excel facade → ODS book: selects ODS (evidence: `src/FastExcelReader/Excel.php`)
- Excel facade → CSV book: selects CSV (evidence: `src/FastExcelReader/Excel.php`)
- Excel facade → CSV reader: opens reader (evidence: `src/FastExcelReader/Excel.php`)
- XLSX book → Workbook API: extends (evidence: `src/FastExcelReader/Xlsx/XlsxBook.php`)
- XLS book → Workbook API: extends (evidence: `src/FastExcelReader/Xls/XlsBook.php`)
- ODS book → Workbook API: extends (evidence: `src/FastExcelReader/Ods/OdsBook.php`)
- CSV book → Workbook API: extends (evidence: `src/FastExcelReader/Csv/CsvBook.php`)
- Workbook API → Sheet API: uses (evidence: `src/FastExcelReader/AbstractBook.php`)
- XLSX book → XLSX sheet: creates (evidence: `src/FastExcelReader/Xlsx/XlsxBook.php`)
- XLS book → XLS sheet: creates (evidence: `src/FastExcelReader/Xls/XlsBook.php`)
- ODS book → ODS sheet: creates (evidence: `src/FastExcelReader/Ods/OdsBook.php`)
- CSV book → CSV sheet: creates (evidence: `src/FastExcelReader/Csv/CsvBook.php`)
- XLSX sheet → Sheet API: extends (evidence: `src/FastExcelReader/Sheet.php`)
- XLS sheet → Sheet API: extends (evidence: `src/FastExcelReader/Xls/XlsSheet.php`)
- ODS sheet → Sheet API: extends (evidence: `src/FastExcelReader/Ods/OdsSheet.php`)
- CSV sheet → Sheet API: extends (evidence: `src/FastExcelReader/Csv/CsvSheet.php`)
- XLSX book → XML reader: creates reader (evidence: `src/FastExcelReader/Xlsx/XlsxBook.php`)
- ODS book → Package checks: validates package (evidence: `src/FastExcelReader/Ods/OdsBook.php`)
- ODS book → XML reader: opens content (evidence: `src/FastExcelReader/Ods/OdsBook.php`)
- XML reader → Package paths: resolves paths (evidence: `src/FastExcelReader/Reader.php`)
- XML reader → Stream I/O: copies streams (evidence: `src/FastExcelReader/Reader.php`)
- Excel facade → Package checks: checks package (evidence: `src/FastExcelReader/Excel.php`)
- Excel facade → Stream I/O: writes input (evidence: `src/FastExcelReader/Excel.php`)
- XLS book → OLE reader: opens container (evidence: `src/FastExcelReader/Xls/XlsBook.php`)
- XLS book → BIFF reader: reads workbook (evidence: `src/FastExcelReader/Xls/XlsBook.php`)
- XLS sheet → BIFF reader: reads records (evidence: `src/FastExcelReader/Xls/XlsSheet.php`)
- XLS sheet → Formula parser: parses formulas (evidence: `src/FastExcelReader/Xls/XlsSheet.php`)
- XLS book → XLS styles: decodes styles (evidence: `src/FastExcelReader/Xls/XlsBook.php`)
- XLS book → XLS images: handles images (evidence: `src/FastExcelReader/Xls/XlsBook.php`)
- BIFF reader → BIFF records: reads records (evidence: `src/FastExcelReader/Xls/BiffReader.php`)
- BIFF reader → OLE reader: reads stream (evidence: `src/FastExcelReader/Xls/BiffReader.php`)
- XLS sheet → BIFF records: uses records (evidence: `src/FastExcelReader/Xls/XlsSheet.php`)
- XLS sheet → BIFF strings: decodes text (evidence: `src/FastExcelReader/Xls/XlsSheet.php`)
- Formula parser → BIFF records: reads tokens (evidence: `src/FastExcelReader/Xls/FormulaParser.php`)
- Formula parser → BIFF strings: uses strings (evidence: `src/FastExcelReader/Xls/FormulaParser.php`)
- Formula parser → XLS styles
- CSV book → CSV reader: creates reader (evidence: `src/FastExcelReader/Csv/CsvBook.php`)
- CSV book → CSV sheet: provides sheet (evidence: `src/FastExcelReader/Csv/CsvBook.php`)
- CSV sheet → CSV reader: reads rows (evidence: `src/FastExcelReader/Csv/CsvSheet.php`)
- CSV reader → CSV options: uses options (evidence: `src/FastExcelReader/Csv/CsvReader.php`)
- CSV reader → CSV helpers: uses helpers (evidence: `src/FastExcelReader/Csv/CsvReader.php`)
