### 導出為excel > $fileName = '表名'，$headArr = ['關鍵詞', '出現次數']（對應excel的表頭）; ```php $data = [ [ '數據1', '數據 2' ], [ '數據1', '數據2' ] ]; ``` ```php /** * 導出詞云表 * User: mi * Date: 2020-09-29 */ public function chu_ci_list() { $fileName = '詞云圖統計表'; $headArr = ['關鍵詞', '出現次數']; $ci_list = Cache::get('ci_list'); $ci_data = unserialize($ci_list); $data = array(); $i = 0; foreach ($ci_data as $k => $item){ $data[$i][0] = $k; $data[$i][1] = $item; $i++; } $fileName .= "-" . date("YmdHi", time()) . ".xlsx"; $objPHPExcel = new \PHPExcel(); $objPHPExcel->getProperties(); $key = ord("A"); // 設置表頭 foreach ($headArr as $v) { $colum = chr($key); $objPHPExcel->setActiveSheetIndex(0)->setCellValue($colum . '1', $v); $objPHPExcel->setActiveSheetIndex(0)->setCellValue($colum . '1', $v); $key += 1; } $column = 2; $objActSheet = $objPHPExcel->getActiveSheet(); foreach ($data as $key => $rows) { // 行寫入 $span = ord("A"); foreach ($rows as $keyName => $value) { // 列寫入 $objActSheet->setCellValue(chr($span) . $column, $value); $span++; } $column++; } $fileName = iconv("utf-8", "gb2312", $fileName); // 重命名表 $objPHPExcel->setActiveSheetIndex(0); // 設置活動單指數到第一個表,所以Excel打開這是第一個表 header('Content-Type: application/vnd.ms-excel'); header("Content-Disposition: attachment;filename=$fileName"); header('Cache-Control: max-age=0'); $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); // 文件通過瀏覽器下載 exit(); } ```