I am trying to pull certain information by searching the links in Excel in the web browser. But if there is no information I want on the page that opens, the system gives an error and stops. What can be the way to continue when there is no information on the page, can you help?
after entering the url place an check app state activity and indicate the text you wanted to extract.
If the text is appeared then give the get text activities and further steps in target appears section and if the text doen’t appears then just leave the target does not appear section as blank so that it goes to the next url and the process continues.
I have just gave the data table names as dt1 and dt2 for my reference. You can change the names as per the standards.
I have used the read range activity and gave the dt1 as the data table variable for the first read range activity so the dt1 stores the entire data present in excel and after that I have used the clear data table activity and because of that activity the data will be cleared from dt1 and then only the headers will be left for dt1 variable. So, for the for each (iteration row by row)process I need an entire data from an excel so for that reason I have used another read range activity and gave the output of that activity as the dt2.