simplexls icon indicating copy to clipboard operation
simplexls copied to clipboard

How can I find the cell?

Open dhlyy opened this issue 2 years ago • 1 comments

I want to just take the specific cell like $rowcount = count($excel -> rows(1)); for( $i=1; $i <= $rowcount; $i+=3){ $cell = 'C'.$i ;

echo $cell; }

dhlyy avatar Oct 08 '23 04:10 dhlyy

out values from 3 column

foreach ($xls->rows() as $r) {
  echo $r[2] . PHP_EOL;
}

and external sources, to help write func getCell( $addr )

see coordinateFromString https://github.com/PHPOffice/PHPExcel/blob/1.8/Classes/PHPExcel/Cell.php#L584 and see columnIndexFromString https://github.com/PHPOffice/PHPExcel/blob/1.8/Classes/PHPExcel/Cell.php#L790

shuchkin avatar Oct 08 '23 05:10 shuchkin