simplexls
simplexls copied to clipboard
How can I find the cell?
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; }
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