PHP ExcelAux::personalizacaoTituloの例

コード例 #1

ファイル: downloadNotas.php プロジェクト: andersongimino/area51

 $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 14) . $linha, $mb3);
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 15) . $linha, $ml3);
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 16) . $linha, $md4);
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 17) . $linha, $mi4);
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 18) . $linha, $mr4);
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 19) . $linha, $mb4);
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 20) . $linha, $ml4);
 ///////////////////
 ExcelAux::personalizarLinhaEspecial($objPHPExcel, $linha++, $coluna, $coluna + 20);
 $linha++;
 ///////////////////
 $objPHPExcel->setActiveSheetIndex(0)->mergeCells(ExcelAux::indiceParaColuna($coluna) . $linha . ":" . ExcelAux::indiceParaColuna($coluna + 20) . $linha);
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna) . $linha++, 'DISTRIBUIÇÃO PERCENTUAL DO DESEMPENHO DOS ALUNOS DO ' . strtoupper($arraySeries[$key]) . ' AO LONGO DE CADA BIMESTRE');
 $linha++;
 /////////////////////
 ExcelAux::personalizacaoTitulo($objPHPExcel, $linha, $coluna, $coluna + 20);
 ///////////
 $objPHPExcel->getActiveSheet()->getStyle(ExcelAux::indiceParaColuna($coluna + 1) . $linha . ":" . ExcelAux::indiceParaColuna($coluna + 20) . $linha)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
 ///////////
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 1) . $linha, 'D = Entre 0 e 2');
 $objPHPExcel->setActiveSheetIndex(0)->mergeCells(ExcelAux::indiceParaColuna($coluna + 1) . $linha . ":" . ExcelAux::indiceParaColuna($coluna + 4) . $linha);
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 5) . $linha, 'I = Entre 2 e 4');
 $objPHPExcel->setActiveSheetIndex(0)->mergeCells(ExcelAux::indiceParaColuna($coluna + 5) . $linha . ":" . ExcelAux::indiceParaColuna($coluna + 8) . $linha);
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 9) . $linha, 'R = Entre 4 e 6');
 $objPHPExcel->setActiveSheetIndex(0)->mergeCells(ExcelAux::indiceParaColuna($coluna + 9) . $linha . ":" . ExcelAux::indiceParaColuna($coluna + 12) . $linha);
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 13) . $linha, 'B = Entre 6 e 8');
 $objPHPExcel->setActiveSheetIndex(0)->mergeCells(ExcelAux::indiceParaColuna($coluna + 13) . $linha . ":" . ExcelAux::indiceParaColuna($coluna + 16) . $linha);
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 17) . $linha, 'L = maior que 8');
 $objPHPExcel->setActiveSheetIndex(0)->mergeCells(ExcelAux::indiceParaColuna($coluna + 17) . $linha . ":" . ExcelAux::indiceParaColuna($coluna + 20) . $linha++);
 ////////////////////
 ExcelAux::personalizarLinhaEspecial($objPHPExcel, $linha, $coluna, $coluna + 20);