phpExcel中文帮助手册.docx

:..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 2007XLSX, 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 toenable any worksheet protection!$objPHPExcel->getActiveSheet()->protectCells('A3:E