function generateAndCloseExcel($objPHPExcel)
{
$objPHPExcel->setActiveSheetIndex(0);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$data = array('status' => true, 'code' => 200, 'url' => saveExcelToLocalFile($objWriter));
echo json_encode($data);
exit;
}
default:
$generalListCertificateMessageNotExtender = "Currently no extender is specified for this certificate.";
break;
}
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('F' . ($i + 3), $generalListCertificateMessageNotExtender);
}
/* END-ESPECIFICACIONES EXTENSORES INSTALADOS */
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setAutoSize(true);
//excelCreateNewSheet($objPHPExcel,"hola");
//$objPHPExcel->setActiveSheetIndex(1)->setCellValue('A1', ($i-3));
//$objPHPExcel->setActiveSheetIndex(0);
//$objPHPExcel->getActiveSheet()->setTitle('Results');
// ->setCellValue('B2', $headerTableColumn2);
//$objPHPExcel->getActiveSheet()->getStyle('A2:B2')->applyFromArray(getPropertiesHeaderText());
$data = $General;
$generalListCertificateModalTable1Title;
/*
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("A".$i.":G".$i);
$objPHPExcel->getActiveSheet()->getStyle("A".$i)->applyFromArray(getPropertiesHeaderText());
$objPHPExcel->getActiveSheet()->getStyle("A".$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
*/
$objPHPExcel->setActiveSheetIndex(0);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$response = array('success' => true, 'url' => saveExcelToLocalFile($objWriter));
echo json_encode($response);
exit;
