How to get Column Range from Excel

datatable
excel
uiautomation
activities
studio

#1

Hello to all,

I have a problem that I can not solve.

In practice I would like to get the range of a column starting from another specific column.

Example: I tell the robot to read column “B” (or “Age”) and I would like to get the range of the “Name” column (which in this case is “D”)

Someone could help me with my problem, kindly.

thanks to the whole community,
fahad


#2

@momi_fede

  1. Use read range to read from Column B
  2. Check the Length of the data
  3. Set range to column D as D1:D(length of column B)

Hope this helps!


#3

Thank you so much for the answer @Madhavi

… but I know you misunderstood my request.

what I would like to get as a result is the letter in which the “Name” column is located:
in my case it is in column D … but I do not know in what column is “Name”, so I would like to find the index “D” as a result when I ask the robot to look for the column in it is the word “First name”


#4

Hi @momi_fede

I think this might be useful for you.