《phpExcel中文帮助手册.doc》由会员分享,可在线阅读,更多相关《phpExcel中文帮助手册.doc(8页珍藏版)》请在金锄头文库上搜索。
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 2007 XLSX, generated using PHP classes.);关键字$objPHPExcel-getProperties()-setKeywords(office 2007 openxml php);种类$objPHPExcel-getProperties()-setCategory(Test result file);设置当前的sheet$objPHPExcel-setActiveSheetIndex(0);设置sheet的
3、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-ge
4、tActiveSheet()-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
5、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);$objP
6、HPExcel-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-getActi
7、veSheet()-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-g
8、etActiveSheet()-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()-getS
9、tyle(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-getAc
10、tiveSheet()-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
11、(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);$ob
12、jPHPExcel-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()-setBorde
13、rStyle(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)-
14、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)-getBorder
15、s()-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()-setFill