导出excel

来源：互联网发布：淘宝卖的苍蝇水叫什么编辑：程序博客网时间：2024/06/08 12:30
// 导出excelpublic 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);}
0 0