I want to read the excel file and then type all the names and area in the website and also choose from the dropdown list the District , The district is written in a yellow for all the bellow .
The question is how can I tell the bot that the yellow row is a district you have to choose from drop down list for all bellow until you find another yellow row
This is the excel file
and this is the website I have to fill the information in
If the cells of districts are merged always then when you read the excel as datatable…the data for that particular row will exists only in fiets column the second column will be wmpty…in your for loop you can identify the second row empty and change the district
Hope this helps
Cheers
Thank you so much for your quick response ,
I understood the logic you are trying to explain but I could not know how to develop it
I will be thankful if you helped me on this
This is how it looks
IsNothing(CurrentRow("Area Of Practice")) OrElse String.IsNullOrEmpty(CurrentRow("Area Of Practice").ToString.Trim)
cheers
