XLSWriter Excel操作(*) · PHP学习

# XLSWriter Excel操作(\*) 一个高效，快速的xlsx文件导出扩展可用于在Excel 2007及以上版本XLSX文件中写入多个工作表的文本，数字，公式和超链接 <https://pecl.php.net/package/xlswriter> [文档地址](https://xlswriter-docs.viest.me/zh-cn/kuai-su-shang-shou/chuang-jian-wen-jian) ### **为什么使用xlswriter** 请参考下方对比图；由于内存原因，PHPExcel数据量`相对较大`的情况下无法正常工作，虽然可以通过`修改memory_limit`配置来解决内存问题，但完成工作的时间可能会更长; （PHPExcel是一个处理Excel,CVS文件的开源框架，可以使用它来读取、写入不同格式的电子表格,这也是PHP至今最通用的Excel处理工具,但是它有一个非常致命的缺点: 特别占内存；但不幸的是PHPExcel官方已不再维护了这个项目了，官方团队在github上又起了一个新项目，叫PhpSpreadsheet） - [Predefined Constants](https://www.php.net/manual/en/xlswriter.constants.php) - [Vtiful\\Kernel\\Excel](https://www.php.net/manual/en/class.vtiful-kernel-excel.php)— The Vtiful\\Kernel\\Excel 类 - [Vtiful\\Kernel\\Excel::addSheet](https://www.php.net/manual/en/vtiful-kernel-excel.addSheet.php)— addSheet - [Vtiful\\Kernel\\Excel::autoFilter](https://www.php.net/manual/en/vtiful-kernel-excel.autoFilter.php)— autoFilter - [Vtiful\\Kernel\\Excel::constMemory](https://www.php.net/manual/en/vtiful-kernel-excel.constMemory.php)— constMemory - [Vtiful\\Kernel\\Excel::\_\_construct](https://www.php.net/manual/en/vtiful-kernel-excel.construct.php)— constructor - [Vtiful\\Kernel\\Excel::data](https://www.php.net/manual/en/vtiful-kernel-excel.data.php)— data - [Vtiful\\Kernel\\Excel::fileName](https://www.php.net/manual/en/vtiful-kernel-excel.filename.php)— fileName - [Vtiful\\Kernel\\Excel::getHandle](https://www.php.net/manual/en/vtiful-kernel-excel.getHandle.php)— getHandle - [Vtiful\\Kernel\\Excel::header](https://www.php.net/manual/en/vtiful-kernel-excel.header.php)— header - [Vtiful\\Kernel\\Excel::insertFormula](https://www.php.net/manual/en/vtiful-kernel-excel.insertFormula.php)— insertFormula - [Vtiful\\Kernel\\Excel::insertImage](https://www.php.net/manual/en/vtiful-kernel-excel.insertImage.php)— insertImage - [Vtiful\\Kernel\\Excel::insertText](https://www.php.net/manual/en/vtiful-kernel-excel.insertText.php)— insertText - [Vtiful\\Kernel\\Excel::mergeCells](https://www.php.net/manual/en/vtiful-kernel-excel.mergeCells.php)— mergeCells - [Vtiful\\Kernel\\Excel::output](https://www.php.net/manual/en/vtiful-kernel-excel.output.php)— output - [Vtiful\\Kernel\\Excel::setColumn](https://www.php.net/manual/en/vtiful-kernel-excel.setColumn.php)— setColumn - [Vtiful\\Kernel\\Excel::setRow](https://www.php.net/manual/en/vtiful-kernel-excel.setRow.php)— setRow - - - - - - - [Vtiful\\Kernel\\Format](https://www.php.net/manual/en/class.vtiful-kernel-format.php)— The Vtiful\\Kernel\\Format 类 - [Vtiful\\Kernel\\Format::align](https://www.php.net/manual/en/vtiful-kernel-format.align.php)— align - [Vtiful\\Kernel\\Format::bold](https://www.php.net/manual/en/vtiful-kernel-format.bold.php)— bold - [Vtiful\\Kernel\\Format::italic](https://www.php.net/manual/en/vtiful-kernel-format.italic.php)— italic - [Vtiful\\Kernel\\Format::underline](https://www.php.net/manual/en/vtiful-kernel-format.underline.php)— underline 例子： # 导出文件 ``` <pre class="calibre17">``` $config = ['path' => '/home/viest'];//如果路径下有相同命名的文件，新文件会覆盖老文件 $excel = new \Vtiful\Kernel\Excel($config); // fileName 会自动创建一个工作表，你可以自定义该工作表名称，工作表名称为可选参数 $filePath = $excel->fileName('tutorial01.xlsx', 'sheet1') ->header(['Item', 'Cost']) ->data([ ['Rent', 1000], ['Gas', 100], ['Food', 300], ['Gym', 50], ]) ->output(); ``` ```