How to fetch excel data which header color is green

Hi I am using excel scope now I need to fetch only those records which header is green as mention in attachment

Hi Greetings…!

In Read Range Activity, Give “A9” under Range property.

Thanks!

1 Like

Hi @Aditya10989
Check this thread

2 Likes

thanks for reply not work can you please tell me what A9 will do…??

It will start reading the excel file from this Cell “A9”. Hence, you will get the column names.

no my question if you saw my screenshot I have header of two color one is green and another is blue I need those record whose header color is green only

ReadRange activity can’t regonise colors. So you have to know what are the columns you need Select for the process.
Finding the column using color is not possible in Read Range.

oki…! If the green colour is fixed one, use Filter datatable activity.

Keep the columns whatever required.

Filter

Thanks!.

2 Likes

@kadiravan_kalidoss thanks

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.