Download the PHP package fluentxlsx/fluentxlsx without Composer
On this page you can find all versions of the php package fluentxlsx/fluentxlsx. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download fluentxlsx/fluentxlsx
More information about fluentxlsx/fluentxlsx
Files in fluentxlsx/fluentxlsx
Package fluentxlsx
Short Description A fluent, developer-friendly PHP library that unifies the functionalities of SimpleXLSX (for reading Excel files) and SimpleXLSXGen (for writing Excel files).
License MIT
Informations about the package fluentxlsx
FluentXLSX
A fluent, developer-friendly PHP library that unifies the functionalities of SimpleXLSX (for reading Excel files) and SimpleXLSXGen (for writing Excel files).
With FluentXLSX, you can read, transform, and write Excel files in a single, consistent, and expressive API — without worrying about the differences between underlying libraries.
Features
- Unified API for reading and writing XLSX files.
- Read from file or raw data.
- Select sheets by index, name, or active sheet.
- Access rows, headers, and individual cells (by Excel reference or index).
- Write new Excel files with multiple sheets.
- Save or download generated Excel files.
- Convert sheets to associative arrays (headers as keys).
Dependencies
This library is built on top of the following libraries which are provided by shuchkin:
- SimpleXLSX - lightweight reader for .xlsx files.
- SimpleXLSXGen - lightweight generator for .xlsx files.
Credit:
Special thanks to Sergey Shuchkin for creating and maintaining SimpleXLSX and SimpleXLSXGen, which make this project possible.
Both are stable, battle-tested libraries that handle the low-level complexity of the XLSX format.
FluentXLSX focuses on providing a clean, expressive, and fluent API over them.
Installation
Install via Composer:
Usage Examples
Read an Excel file
Read from raw data
Select sheet by name or active sheet
Get specific rows or range
Get explicit rows
Get headers
Convert to associative array
Get all sheet names
Get a cell by reference or index
Direct Access to SimpleXLSX Methods
You can also use methods from the underlying SimpleXLSX library directly on the reader object returned by Excel::read().
This allows you to access advanced features or methods not wrapped by FluentXLSX.
Example:
Other SimpleXLSX methods can be used in the same way.
Refer to the SimpleXLSX documentation for more details.
Write an Excel file
Creating and Managing Sheets
Add a new sheet
Add multiple sheets
Select an existing sheet to work with
- If sheet() is not called, the first sheet is selected by default.
Writing Cell Values
Write a value using Excel notation
Write using row/column coordinates
- The cell() and cellEx() methods automatically create intermediate rows or columns if they don’t exist.
Writing Rows and Data Arrays
Add a single row
Add multiple rows at once
Saving and Downloading
Save to file
Output to browser for download
Get binary data (e.g., to send as attachment)
Accessing SimpleXLSXGen Directly
You can also use methods from the underlying SimpleXLSXGen library directly on the reader object returned by Excel::write().
This allows you to access advanced features or methods not wrapped by FluentXLSX.
Refer to the SimpleXLSXGen documentation for more details.
Contribution
PRs and issues are welcome! Please open a GitHub issue to discuss new ideas, bugs, or feature requests.