一個高效，快速的xlsx文件導出擴展 可用于在Excel 2007及以上版本XLSX文件中寫入多個工作表的文本，數字，公式和超鏈接 [https://pecl.php.net/package/xlswriter](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 例子： # 導出文件 ``` $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(); ```