弄清楚如何使用php excel获取行id列id

Question

im trying to find a way to get the rowid and columnid of an excel sheet using php, something like if($date == $row){ your $rowid = 'something}

ive seen something like

$row = $objPHPExcel->getActiveSheet()->getRowIterator($searchValue)-

>current();
$cellIterator = $row->getCellIterator();
$cellIterator->setIterateOnlyExistingCells(false);
foreach ($cellIterator as $cell) {
    echo $cell->getValue();
}

but the $searchValue refers to a row, not an actual search term, i need to find current date in the sheet , the current date is on a column named date, and if i find that date get the rowid/colid, so i can write to that row and columns, i know i will always be using 6 cols of any given row, any ideas on this ? or some pointers maybe

Answer 1

$row = $objPHPExcel->getActiveSheet()
    ->getRowIterator($searchValue)->current();
$cellIterator = $row->getCellIterator();
$cellIterator->setIterateOnlyExistingCells(false);
foreach ($cellIterator as $cell) {
    echo 'ROW: ', $cell->getRow(), PHP_EOL;
    echo 'COLUMN: ', $cell->getColumn(), PHP_EOL;
    echo 'COORDINATE: ', $cell->getCoordinate(), PHP_EOL;
    echo 'RAW VALUE: ', $cell->getValue(), PHP_EOL;
}

or look at 28iterator.php in /Examples