PHPOffice/PhpSpreadsheet get cell column index as integer

Question

How can I get cell column index as integer? I have searched the documentation but I didn't found anything.

score 18 · Accepted Answer · edited Jul 16 '21 at 20:31

18

$ColumnIndex = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::columnIndexFromString($Column);

edited Jul 16 '21 at 20:31

Abdul Rehman

answered Feb 07 '19 at 06:21

saeed yadgari

score 2 · Answer 2 · answered Apr 19 '18 at 13:16

2

If you have a cell then you can use the public functions - getColumn(), getRow(), getCoordinate()

Go read the source in Github

answered Apr 19 '18 at 13:16

jhoskins98

This is a first step, which I think OP had found. But getColumn and getCoordinate return strings. OP asked for integer values :) – Pierre-Olivier Vares May 02 '21 at 19:41
Once you got the column string coordinate, use `Coordinate::columnIndexFromString($column)` to get the column index [1-n] – Nore Apr 02 '23 at 17:00

2 Answers2