PHP ExcelAux::personalizarLinhaEspecialの例

コード例 #1

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

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