$end = PHPExcel_Cell::stringFromColumnIndex($x + 1) . ($i + 1); $merge = $start . ":" . $end; $objPHPExcel->setActiveSheetIndex(0)->mergeCells($merge); $objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow($x, $i + 1, $generalListCertificateTitles[7]); $objPHPExcel->getActiveSheet()->getStyle($start)->applyFromArray(getPropertiesHeaderText()); $i = populateTableCells($objPHPExcel, $i + 2, $generalListCertificateModalTable6Title, $Prueba_ST, 0, PHPExcel_Cell::stringFromColumnIndex($x), PHPExcel_Cell::stringFromColumnIndex($x + 1)); if (isset($value["Habitacion"]["Redes_Visibles"])) { // redes visibles $Redes_Visibles = getArrayObjectRedes_Visibles($val["Pruebas_Wifi"][0]); $start = PHPExcel_Cell::stringFromColumnIndex($x) . ($i + 1); $end = PHPExcel_Cell::stringFromColumnIndex($x + 1) . ($i + 1); $merge = $start . ":" . $end; $objPHPExcel->setActiveSheetIndex(0)->mergeCells($merge); $objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow($x, $i + 1, $generalListCertificateTitles[8]); $objPHPExcel->getActiveSheet()->getStyle($start)->applyFromArray(getPropertiesHeaderText()); $i = populateTableCellsWithoutSubtitle($objPHPExcel, $i + 2, "SSID", $Redes_Visibles, 0, PHPExcel_Cell::stringFromColumnIndex($x), PHPExcel_Cell::stringFromColumnIndex($x + 1)); } } } } // $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $z, $c, true)->getStyle()->applyFromArray($styleArray); // $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true); // $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true); // $objPHPExcel->getActiveSheet()->getColumnDimension(0)->setAutoSize(true); $contadorExtensor++; } // foreach certificado //END generateAndCloseExcel($objPHPExcel); } } catch (Exception $e) {
$positionColumn = $positionColumn - 1; $positionColumn = PHPExcel_Cell::stringFromColumnIndex($positionColumn); $objPHPExcel->setActiveSheetIndex(0)->setCellValue($positionColumn . $rowTitle, $generalListCertificateTitles[$language][7]); $positionColumn = PHPExcel_Cell::columnIndexFromString($positionColumn); $positionColumn = $positionColumn; $positionColumn = PHPExcel_Cell::stringFromColumnIndex($positionColumn); $positionColumn = generateCertificateGeneralData($objPHPExcel, $positionColumn, $rowTitle, $Prueba_ST, $generalListCertificateModalTable6Title); // redes visibles $positionColumn = PHPExcel_Cell::columnIndexFromString($positionColumn); $positionColumn = $positionColumn - 1; $positionColumn = PHPExcel_Cell::stringFromColumnIndex($positionColumn); $objPHPExcel->setActiveSheetIndex(0)->setCellValue($positionColumn . $rowTitle, $generalListCertificateTitles[$language][8]); $positionColumn = PHPExcel_Cell::columnIndexFromString($positionColumn); $positionColumn = $positionColumn; $positionColumn = PHPExcel_Cell::stringFromColumnIndex($positionColumn); $positionColumn = populateTableCellsWithoutSubtitle($objPHPExcel, $positionColumn, $rowTitle, $Redes_Visibles, "SSID"); } //foreach } //if } //foreach } //if } //foreach generateAndCloseExcel($objPHPExcel); } //if } catch (Exception $e) { echo $e;