I have 350,000 lines of excel data. I will query each data on the website Bilgi Bankası and click on all the results in order to transfer them to Excel. I will repeat all of them in 350.000 lines and transfer the results to excel. Can you help me?
I opened the website from Google Chrome. I performed the search. I updated the excel file path in the Excel Application Scope activity. But in the assign activity, ‘Assign: Exception has been thrown by the target of an invocation.’ warning.
I built a happy path process. As far as I can see, there are 15 rows on some pages and 16 rows on some pages. You can start process after search “İSTANBUL TİCARET” on Chrome. You can develop by building two different tables.Main.xaml (29.1 KB)
You can examine the dynamic selectors used in the process and develop your own algorithm. the critical point here is selectors. I’m sorry I haven’t had much time to develop.
You can use row count value in page.
ex:
60/15(Row count per page)=4 page
than use for loop (i=1;i++;i<=4).
click next page at the end of each for cycle.