phpexcel 学习笔记(二)

《phpexcel 学习笔记(二)》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、PHPExcel学习笔记(二)phpexcel2013-02-0417:51:59

2、分类：php

3、字号订阅（易调）程序部分$this->load->library('phpExcel/PHPExcel');$this->load->library('phpExcel/PHPExcel/PHPExcel_IOFactory');$objPHPExcel=newPHPExcel();$objPHPExcel->getProperties()->setCreator("MaartenBalliauw")->setLastModifiedBy("MaartenBa

4、lliauw")->setTitle("Office2007XLSXTestDocument")->setSubject("Office2007XLSXTestDocument")->setDescription("DocumentforOffice2007XLSX,generatedusingPHPclasses.")->setKeywords("office2007openxmlphp")->setCategory("Testresultfile");$objPHPExcel->setActiveSheetIndex(0);//页边距//$sheet=

5、$objPHPExcel->getActiveSheet();//$pageMargins=$sheet->getPageMargins();////$margin='0.5/0.7';//$pageMargins->setTop(0);//上边距//$pageMargins->setBottom(0.21);//下//$pageMargins->setLeft(0.58);//左//$pageMargins->setRight(0.3);//右1、提示下载文件/*生成到浏览器，提供下载2007*/header("Pragma:public");heade

6、r("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('Con

7、tent-Disposition:attachment;filename="'.$list['surveyTitle'].'.xlsx"');header("Content-Transfer-Encoding:binary");$objWriter->save('php://output');//下载Excel2005//$objPHPExcel->setActiveSheetIndex(0);//$objPHPExcel->getActiveSheet()->setTitle('Excel');//header('Content-Type:applica

8、tion/vnd.ms-excel;charset=gbk');//header('Content-Disposition:attachment;filename='.$list['surveyTitle']);//header('Cache-Control:max-age=0');//$objWriter=PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel5');//$objWriter->save('php://output');设置表格样式和数据格式设置默认的字体和文字大小锚：aaa$objPHP

9、Excel->getDefaultStyle()->getFont()->setName('Arial');$objPHPExcel->getDefaultStyle()->getFont()->setSize(20);日期格式锚：bbb//获得秒值变量$dateTimeNow=time();//三个表格分别设置为当前实际的日期格式、时间格式、日期和时间格式//首先将单元格的值设置为由PHPExcel_Shared_Date::PHPToExcel方法转换后的excel格式的值，然后用过得到该单元格的样式里面数字样式再设置显示格式$objActSheet-

10、>setCellValue('C9',PHPExcel_Share