Web formunu excel verileriyle doldurun ve excel'e aktarın


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?

Sorry but i couldn’t get it to work.

What is the problem?

1 Like

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.

Sorry, I added a wrong Main.xaml. I’m sending an attachment again

1 Like

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)

1 Like

First of all thank you for your help.
There are missing activities in the project you submitted. What activities did you use here?

Please check with version. image

1 Like

The version of my packages is low and appears to be the latest version, it is not updated.HATA2

Main.xaml (28.7 KB)

1 Like

after running it i get the error in the screenshot.

Please check this flow.Main.xaml (28.6 KB)

1 Like

It gives an error as in the project screen.

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. :slight_smile:

1 Like

I have set the selectors, but it does not switch to the next pages when querying. It only takes the first page data.

You can use row count value in page.
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.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.