Php PHPExcel split Excel cell coordinate

Question

Currently I used PHPExcel to import an excel file, there is a function $cell->getCoordinate();

I would like to ask any solution for separating the cell coordinates of alphabet and integer ?

e.g. A1, A2,

I need to know which row and to which column.

I am studying schism, but not luck. Any idea?

Answer 1

It:

 $coord = 'AF13'; preg_match_all('~[AZ]+|\d+~', $coord, $split); print_r($split); 

Will produce:

 Array ( [0] => Array ( [0] => AF [1] => 13 ) ) 

Answer 2

 $coordinate = PHPExcel_Cell::coordinateFromString('A1'); var_dump($coordinate);