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
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