phpExcel中文帮助手册.doc

phpExcel中文帮助手册1、设置excel的属性：创建人$objPHPExcel-getProperties()-setCreator(Maarten Balliauw);最后修改人$objPHPExcel-getProperties()-setLastModifiedBy(Maarten Balliauw);标题$objPHPExcel-getProperties()-setTitle(Office 2007 XLSX Test Document);题目$objPHPExcel-getProperties()-setSubject(Office 2007 XLSX Test Document);描述$objPHPExcel-getProperties()-setDescription(Test document for Office 2007 XLSX, generated using PHP classes.);关键字$objPHPExcel-getProperties()-setKeywords(office 2007 openxml php);种类$objPHPExcel-getProperties()-setCategory(Test result file);设置当前的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); / Needs to be set to true in order to enable any worksheet protection!$objPHPExcel-getActiveSheet()-protectCells(A3:E13, PHPExcel);设置格式复制代码代码示例:/ Set cell number formatsecho date(H:i:s) . Set cell number formatsn;$objPHPExcel-getActiveSheet()-getStyle(E4)-getNumberFormat()-setFormatCode(PHPExcel_Style_NumberFormat:FORMAT_CURRENCY_EUR_SIMPLE);$objPHPExcel-getActiveSheet()-duplicateStyle( $objPHPExcel-getActiveSheet()-getStyle(E4), E5:E13 );设置宽width复制代码代码示例:/ Set column widths$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(FF);$objPHPExcel-getActiveSheet()-getStyle(D13)-getBorders()-getTop()-getColor()-setARGB(FF);$objPHPExcel-getActiveSheet()-getStyle(D13)-getBorders()-getBottom()-getColor()-setARGB(FF);$objPHPExcel-getActiveSheet()-getStyle(E13)-getBorders()-getTop()-getColor()-setARGB(FF);$objPHPExcel-getActiveSheet()-getStyle(E13)-getBorders()-getBottom()-getColor()-setARGB(FF);$objPHPExcel-getActiveSheet()-getStyle(E13)-getBorders()-getRight()-getColor()-setARGB(FF);设置填充颜色复制代码代码示例:$objPHPExcel-getActiveSheet()-getStyle(A1)-getFill()-setFillType(PHPExcel_Style_Fill:FILL_SOLID);$objPHPExcel-getActiveSheet()-getStyle(A1)-getFill()-getStartColor()-setARGB(FF);$objPHPExcel-getActiveSheet()-getStyle(B1)-getFill()-setFillType(PHPExcel_Style_Fill:FILL_SOLID);$objPHPExcel-getActiveSheet()-getStyle(B1)-getFill()-getStartColor()-setARGB(FF);加图片复制代码代码示例:$objDrawing = new PHPExcel_Worksheet_Drawing();$objDrawing-setName(Logo);$objDrawing-setDescription(Logo);$objDrawing-setPath(./images/officelogo.jpg);$objDrawing-setHeight(36);$objDrawing-setWorksheet($objPHPExcel-getActiveSheet();$objDrawing = new PHPExcel_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();/处理中文输出问题需要将字符串转化为UTF-8编码，才能正常输出，否则中文字符将输出为空白，如下处理：$str = iconv(gb2312, utf-8, $str);或者可以写一个函数专门处理中文字符串：复制代码代码示例:function convertUTF8($str) if(empty($str) return ; return iconv(gb2312, utf-8, $str);/从数据库输出数据处理方式从数据库读取数据如：复制代码代码示例:$db = new Mysql($dbconfig);$sql = SELECT * FROM 表名;$row = $db-GetAll($sql); / $row 为二维数组$count = count($row);for ($i = 2; $i getActiveSheet()-setCellValue(A . $i, convertUTF8($row$i-21); $objPHPExcel-getActiveSheet()-setCellValue(B . $i, convertUTF8($row$i-22); $objPHPExcel-getActiveSheet()-setCellValue(C . $i, convertUTF8($row$i-23); $objPHPExcel-getActiveSheet()-setCellValue(D . $i, convertUTF8($row$i-24); $objPHPExcel-getActiveSheet()-setCellValue(E . $i, convertUTF8(date(Y-m-d, $row$i-25); $objPHPExcel-getActiveSheet()-setCellValue(F . $i, convertUTF8($row$i-26); $objPHPExcel-getActiveSheet()-setCellValue(G . $i, convertUTF8($row$i-27); $objPHPExcel-getActiveSheet()-setCellValue(H . $i, convertUTF8($row$i-28);在默认sheet后，创建一个worksheet 在这里插入一段，之前脚本学堂也为大家介绍过几篇有关phpexcel的文章，有兴趣的朋友可以看看：使用PHPExcel判别和格式化Excel中的日期格式的例子phpexcel导出excel的颜色与网页中颜色不一致的解决方法CI中使用PHPExcel导出数据到Excel复制代码代码示例:echo date(H:i:s) . Create new Worksheet objectn;$objPHPExcel-createSheet();$objWriter = PHPEx