PHP ExcelReport示例

 protected function formatTable(PHPExcel_Worksheet $activeSheet, $x1, $y1, $x2, $y2, $customParameters = array())
 {
     parent::formatTable($activeSheet, $x1, $y1, $x2, $y2, $customParameters);
     $activeSheet->getStyle('H9:I' . $y2)->applyFromArray(array('alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT, 'vertical' => PHPExcel_Style_Alignment::VERTICAL_CENTER)));
     $activeSheet->getStyle('J8:J' . $y2)->applyFromArray(array('alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT, 'vertical' => PHPExcel_Style_Alignment::VERTICAL_CENTER)));
 }

示例#2

显示文件

文件： ReportController.php 项目： anthony-poon/appraisal-system

 function dataDump($param = null)
 {
     $report = new ExcelReport($param["uid"]);
     $report->generateRawDataSheet();
     $report->generateRawPartA();
     $report->generateRawPartB1();
     $report->generateRawPartB2();
     $report->generateTraining();
     $report->generateOverallComments();
     $report->generateGoals();
     $report->outputExcel();
 }