chenmobuys / easyexcel
Easy excel library.
1.0.0
2025-04-25 08:46 UTC
Requires
- php: ^7.1||^8.0
- ext-fileinfo: *
- ext-iconv: *
- ext-libxml: *
- ext-mbstring: *
- ext-simplexml: *
- ext-xml: *
- ext-xmlreader: *
- ext-xmlwriter: *
- ext-zip: *
Requires (Dev)
- phpunit/phpunit: ^5.7||^6.5||^7.5||^8.5||^9.5
README
English · 中文
Read large spreadsheets using very low memory usage, supports formats CSV, ODS, XLS, XLSX.
Install
composer require chenmobuys/easyexcel
Usage
<?php use EasyExcel\Factory; $filename = 'Excel.xlsx'; $reader = Factory::createReaderForFile($filename); $readerExcel = $reader->load($filename); $activeSheet = $readerExcel->getActiveSheet(); foreach ($activeSheet->getRowIterator() as $row) { // Do something... }
Features implemented
- ✔ Supported
- ● Partially supported
- ✖ Not supported
- N/A Cannot be supported
Feature | Csv | Ods | Xls | Xlsx |
---|---|---|---|---|
CellOriginalValue | ✔ | ✔ | ✔ | ✔ |
CellFormattedValue | N/A | ✔ | ✔ | ✔ |
CellFormulaValue | N/A | ✔ | ✔ | ✔ |
CellStyle | N/A | ✖ | ✔ | ✔ |
Hyperlinks | N/A | ✔ | ✔ | ✔ |
MergeCells | N/A | ✖ | ✔ | ✔ |