chenmobuys / easyexcel

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

MIT

• Chenmobuys

• php
• excel
• spreadsheet
• xls
• xlsx
• csv
• writer
• reader
• sheet
• PHPExcel
• ods
• office
• worksheet
• msexcel

Published on Packagist.org on 2025-04-25 08:50 UTC

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	✖	✔	✔