导出excel

// 导出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);
}