CI框架,phpexcel简单使用

来源:互联网 发布:软件测试工程师薪水 编辑:程序博客网 时间:2024/06/05 12:43

参考链接:
http://www.cnblogs.com/freespider/p/3284828.html

直接上代码:

        $this->ci->load->library('PHPExcel');        $objPHPExcel = new PHPExcel();        $filename = date('Y-m-dH:i:s').'.xls';        $i = 1;        $objPHPExcel->getActiveSheet()->setCellValue('A'.$i , '渠道');        $objPHPExcel->getActiveSheet()->setCellValue('B'.$i , '手机号');        $objPHPExcel->getActiveSheet()->setCellValue('C'.$i , '变更时间');        $objPHPExcel->getActiveSheet()->setCellValue('D'.$i , '状态');        foreach($list as $val) {            $i++;            $objPHPExcel->getActiveSheet()->setCellValue('A'.$i , $val['channel']);            $objPHPExcel->getActiveSheet()->setCellValue('B'.$i , $val['phone']);            $objPHPExcel->getActiveSheet()->setCellValue('C'.$i , $val['date']);            $objPHPExcel->getActiveSheet()->setCellValue('D'.$i , $val['status']);        }        $objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);        header("Pragma: public");        header("Expires: 0");        header("Cache-Control:must-revalidate, post-check=0, pre-check=0");        header("Content-Type:application/force-download");        header("Content-Type:application/vnd.ms-execl");        header("Content-Type:application/octet-stream");        header("Content-Type:application/download");;        header('Content-Disposition:attachment;filename="'.$filename.'"');        header("Content-Transfer-Encoding:binary");        $objWriter->save('php://output');
原创粉丝点击