前言我在项目中用过maatwebsite/Excel、mk-j/php_xlsxwriter、box/spout三个库。简单来说，maatwebsite/Excel的优势和功能是非常强大的。缺点是太占内存，导出大文件不够用。需要mk-j/php_xlsxwriter优点支持大文件写入，常规样式设置，缺点是只支持excel导出，不支持导入，不支持csv导入/导出box/spout优点是支持大文件并支持excel/csv导入/导出，缺点是不支持单元格合并。环境要求PHP版本7.1以上PHP扩展php_zip启用PHP扩展php_xmlreader安装composer需要rocky114/spreadsheet地址https://github.com/rocky114/s...exportinclude"./vendor/autoload.php";$writer=\Rocky114\Excel\Writer\WriterFactory::createXLSXWriter();$writer->setTempFolder('.');$writer->addNewSheet('sheet1');$type=['A'=>'string','B'=>'#,##0'];$writer->addHeader(['name','id'],$type)->addRow(['xinzhu',1234565])>addRow(['洛基',21])->保存();导入包括“./vendor/autoload.php”；$reader=\Rocky114\Spreadsheet\ReaderFactory::createReaderFromFile('./test.xlsx');$数据=[]；foreach($reader->getSheetIterator()as$sheet){foreach($sheet->getRowIterator()as$row){$data[]=$row;}}//或$data=$reader->getSheet()->load();
