How to find cell position using cell address

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

1 Like

Hi @sruthesanju

Use LookUp range activity to find the cell address !

Please refer to the thread below.

Regards

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

maybe you are looking for this:
grafik

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

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,

2 Likes