Вывод данных соглано таблицы Excel - Общие вопросы веб разработки

<?php
require_once 'Classes/PHPExcel.php';
$excel = PHPExcel_IOFactory::load('testSmeta.xlsx');
 //Получение массива с прочитанного с Excel файла
        $sheetColumns = $exce->setActiveSheetIndexByName('Лист1')->toArray();

//перебираем полученый масив
foreach($sheetColumns as $key = $val){
.... 
} 

//В $filter выведет массив с элементами массива $sheetColumns значения которого равны $val1 или $val2
$filter = array_filter($sheetColumns, function ($el) use ($val1,$val2) {return  $el == $val1 ||  $el == $val2;});

$sheetColumns = [
1=>'Первое значение',
2='второе значение',
3=>'Третье значение'
];
$val1 = 'Первое значение';
$val2 = 'Третье значение';

$filter = array_filter($sheetColumns, function ($el) use ($val1,$val2) {return  $el == $val1 ||  $el == $val2;});

$foundInCells = array();
$searchValue = '2000'; // поиск
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
    $ws = $worksheet->getTitle();
    foreach ($worksheet->getRowIterator() as $row) {
        $cellIterator = $row->getCellIterator();
        $cellIterator->setIterateOnlyExistingCells(true);
        foreach ($cellIterator as $cell) {
            if ($cell->getValue() == $searchValue) {
                $foundInCells[] = $ws . '!' . $cell->getCoordinate();
            }
        }
    }
}
var_dump($foundInCells);

$value2 = $objPHPExcel->getActiveSheet()->getCellByColumnAndRow(2, 2+1)->getValue();

$x = 'D';
$y = 11;
$value = $sheet->getCell( $x . $y )->getValue();

$column = 'A';
$lastRow = $worksheet->getHighestRow();
for ($row = 1; $row <= $lastRow; $row++) {
    $cell = $worksheet->getCell($column.$row);
}

$row = 1;
$lastColumn = $worksheet->getHighestColumn();
$lastColumn++;
for ($column = 'A'; $column != $lastColumn; $column++) {
    $cell = $worksheet->getCell($column.$row);
}

$cols = array();
$row = 1;
$lastColumn = $worksheet->getHighestColumn();
$lastColumn++;
for ($column = 'A'; $column != $lastColumn; $column++) {
    $val = $worksheet->getCell($column.$row)->getValue();
    $cols[$val] = $column;
}

$rows = array();
$column = 'A';
$lastRow = $worksheet->getHighestRow();
for ($row = 1; $row <= $lastRow; $row++) {
    $val = $worksheet->getCell($column.$row)->getValue();
    $rows[$val] = $row;
}

$value = $sheet->getCell($cols[$x] . $rows[$y])->getValue();

require_once 'Classes/PHPExcel.php';
$objPHPExcel = PHPExcel_IOFactory::load("costing-example.xls");
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet)
    {
        //Имя таблицы
        $Title = $worksheet->getTitle();

        //Последняя используемая строка
        $lastRow = $worksheet->getHighestRow();
        //Последний используемый столбец
        $lastColumn = $worksheet->getHighestColumn();
        //Последний используемый индекс столбца
        $lastColumnIndex = PHPExcel_Cell::columnIndexFromString($lastColumn);

        echo $Title.'<table border="1" cellspacing="0"><tr>';
        for ($row = 1; $row <= $lastRow; ++$row)
        {
            echo '<tr>';
            for ($col = 0; $col < $lastColumnIndex; ++ $col)
            {
                $val = $worksheet->getCellByColumnAndRow($col, $row)->getValue();
                echo '<td>'.$val.'&nbsp;</td>';
            };
            echo '</tr>';
        };
        echo '</table>';
    };

$foundInCells = array();
$searchValue1 = '2000';
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
    $ws = $worksheet->getTitle();
    foreach ($worksheet->getRowIterator() as $row) {
        $cellIterator = $row->getCellIterator();
        $cellIterator->setIterateOnlyExistingCells(true);
        foreach ($cellIterator as $cell) {
            if ($cell->getValue() == $searchValue1) {
//                $foundInCells[] = $ws . '!' . $cell->getCoordinate();
                $foundInCells1[] = $cell->getCoordinate();
            }
        }
    }
}

