5ucms论坛

标题: PHPexcel 的常用方法 [打印本页]

作者: admin 时间: 2019-5-27 20:53
标题: PHPexcel 的常用方法
//引入库
include 'PHPExcel.php';
//创建一个excel
$objPHPExcel = new PHPExcel();
创建一个excel
$objPHPExcel = new PHPExcel();
保存excel—2007格式
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
//或者$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel); 非2007格式
$objWriter->save("xxx.xlsx");
直接输出到浏览器
$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="resume.xls"');
header("Content-Transfer-Encoding:binary");
$objWriter->save('php://output');
创建人
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw");
最后修改人
$objPHPExcel->getProperties()->setLastModifiedBy("Maarten Balliauw");
标题
$objPHPExcel->getProperties()->setTitle("Office 2007 XLSX Test Document");
设置当前的sheet
$objPHPExcel->setActiveSheetIndex(0);
设置sheet的name
$objPHPExcel->getActiveSheet()->setTitle('Simple');
设置单元格的值
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'String');
$objPHPExcel->getActiveSheet()->setCellValue('A2', 12);

作者: admin 时间: 2019-5-27 21:23
//导出
public function studentexport(){

$student = db('student')->select(); //数据库查询
$path = dirname(__FILE__); //找到当前脚本所在路径

vendor("PHPExcel.PHPExcel"); //方法一

$PHPExcel = new \PHPExcel();
$PHPSheet = $PHPExcel->getActiveSheet();
$PHPSheet->setTitle("demo"); //给当前活动sheet设置名称
$PHPSheet->setCellValue("A1", "ID")
->setCellValue("B1", "城市编号")
->setCellValue("C1", "PATH")
->setCellValue("D1", "PCODE")
->setCellValue("E1", "城市名");
$i = 2;
foreach($student as $data){
$PHPSheet->setCellValue("A" . $i, $data['id'])
->setCellValue("B" . $i, $data['type'])
->setCellValue("C" . $i, $data['guishu'])
->setCellValue("D" . $i, $data['hezuodanwei'])
->setCellValue("E" . $i, $data['name']);
$i++;
}

$PHPWriter = \PHPExcel_IOFactory::createWriter($PHPExcel, "Excel2007");
header('Content-Disposition: attachment;filename="表单数据.xlsx"');
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
$PHPWriter->save("php://output"); //表示在$path路径下面生成demo.xlsx文件
}

欢迎光临 5ucms论坛 (http://bbs.5ucms.com/)