~~~
public function xlsout($filename = '數據表', $headArr, $list)
{
//導入PHPExcel類庫，因為PHPExcel沒有用命名空間，只能inport導入
import("Org.Util.PHPExcel");
import("Org.Util.PHPExcel.Writer.Excel5");
import("Org.Util.PHPExcel.IOFactory.php");
$this->getExcel($filename, $headArr, $list);
}
~~~
~~~
public function getExcel($fileName, $headArr, $data)
{
//對數據進行檢驗
if (empty($data) || !is_array($data)) {
die("data must be a array");
}
//檢查文件名
if (empty($fileName)) {
exit;
}
$date = date("Y_m_d", time());
$fileName .= "_{$date}.xls";
//創建PHPExcel對象，注意，不能少了\
$objPHPExcel = new \PHPExcel();
$objProps = $objPHPExcel->getProperties();
//設置表頭
$key = 0;
//print_r($headArr);exit;
foreach ($headArr as $v) {
//注意，不能少了。將列數字轉換為字母\
$colum = \PHPExcel_Cell::stringFromColumnIndex($key);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colum . '1', $v);
$key += 1;
}
$column = 2;
$objActSheet = $objPHPExcel->getActiveSheet();
foreach ($data as $key => $rows) {
//行寫入
$span = 0;
foreach ($rows as $keyName => $value) {
// 列寫入
$j = \PHPExcel_Cell::stringFromColumnIndex($span);
$objActSheet->setCellValue($j . $column, $value);
$span++;
}
$column++;
}
$fileName = iconv("utf-8", "gb2312", $fileName);
//重命名表
// $objPHPExcel->getActiveSheet()->setTitle('test');
//設置活動單指數到第一個表,所以Excel打開這是第一個表
$objPHPExcel->setActiveSheetIndex(0);
ob_end_clean(); //清除緩沖區,避免亂碼
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;
}
~~~