$foundInCells = array();
$searchValue2 = '2000';
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
    $ws = $worksheet->getTitle();
    foreach ($worksheet->getRowIterator() as $row) {
        $cellIterator = $row->getCellIterator();
        $cellIterator->setIterateOnlyExistingCells(true);
        foreach ($cellIterator as $cell) {
            if ($cell->getValue() == $searchValue2) {
//                $foundInCells[] = $ws . '!' . $cell->getCoordinate();
                $foundInCells2[] = $cell->getCoordinate();
            }
        }
    }
}

$str = $foundInCells1[0];
//$result1 = preg_replace("/[^,.0-9]/", '', $str);
$result1 = preg_replace("/[^a-z]/i", "", $str);
echo $result1;

$str = $foundInCells2[1];
$result2 = preg_replace("/[^,.0-9]/", '', $str);
//$result2 = preg_replace("/[^a-z]/i", "", $str);
echo $result2;

//Вывод двумя разными способами
$value2 = $objPHPExcel->getActiveSheet()->getCell($result1 . $result2)->getValue();
$value3 = $sheet->getCell( $result1 . $result2 )->getValue();

$cells = array();
$lastColumn = $worksheet->getHighestColumn();
$lastColumn++;
$lastRow = $worksheet->getHighestRow();
for ($column = 'A'; $column != $lastColumn; $column++) {
    $firstRow = $worksheet->getCell($column.'1')->getValue();
    $cells[$firstRow] = array();
    for ($row = 1; $row <= $lastRow; $row++) {
        $firstCol = $worksheet->getCell('A'.$row)->getValue();
        $cells[$firstRow][$firstCol] = $worksheet->getCell($column.$row)->getValue();
    }
}

$x = 2000;
$y = 2650;

if(isset($cells[$x]) && isset($cells[$x][$y])) $value = $cells[$x][$y];
else echo 'Значение не найдено';

$colValues = array_keys($cells);

$rowValues = array_keys($cells[$colValues[0]]);

$cols = array();
$row = 1;
$lastColumn = $worksheet->getHighestColumn();
$lastColumn++;
for ($column = 'A'; $column != $lastColumn; $column++) {
    $val = $worksheet->getCell($column.$row)->getValue();
    $cols[$val] = $column;
}

$rows = array();
$column = 'A';
$lastRow = $worksheet->getHighestRow();
for ($row = 1; $row <= $lastRow; $row++) {
    $val = $worksheet->getCell($column.$row)->getValue();
    $rows[$val] = $row;
}

$value = $sheet->getCell($cols[$x] . $rows[$y])->getValue();

$value = $sheet->getCell($cols[$x] . $rows[$y])->getValue();

$val1 = array_keys($cols)[0];
$val2 = array_keys($rows)[0];

$options = array();
foreach($rows as $row) $options[] = JHTML::_('select.option', $row);
echo JHTML::_('select.genericlist', $options, $name = 'row');

$options = array();
foreach($cols as $col) $options[] = JHTML::_('select.option', $col);
echo JHTML::_('select.genericlist', $options, $name = 'col');

<select name="row">
    <? foreach($rows as $row): ?>
    <option><?= $row; ?></option>
    <? endforeach; ?>
</select>

$options = array();
foreach($rows as $row) $options[] = JHTML::_('select.option', $row);
echo JHTML::_('select.genericlist', $options, $name = 'row');

$options = array();
foreach($cols as $col) $options[] = JHTML::_('select.option', $col);
echo JHTML::_('select.genericlist', $options, $name = 'col');

<select name="row">
    <? foreach($rows as $row): ?>
    <option><?= $row; ?></option>
    <? endforeach; ?>
</select>

<select name="row">
    <? foreach($rows as $row): ?>
    <option><?= $row; ?></option>
    <? endforeach; ?>
</select>

<select name="row">
    <option value="0"></option>
    <? foreach($rows as $key => $row): ?>
    <option value="<?= $key; ?>"><?= $key; ?></option>
    <? endforeach; ?>
</select>

<select name="col">
    <? foreach($cols as $key => $col): ?>
    <option value="0"></option>
    <option value="<?= $key; ?>"><?= $key; ?></option>
    <? endforeach; ?>
</select>