How to find cell position using cell address

[sruthesanju (Sweety)]

How to find the cell address position
For example: cell A - position 1
Cell D-position 4

[pravin_calvin (pravin kumar)]

Hi @sruthesanju

Use LookUp range activity to find the cell address !

Please refer to the thread below.

How to get the cell address of a specific value in datatable

Hi Team, Can some help me in the below query- How to get the cell address of a specific value in a datatable Example - value = “Accounts” cell address =B9 Thanks

Regards

[sruthesanju (Sweety)]

Not value I need to identify the position of the column
Column A -podition one
Column B-position two

[ppr (Peter Preuss)]

maybe you are looking for this:

On datatable base we can doit by following:
dtData.Columns.Cast(Of DataColumn).ToList.FindIndex(Function (x) x.ColumnName.toUpper.Equals(“YourColName”))

[Yoichi]

Hi,

The following expression returns column index from column letter.

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex("D")

The above returns 4 (like R1C1 style)

Hope this helps you.

Regards,