$objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 7) . $linha, $mi3); $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 8) . $linha, $mi4); $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 9) . $linha, $mr1); $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 10) . $linha, $mr2); $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 11) . $linha, $mr3); $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 12) . $linha, $mr4); $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 13) . $linha, $mb1); $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 14) . $linha, $mb2); $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 15) . $linha, $mb3); $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 16) . $linha, $mb4); $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 17) . $linha, $ml1); $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 18) . $linha, $ml2); $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 19) . $linha, $ml3); $objPHPExcel->setActiveSheetIndex(0)->setCellValue(ExcelAux::indiceParaColuna($coluna + 20) . $linha, $ml4); //////////////////// ExcelAux::personalizarLinhaEspecial($objPHPExcel, $linha++, $coluna, $coluna + 20); /////////////////// $linha++; } /////////// $objPHPExcel->getActiveSheet()->getColumnDimension(ExcelAux::indiceParaColuna($coluna))->setWidth(30); $objPHPExcel->getActiveSheet()->getColumnDimension(ExcelAux::indiceParaColuna($coluna + 1))->setWidth(8); $objPHPExcel->getActiveSheet()->getColumnDimension(ExcelAux::indiceParaColuna($coluna + 2))->setWidth(8); $objPHPExcel->getActiveSheet()->getColumnDimension(ExcelAux::indiceParaColuna($coluna + 3))->setWidth(8); $objPHPExcel->getActiveSheet()->getColumnDimension(ExcelAux::indiceParaColuna($coluna + 4))->setWidth(8); $objPHPExcel->getActiveSheet()->getColumnDimension(ExcelAux::indiceParaColuna($coluna + 5))->setWidth(8); $objPHPExcel->getActiveSheet()->getColumnDimension(ExcelAux::indiceParaColuna($coluna + 6))->setWidth(8); $objPHPExcel->getActiveSheet()->getColumnDimension(ExcelAux::indiceParaColuna($coluna + 7))->setWidth(8); $objPHPExcel->getActiveSheet()->getColumnDimension(ExcelAux::indiceParaColuna($coluna + 8))->setWidth(8); $objPHPExcel->getActiveSheet()->getColumnDimension(ExcelAux::indiceParaColuna($coluna + 9))->setWidth(8); $objPHPExcel->getActiveSheet()->getColumnDimension(ExcelAux::indiceParaColuna($coluna + 10))->setWidth(8);