//$sheetname = 'Data Sheet #2';
//$objReader->setLoadSheetsOnly($sheetname);
$objReader->setReadFilter(new MyReadFilter());
$objPHPExcel = $objReader->load($inputFileName);
$objWorksheet = $objPHPExcel->setActiveSheetIndex(0);
$highestRow = $objWorksheet->getHighestRow();
$highestColumn = $objWorksheet->getHighestColumn();
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
//******************************************
//OBTENER COLUMNAS *************************
//******************************************
$columnas = array();
for ($col = 0; $col < $highestColumnIndex; ++$col) {
$value = $objWorksheet->getCellByColumnAndRow($col, 1)->getValue();
if ($value) {
$columnas[$col] = $value;
}
}
$objSubidaCasos = new SubidaCasos();
$resultadoColumnas = array();
foreach ($columnas as $key => $columna) {
$add_columna = $objSubidaCasos->add_columnaBase($columna);
$add_columna2 = $objSubidaCasos->add_columnaCasoRepetido($columna);
$resultadoColumnas[$key]['columna'] = $columna;
if ($add_columna) {
$resultadoColumnas[$key]['resultado'] = 'agregada';
} else {
$resultadoColumnas[$key]['resultado'] = 'NO AGREGADA';
}
}
echo json_encode($resultadoColumnas);
$objPHPExcel = $objReader->load($inputFileName);
$objWorksheet = $objPHPExcel->setActiveSheetIndex(0);
$highestRow = $objWorksheet->getHighestRow();
$highestColumn = $objWorksheet->getHighestColumn();
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
//******************************************
//OBTENER COLUMNAS *************************
//******************************************
$columnas = array();
for ($col = 0; $col < $highestColumnIndex; ++$col) {
$value = $objWorksheet->getCellByColumnAndRow($col, 1)->getValue();
if ($value) {
$columnas[$col] = $value;
}
}
$objSubidaCasos = new SubidaCasos();
array_unshift($columnas, "telefono");
foreach ($columnas as $columna) {
$columnasString = $columnasString . " " . $columna . ",";
}
$columnasString = substr($columnasString, 0, -1);
$telefonoColumna = array_search($nombreTelefono, $columnas);
//******************************************
//LEER FILAS Y CELDAS A UN ARRAY ***********
//******************************************
$arraydata = array();
for ($row = 2; $row <= $highestRow; ++$row) {
$arraydata[$row - 1][0] = $objWorksheet->getCellByColumnAndRow($telefonoColumna - 1, $row)->getValue();
for ($col = 0; $col < $highestColumnIndex; ++$col) {
$value = $objWorksheet->getCellByColumnAndRow($col, $row)->getValue();
if (!$value && $col == count($columnas) - 1) {
