phpexcel类phpExcel使用方法介绍
下载地址:http://www.codeplex.com/PHPExcel
下面是总结的几个使用方法
include‘PHPExcel.php";
include‘PHPExcel/Writer/Excel2007.php";
//或者include‘PHPExcel/Writer/Excel5.php";用于输出.xls的
创建一个excel
$objPHPExcel=newPHPExcel();
保存excel—2007格式
$objWriter=newPHPExcel_Writer_Excel2007($objPHPExcel);
//或者$objWriter=newPHPExcel_Writer_Excel5($objPHPExcel);非2007格式
$objWriter->save("xxx.xlsx");
直接输出到浏览器
$objWriter=newPHPExcel_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");
——————————————————————————————————————?
设置excel的属性:
创建人
$objPHPExcel->getProperties()->setCreator("MaartenBalliauw");
最后修改人
$objPHPExcel->getProperties()->setLastModifiedBy("MaartenBalliauw");
标题
$objPHPExcel->getProperties()->setTitle("Office2007XLSXTestDocument");
题目
$objPHPExcel->getProperties()->setSubject("Office2007XLSXTestDocument");
描述
$objPHPExcel->getProperties()->setDescription("TestdocumentforOffice2007XLSX,generatedusingPHPclasses.");
关键字
$objPHPExcel->getProperties()->setKeywords("office2007openxmlphp");
种类
$objPHPExcel->getProperties()->setCategory("Testresultfile");
——————————————————————————————————————?
设置当前的sheet
$objPHPExcel->setActiveSheetIndex(0);
设置sheet的name
$objPHPExcel->getActiveSheet()->setTitle("Simple");
设置单元格的值
$objPHPExcel->getActiveSheet()->setCellValue("A1′,‘String");
$objPHPExcel->getActiveSheet()->setCellValue("A2′,12);
$objPHPExcel->getActiveSheet()->setCellValue("A3′,true);
$objPHPExcel->getActiveSheet()->setCellValue("C5′,‘=SUM(C2:C4)");
$objPHPExcel->getActiveSheet()->setCellValue("B8′,‘=MIN(B2:C5)");
合并单元格
$objPHPExcel->getActiveSheet()->mergeCells("A18:E22′);
分离单元格
$objPHPExcel->getActiveSheet()->unmergeCells("A28:B28′);
保护cell
$objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);//Needstobesettotrueinordertoenableanyworksheetprotection!
$objPHPExcel->getActiveSheet()->protectCells("A3:E13′,‘PHPExcel");
设置格式
//Setcellnumberformats
echodate("H:i:s")."Setcellnumberformatsn";
$objPHPExcel->getActiveSheet()->getStyle("E4′)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_EUR_SIMPLE);
$objPHPExcel->getActiveSheet()->duplicateStyle($objPHPExcel->getActiveSheet()->getStyle("E4′),‘E5:E13′);
设置宽width
//Setcolumnwidths
$objPHPExcel->getActiveSheet()->getColumnDimension("B")->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension("D")->setWidth(12);
设置font
$objPHPExcel->getActiveSheet()->getStyle("B1′)->getFont()->setName("Candara");
$objPHPExcel->getActiveSheet()->getStyle("B1′)->getFont()->setSize(20);
$objPHPExcel->getActiveSheet()->getStyle("B1′)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle("B1′)->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
$objPHPExcel->getActiveSheet()->getStyle("B1′)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
$objPHPExcel->getActiveSheet()->getStyle("E1′)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
$objPHPExcel->getActiveSheet()->getStyle("D13′)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle("E13′)->getFont()->setBold(true);
设置align
$objPHPExcel->getActiveSheet()->getStyle("D11′)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle("D12′)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle("D13′)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle("A18′)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_JUSTIFY);
//垂直居中
$objPHPExcel->getActiveSheet()->getStyle("A18′)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
设置column的border
$objPHPExcel->getActiveSheet()->getStyle("A4′)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle("B4′)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle("C4′)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle("D4′)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle("E4′)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
设置border的color
$objPHPExcel->getActiveSheet()->getStyle("D13′)->getBorders()->getLeft()->getColor()->setARGB("FF993300′);
$objPHPExcel->getActiveSheet()->getStyle("D13′)->getBorders()->getTop()->getColor()->setARGB("FF993300′);
$objPHPExcel->getActiveSheet()->getStyle("D13′)->getBorders()->getBottom()->getColor()->setARGB("FF993300′);
$objPHPExcel->getActiveSheet()->getStyle("E13′)->getBorders()->getTop()->getColor()->setARGB("FF993300′);
$objPHPExcel->getActiveSheet()->getStyle("E13′)->getBorders()->getBottom()->getColor()->setARGB("FF993300′);
$objPHPExcel->getActiveSheet()->getStyle("E13′)->getBorders()->getRight()->getColor()->setARGB("FF993300′);
设置填充颜色
$objPHPExcel->getActiveSheet()->getStyle("A1′)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle("A1′)->getFill()->getStartColor()->setARGB("FF808080′);
$objPHPExcel->getActiveSheet()->getStyle("B1′)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle("B1′)->getFill()->getStartColor()->setARGB("FF808080′);
加图片
$objDrawing=newPHPExcel_Worksheet_Drawing();
$objDrawing->setName("Logo");
$objDrawing->setDescription("Logo");
$objDrawing->setPath("./images/officelogo.jpg");
$objDrawing->setHeight(36);
$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
$objDrawing=newPHPExcel_Worksheet_Drawing();
$objDrawing->setName("Paid");
$objDrawing->setDescription("Paid");
$objDrawing->setPath("./images/paid.png");
$objDrawing->setCoordinates("B15′);
$objDrawing->setOffsetX(110);
$objDrawing->setRotation(25);
$objDrawing->getShadow()->setVisible(true);
$objDrawing->getShadow()->setDirection(45);
$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
在默认sheet后,创建一个worksheet
echodate("H:i:s")."CreatenewWorksheetobjectn";
$objPHPExcel->createSheet();
$objWriter=PHPExcel_IOFactory::createWriter($objExcel,"Excel5");
$objWriter-save("php://output");
相关文章
- BeanUtils.populate方法使用
- ABAP 之二分法的常用方法及使用注意点
- 使用arthas 快速排查问题(查看出入参,方法执行时间和热更新)
- 介绍一款 ABAP 代码搜索工具 RS_ABAP_SOURCE_SCAN 的使用方法
- 反射使用方法
- 【Groovy】map 集合 ( map 集合遍历 | 使用 map 集合的 each 方法遍历 map 集合 | 代码示例 )
- ConcurrentLinkedQueue使用和方法介绍详解编程语言
- Oracle 数据库分级查询的使用方法介绍(分级查询oracle)
- MySQL 中继日志:简单介绍和使用方法(mysql中继日志)
- 深入浅出:MySQL中AND和OR运算符使用方法(mysql中and和or)
- Oracle中使用子程序的方法(oracle中子程序)
- oracle中min函数的使用方法介绍(oracle中min使用)
- redis锁的使用方法介绍 (redis锁怎么用)
- .NET中的异步编程-EAP/APM使用方法及案例介绍
- C#SendKeys使用方法介绍
- 使用Java实现简单的server/client回显功能的方法介绍
- js中的push和join方法使用介绍
- javascript中全局对象的parseInt()方法使用介绍
- libevent库的使用方法实例
- js中array的sort()方法使用介绍
- 浏览器窗口大小变化时使用resize事件对框架不起作用的解决方法