$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);