How to fetch data from excel sheet based on the header name

excel
activities
studio

#1

Hi
I have an excel sheet with which I wish to fetch only that data which is under a particular header. In my sheet, the name of the header is “Product Code”. Under this header, i would like to fetch all the codes. Can anyone please tell how to do it.

code.xlsx (8.6 KB)
Main.xaml (8.5 KB)


#2

@samya, Refer this, Capture the cell data from each row using Ui path

Regards,
Dominic :slight_smile:


#3

Thanks will do that