* excel导出
*/
function exportExcel($data, $savefile = null, $ti
//import("Vendor.PHPExcel");
Vendor('PHPExcel');
//$PHPExcel = new \PHPExcel();
//require_once 'PHPExcel.class.php';
//若没有指定文件名则为当前时间戳
if (is_null($savefile)) {
$savefile = time();
}
//若指字了excel表头，则把表单追加到正文内容前面去
if (is_array($ti
array_unshift($data, $ti
}
$objPHPExcel = new PHPExcel();
//Excel内容
$head_num = count($data);
foreach ($data as $k => $v) {
$obj = $objPHPExcel->setActiveSheetIndex(0);
$row = $k + 1; //行
$nn = 0;
foreach ($v as $vv) {
$col = chr(65 + $nn); //列
$obj->setCellValue($col . $row, $vv); //列,行,值
$nn++;
}
}
//设置列头标题
for ($i = 0; $i < $head_num - 1; $i++) {
$alpha = chr(65 + $i);
$objPHPExcel->getActiveSheet()->getColumnDimension($alpha)->setAutoSize(true); //单元宽度自适应
$objPHPExcel->getActiveSheet()->getst
$objPHPExcel->getActiveSheet()->getst
$objPHPExcel->getActiveSheet()->getst
$objPHPExcel->getActiveSheet()->getst
$objPHPExcel->getActiveSheet()->getst
$objPHPExcel->getActiveSheet()->getst
}
$objPHPExcel->getActiveSheet()->setti
$objPHPExcel->setActiveSheetIndex(0); //设置当前的sheet
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="' . $savefile . '.xls"');//文件名称
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); //Excel5
$objWriter->save('php://output');
}
最佳答案
