1、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 Docume

2、nt);描述$objPHPExcel-getProperties()-setDescription(Test document for Office 2007XLSX, generated using PHP classes.);關鍵字$objPHPExcel-getProperties()-setKeywords(office 2007 openxml php);種類$objPHPExcel-getProperties()-setCategory(Test result file);設置當前的sheet$objPHPExcel-setActiveSheetIndex(0);設置sheet的n

3、ame$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-getA

4、ctiveSheet()-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 wo

5、rksheetprotection!$objPHPExcel-getActiveSheet()-protectCells(A3:E13, PHPExcel);設置格式復制代碼代碼示例：/ Set cell number formatsecho date(H:i:s) . Set cell number formats n;$objPHPExcel-getActiveSheet()-getStyle(D13)-getAlignment()-setHorizontal(PHPExcel_Style_Alig$objPHPExcel-getActiveSheet()-getStyle(E4)-get

6、NumberFormat()-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

7、-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()-g

8、etStyle(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-ge

9、tActiveSheet()-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)-get

10、Alignment()-setHorizontal(PHPExcel_Style_Alignment:HORIZONTAL_RIGHT);nment:HORIZONTAL_RIGHT);$objPHPExcel-getActiveSheet()-getStyle(A18)-getAlignment()-setHorizontal(PHPExcel_Style_Alignment:HORIZONTAL_JUSTIFY);/垂直居中復制代碼代碼示例$objPHPExcel-getActiveSheet()-getStyle(A18)-getAlignment()-setVertical(PHPEx

11、cel_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);$objPHPExc

12、el-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(

13、PHPExcel_Style_Border:BORDER_THIN);設置border的color復制代碼代碼示例$objPHPExcel-getActiveSheet()-getStyle(D13)-getBorders()-getLeft()-getColor()-setARGB(FF9 93300);$objPHPExcel-getActiveSheet()-getStyle(D13)-getBorders()-getTop()-getColor()-setARGB(FF9 93300);$objPHPExcel-getActiveSheet()-getStyle(D13)-getBor

14、ders()-getBottom()-getColor()-setARGB( FF993300);$objPHPExcel-getActiveSheet()-getStyle(E13)-getBorders()-getTop()-getColor()-setARGB(FF9 93300);$objDrawing-setWorksheet($objPHPExcel-getActiveSheet();$objPHPExcel-getActiveSheet()-getStyle(E13)-getBorders()-getBottom()-getColor()-setARGB(FF993300);$o

15、bjPHPExcel-getActiveSheet()-getStyle(E13)-getBorders()-getRight()-getColor()-setARGB(FF993300);設置填充顏色復制代碼代碼示例：$objPHPExcel-getActiveSheet()-getStyle(A1)-getFill()-setFillType(PHPExcel_Style_Fill:FILL_SOL ID);$objPHPExcel-getActiveSheet()-getStyle(AT)-getFill()-getStartColor()-setARGB(FF808080);$objP

16、HPExcel-getActiveSheet()-getStyle(B1)-getFill()-setFillType(PHPExcel_Style_Fill:FILL_SOL ID);$objPHPExcel-getActiveSheet()-getStyle(B1)-getFill()-getStartColor()-setARGB(FF808080);加圖片復制代碼代碼示例：$objDrawing = new PHPExcel_Worksheet_Drawing();$objDrawing-setName(Logo);$objDrawing-setDescription(Logo);$o

17、bjDrawing-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)

18、;$objDrawing-setOffsetX(110);$objDrawing-setRotation(25);$objDrawing-getShadow()-setVisible(true);$objDrawing-getShadow()-setDirection(45);/處理中文輸出問題需要將字符串轉化為UTF-8編碼，才能正常輸出，否則中文字符將輸出為空白，如下處理:$str = iconv (gb2312, utf-8, $str);或者可以寫一個函數專門處理中文字符串：復制代碼代碼示例：function convertUTF8($str)if(empty($str) return

19、 ;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 .

20、$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()-setCellV

21、alue(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導出數