How to read row from excel file in uipath

Help
, ,
1

Capture
I want to read this colored row from excel.

2

Hi @muneeb,
You want to select the row based on the colour?

3

Hi muneeb,

Maybe you can use Get Cell Color activity in while loop. You can keep a column header value in array.

Array = {“A”,“B”,“C”}
counter1 = 0
counter2= 2
String str = Array(counter1) + counter2.ToString
While
GetCellColor(string)
END WHİLE

You can keep all Cell values in a row. And finally, you control it all of them

4

i need to extract all values from from 3 row.
i want to read values dynamically because number of column changed every time

5

This is not colored in original file. i need to extract all values from from 3 row.
i want to read values dynamically because number of column changed every time

6

This is not the colored row in original file. i need to extract all values from from 3 row.
i want to read values dynamically because number of column changed every time

7

@muneeb
Use read range activity, you’ll get all excel data in a datatable.
Then you can access the third row as follows, suppose the output of the read range activity is dt.
Then dt.row(2) will return the entire third row.

8

You always want to read 3 rd row only

9

I want row 3rd and last row