设计,技术,行业
PHPEXcel-1.8下载地址:
https://github.com/PHPOffice/PHPExcel
打开PHPEXcel-1.8文件夹,把其中classes文件复制到项目的./simplewind/vendor中
在控制器里引入
use PHPExcel_IOFactory;
use PHPExcel;
然后就是正常的查询输出了
//开始导出excel
header("content-type:text/html; charset=utf-8");
$objPHPExcel = new PHPExcel();
// 操作第一个工作表
$objPHPExcel->setActiveSheetIndex(0);
error_reporting(E_ALL);
date_default_timezone_set('Europe/London');
$objPHPExcel = new PHPExcel();
$name='这里是excel的名称'.date('Y-m-d_H_i_s',time());
// 设置表格宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(5);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(40);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(40);
// 列名赋值
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'ID');
$objPHPExcel->getActiveSheet()->setCellValue('B1', '出生时间');
$objPHPExcel->getActiveSheet()->setCellValue('C1', '姓名');
$objPHPExcel->getActiveSheet()->setCellValue('D1', '性别');
$objPHPExcel->getActiveSheet()->setCellValue('E1', '住址');
$objPHPExcel->getActiveSheet()->setCellValue('F1', '父母名称');
//excel格式问题,关于日期的需要单独设置下
$objPHPExcel->getActiveSheet()->getStyle('B')->getNumberFormat()->setFormatCode("YYYY/m/d H:I");
// 数据起始行
$row_num = 2;
// 向每行单元格插入数据
foreach($court_list as $value)//要导出的数据源
{
// 设置单元格数值
$objPHPExcel->getActiveSheet()->setCellValue('A' . $row_num, $value['id']);
$objPHPExcel->getActiveSheet()->setCellValue('B' . $row_num, date('Y-m-d H:i:s',$value['open_time']) );
$objPHPExcel->getActiveSheet()->setCellValue('C' . $row_num, $value['name'] );
$objPHPExcel->getActiveSheet()->setCellValue('D' . $row_num, $value['sex']);
$objPHPExcel->getActiveSheet()->setCellValue('E' . $row_num, $value['address_name']);
$objPHPExcel->getActiveSheet()->setCellValue('F' . $row_num, $value['referee_name_arr']);
$row_num++;
}
$objPHPExcel->getActiveSheet()->setTitle('User');
$objPHPExcel->setActiveSheetIndex(0);
header('Content-Type: applicationnd.ms-excel');
header('Content-Disposition: attachment;filename="'.$name.'.xlsx"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('php://output');
exit;