### Excel 導出 jig 2018-3-3 **位置：** Common\Tools\ExcelTools.class.php **參數：** * @param $title array 標題 * @param $data array 內容 二維數組 * @param $filename string 文件名 **調用：** ~~~ use Common\Tools\ExcelTools; // 調用封裝Excel工具類 public function export() { $title = array('姓名', '城市', '手機'); $data = array( array('李明', '北京', '13812345678'), array('王偉', '深圳', '15887654321') ); $filename = '同學通訊錄'; $e = new ExcelTools(); $e->exportExcel($title, $data, $filename); } ~~~ **完整代碼：** ~~~ /* * 導出Excel * * jig 2018-3-3 * @param $title array 標題 * @param $data array 內容 二維數組 * @param $filename string 文件名 * return resource; */ public function exportExcel($title, $data, $filename) { $this->_title = $title; $phpExcel = new \PHPExcel(); $active_sheet = $phpExcel->getActiveSheet(); if (!is_null($this->getTitle())) { $i='A'; $j = 1; foreach ($this->getTitle() as $key => $value) { $active_sheet->setCellValue($i . $j, $value); $i++; } $j++; } foreach ($data as $key => $value) { $i = 'A'; foreach ($value as $k => $v) { // setCellValueExplicit 修改單元格的值為文本格式，解決首位0被去掉的BUG lanson 2017-11-21 if (preg_match("/^[0]+\d+$/", $v)) { $active_sheet->setCellValueExplicit($i . $j, $v, 'str'); } elseif(preg_match("/^\d{12,100}$/", $v)) { $active_sheet->setCellValueExplicit($i . $j, $v, 'str'); } else { $active_sheet->setCellValue($i . $j, $v); } $i++; } $j++; } // $objWrite = \PHPExcel_IOFactory::createWriter($phpExcel,"Excel2007"); $objWrite = \PHPExcel_IOFactory::createWriter($phpExcel, "Excel5"); // $objWrite->save($filename); header("Content-type:application/vnd.ms-excel"); //lanson 2017-03-17 新加這個 header("Content-Disposition:attachment;filename=$filename.xls"); header("Content-Type:application/octet-stream"); header("Content-Transfer-Encoding:binary"); header("Pragma:no-cache"); $objWrite->save('php://output'); exit(); } ~~~