thinkphp3.1整合phpexcel

浏览:2782 发布日期:2014/08/11 分类:求助交流
thinkphp3.1整合phpexcel能成功吗?我的能输出文件,但文件总是没有任何数据,表头信息也没有,大小为0B贴上代码望高人指点~~
$m = M('Calender');
$res = $m ->select();
vendor("PHPExcel.PHPExcel");
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator("ctos")
->setLastModifiedBy("ctos")
->settitle("Office 2007 XLSX Test Document")
->setSubject("Office 2007 XLSX Test Document")
->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
->setKeywords("office 2007 openxml php")
->setCategory("Test result file");
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A1', '订单数据汇总 时间:'.date('Y-m-d H:i:s'))
->setCellValue('A2', '订单ID')
->setCellValue('B2', '下单人');
for($i=0;$i<count($res)-1;$i++){
$objPHPExcel->getActiveSheet(0)->setCellValue('A'.($i+3), $res[$i]['id']);
$objPHPExcel->getActiveSheet(0)->setCellValue('B'.($i+3), $res[$i]['soil']);
$objPHPExcel->getActiveSheet(0)->setCellValue('C'.($i+3), $res[$i]['fert']);}
$objPHPExcel->getActiveSheet()->settitle('订单汇总表');
$objPHPExcel->setActiveSheetIndex(0);
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="订单汇总表('.date('Ymd-His').').xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
最佳答案
评论( 相关
后面还有条评论,点击查看>>