参考链接:
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');