PHPExcel 主要目的是使用尽量少的内存读取大型文件。
使用 composer 安装
composer require chen/php-excel -vvv<?php use Excel\SpreadsheetFactory; $reader = SpreadsheetFactory::createReader(SpreadsheetFactory::EXCEL_CSV);<?php use Excel\SpreadsheetFactory; $filename = 'sample.csv'; $reader = SpreadsheetFactory::createReaderForFile($filename);<?php use Excel\Reader\BaseReader; class SampleReader extends BaseReader { /** * Load filename * * @return void */ public function load($filename): void { // TODO } ... } ---------------------------------------------- <?php use Excel\SpreadsheetFactory; SpreadsheetFactory::registerReader('Xlsx', SampleReader::class);<?php use Excel\SpreadsheetFactory; $filename = 'sample.xlsx'; $reader = SpreadsheetFactory::createReaderForFile($filename); /** * @example * [ * 'Sheet1', * 'Sheet2', * 'Sheet3', * ] */ $worksheetNames = $reader->listWorksheetNames($filename);<?php use Excel\SpreadsheetFactory; $filename = 'sample.xlsx'; $reader = SpreadsheetFactory::createReaderForFile($filename); /** * @example * [ * [ * 'worksheetName' => 'Sheet1', * 'lastColumnLetter' => 'C', * 'lastColumnIndex' => '2', * 'totalRows' => '2', * 'totalColumns' => '3', * ], * [ * 'worksheetName' => 'Sheet2', * 'lastColumnLetter' => 'C', * 'lastColumnIndex' => '2', * 'totalRows' => '2', * 'totalColumns' => '3', * ], * [ * 'worksheetName' => 'Sheet3', * 'lastColumnLetter' => 'C', * 'lastColumnIndex' => '2', * 'totalRows' => '2', * 'totalColumns' => '3', * ], * ] */ $worksheetInfo = $reader->listWorksheetInfo($filename);<?php use Excel\SpreadsheetFactory; $filename = 'sample.xlsx'; $reader = SpreadsheetFactory::createReaderForFile($filename); foreach($reader->getRowIteratorByWorksheetIndex(0) as $row) { foreach($row->getCellIterator() as $cell) { // TODO... } }<?php use Excel\SpreadsheetFactory; $filename = 'sample.xlsx'; $reader = SpreadsheetFactory::createReaderForFile($filename); foreach($reader->getRowIteratorByWorksheetName('Sheet1') as $row) { foreach($row->getCellIterator() as $cell) { // TODO... } }