phpExcel中文帮助手册.docVIP

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 formats\n;$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-getActiveShe