thinkphp 导出数据到Excel表格中

代码

public function expert()  
    {  
        vendor("PHPExcel.PHPExcel");  
        $list=db('alpacooperation')->field('*')->select();  
        $objPHPExcel = new \PHPExcel();
        $objWriter = new \PHPExcel_Writer_Excel5($objPHPExcel);
        //设置sheet名称
        $sheets=$objPHPExcel->getActiveSheet()->setTitle('合作客户');
        //设置sheet列头信息
        $objPHPExcel->setActiveSheetIndex()->setCellValue('A1', '序号')->setCellValue('B1', '名称')->setCellValue('C1', '产品')->setCellValue('D1', '名称2')->setCellValue('E1', '数量')->setCellValue('F1', '金额')->setCellValue('G1', '日期')->setCellValue('H1', '负责人')->setCellValue('I1', '行业')->setCellValue('J1', '日期')->setCellValue('K1', '编码')->setCellValue('L1', '负责人标签[在职/离职/已转岗/管理层/代理]');
        $i=2;
        foreach($list as $v){
            //设置单元格的值
            $sheets=$objPHPExcel->getActiveSheet()->setCellValue('A'.$i,$v['bianhao']);
            $sheets=$objPHPExcel->getActiveSheet()->setCellValue('B'.$i,$v['compname']);
            $sheets=$objPHPExcel->getActiveSheet()->setCellValue('C'.$i,$v['prodname']);
            $sheets=$objPHPExcel->getActiveSheet()->setCellValue('D'.$i,$v['materiel']);
            $sheets=$objPHPExcel->getActiveSheet()->setCellValue('E'.$i,$v['num']);
            $sheets=$objPHPExcel->getActiveSheet()->setCellValue('F'.$i,$v['money']);
            $sheets=$objPHPExcel->getActiveSheet()->setCellValue('G'.$i,$v['date']);
            $sheets=$objPHPExcel->getActiveSheet()->setCellValue('H'.$i,$v['salesperson']);
            $sheets=$objPHPExcel->getActiveSheet()->setCellValue('I'.$i,$v['attribute']);
            $sheets=$objPHPExcel->getActiveSheet()->setCellValue('J'.$i,$v['recorddate']);
            $sheets=$objPHPExcel->getActiveSheet()->setCellValue('K'.$i,$v['contractcode']);
            $sheets=$objPHPExcel->getActiveSheet()->setCellValue('L'.$i,$v['fla']);
            $i++;
        }
        //整体设置字体和字体大小
        $objPHPExcel->getDefaultStyle()->getFont()->setName( 'Arial');
        $objPHPExcel->getDefaultStyle()->getFont()->setSize(10);
        // $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true); //单元格宽度自适应
        $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20); //设置列宽度
        $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(50); //设置列宽度
        $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20); //设置列宽度
        $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20); //设置列宽度
        $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20); //设置列宽度
        $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(20); //设置列宽度
        $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(20); //设置列宽度
        $objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(20); //设置列宽度
        $objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(20); //设置列宽度
        $objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(20); //设置列宽度
        $objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(20); //设置列宽度
        $objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(50); //设置列宽度
       // $objPHPExcel->getActiveSheet()->getStyle('B3')->getFont()->setBold(true); //设置单元格字体加粗
        // 输出Excel表格到浏览器下载
        header('Content-Type: application/vnd.ms-excel');
        header('Content-Disposition: attachment;filename="hzkh.xls"'); //excel表格名称
        $objWriter->save('php://output'); 
    }