$generalListCertificateSheetDetailCertificateWifi4Title = array("N°", "Dispositivo"); $generalListCertificateSheetDetailCertificateWifi5Title = array("Int Desc.", "Int Carr.", "Nac Desc.", "Nac Carr."); $generalListCertificateSheetDetailCertificateWifi6Title = array("N°", "Ssid"); $generalListCertificateSheetDetailCertificateWifi7Title = array("Ssid", "Segurança", "Canal", "Origem dispositivo"); break; } loadExcel(); // Create new PHPExcel object $objPHPExcel = new PHPExcel(); setDocumentProperties($objPHPExcel); populateTableHead($objPHPExcel, 0, "A2:B2", "A2", $generalListCertificateTitles[0]); populateTableHead($objPHPExcel, 0, "D2:D2", "D2", $generalListCertificateTitles[2]); $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true); populateTableHead($objPHPExcel, 0, "F2:K2", "F2", $generalListCertificateTitles[3]); //populateTableHead($objPHPExcel,"F12:J12","F12",$generalListCertificateTitles[5]); $i = populateTableCells($objPHPExcel, $generalListCertificateModalTable1Title, $generalListCertificateModalTable1Content, 0, "A", "B"); populateTableHead($objPHPExcel, 0, "A" . ($i + 1) . ":B" . ($i + 1), "A" . ($i + 1), $generalListCertificateTitles[1]); //$i=populateTableCells($objPHPExcel,$generalListCertificateModalTable2Title,$generalListCertificateModalTable2Content); //populateTableHead($objPHPExcel,"A".($i+1).":B".($i+1),"A".($i+1),$generalListCertificateTitles[2]); $objPHPExcel->getActiveSheet()->getStyle("A3:A22")->applyFromArray(getPropertiesLateralLeftText()); $objPHPExcel->getActiveSheet()->getStyle("A25:A29")->applyFromArray(getPropertiesLateralLeftText()); $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true); /* START-SPEEDTEST CPE CABLEADO */ for ($i = 25; $i < count($generalListCertificateModalTable2Title) + 25; $i++) { $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $generalListCertificateModalTable2Title[$i - 25])->setCellValue('B' . $i, $generalListCertificateModalTable2Content[$i - 25]); } /* END-SPEEDTEST CPE CABLEADO */ /* START-HABITACIONES */ for ($i = 3; $i < count($Locaciones) + 3; $i++) { $objPHPExcel->setActiveSheetIndex(0)->setCellValue('D' . $i, $Locaciones[$i - 3]);
$dispositive = "Dispositivo"; break; default: $dispositive = "Dispositive"; break; } $i = populateTableCellsWithoutSubtitle($objPHPExcel, $i + 2, $dispositive, $Sniffer, 0, PHPExcel_Cell::stringFromColumnIndex($x), PHPExcel_Cell::stringFromColumnIndex($x + 1)); // prueba speedtest $Prueba_ST = getArrayObjectPrueba_ST($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[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);