Cell Indexing with Column Letter Row Number

3 posts, 1 answers
  1. Stephen
    Stephen avatar
    3 posts
    Member since:
    Dec 2014

    Posted 14 Apr 2015 Link to this post

    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!

     

     

     

  2. Answer
    Anna
    Admin
    Anna avatar
    99 posts

    Posted 16 Apr 2015 Link to this post

    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
     

    See What's Next in App Development. Register for TelerikNEXT.

     
  3. UI for WPF is Visual Studio 2017 Ready
  4. Stephen
    Stephen avatar
    3 posts
    Member since:
    Dec 2014

    Posted 16 Apr 2015 in reply to Anna Link to this post

    Thanks Anna!
Back to Top