// 导出excel public function excelExport($visitlist=false,$title,$field,$list,$inforlist){ C('OUTPUT_ENCODE', false); import("ORG.PHPExcel.PHPExcel"); $objPHPExcel = new PHPExcel(); $objProps = $objPHPExcel->getProperties(); $objProps->setCreator("qianbao"); $objProps->setLastModifiedBy("qianbao"); $objProps->setTitle("qianbao"); $objProps->setSubject("qianbao"); $objProps->setDescription("qianbao"); $objProps->setKeywords("qianbao"); $objProps->setCategory("qianbao"); $objPHPExcel->setActiveSheetIndex(0); $objActSheet = $objPHPExcel->getActiveSheet(); $objActSheet->setTitle($title); foreach($field as $k => $v) { $objActSheet->setCellValue($k, $v); } if($visitlist) { foreach ($visitlist as $k => $v) { $i = 0; foreach($inforlist as $val) { $num = $k+2; $objActSheet->setCellValue($list[$i].$num, $v[$inforlist[$i]]); $i++; } } } $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); ob_end_clean(); header("Content-Type: application/vnd.ms-excel;"); header("Content-Disposition:attachment;filename=qianbao_".$title."_".date('Y-m-d',mktime()).".xls"); header("Pragma:no-cache"); header("Expires:0"); $objWriter->save('php://output'); session('export_status', 0); }
导出excel
最新推荐文章于 2024-02-26 16:19:18 发布