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