Cell Indexing with Column Letter Row Number

[Stephen]

Is there a built-in way to convert from the "{ColumnLetter}{RowNumber}" notation to the CellIndex format?

Example:

"C5" becomes ColumnIndex=2, RowIndex=4

"AA2" becomes ColumnIndex=26, RowIndex=1

 

It's not the end of the world to write my own conversion, but I was just curious if this is already supported.

 

Thanks!

 

 

 

[Anna]

Hi Stephen,

Thank you for your question.

At the moment this functionality is exposed in the methods TryConvertCellNameToIndex and ConvertCellNameToIndex of the NameConverter class.

Please, do not hesitate to let us know if there is anything else we can do for you.

Regards,
Anna
Telerik

 

 

[Stephen]

Thanks Anna!