Data scraping from website that data changes with time into an excel sheet

Help Activities
, ,
1

Hello everyone,
I want to use ui path scraping data activity to extract data from a website and fill an excel sheet
the web table keeps getting new data and some data might disappear at a time.
I want to update the excel with new data continuesly without deleting the disappearing data from the website.

Here is what I’ve built:
Open web browser
Data scraping (Create variable ExtractdataTable)
Write range activity from website in excel
Read Excel (Create variable ExtractdataTable)
If:
ExtractDataTable.AsEnumerable().Any(Function(y) String.Join(“”, y.ItemArray) = String.Join(“”, currentRow.ItemArray) AndAlso currentRow.Table Is ExcelDataTable)
True: Do nothing
Else: Add Data Row
currentRow.ItemArray in ExclDataTable

Can you please advise what o have done wrong and if there is any other way to do this?

Thanks!

2

if data changes time to time then you can put asterisk (*) in the selectors “aaname” please try on your side

3

Hi @Salma_Merhebi

After extracting the data from a page copy the entire data from strict selector and then paste that data into the fuzzy selector so that when ever a new data is visible on the page then that data will be extracted and always the excel is updated with the new data and also don’t forget to change the targeting method from strict to fuzzy as highlighted below.

image
image1327×671 73 KB

Regards

4

Hi @vrdabberu
Thanks for your reply
Appreciate it!
Can you explain the steps in more details please?

Thanks

5

Thanks @prashant.v
Can you explain more please?

Thanks

6

Hi @Salma_Merhebi

Remove the data from Strict Selector and Paste that data to Fuzzy selector in the Targets section. Change the Targeting Methods from Strict Selector to Fuzzy Selector.

Regards

7

Hi @Salma_Merhebi

Copy the data from strict to fuzzy as shown below.

image
image1323×643 85.2 KB

In the targeting methods shown below click the dropdown and then uncheck the strict selector and check the fuzzy selector as shown below.

image
image1241×560 122 KB

Regards

8

I’ve done that
Do you mean the only activities I need are:
Open web browser
Data scraping with fuzzy selector property

Automatically any new data will be added to the excel sheet?

Thanks!

9

Hi @Salma_Merhebi

Okay I will give the workflow but you need to change the above mentioned changes in the extract data table activity

Regards

10

Thank you so much!
Appreciate it :slight_smile:

11

Hi @Salma_Merhebi

do you want to update the excel with new data by adding to the old data or else do you want to replace the entire data in an excel?

Regards

12

Just add new datat without deleting existing one.
Thanks!

1 Like
13

Hi @Salma_Merhebi

Try using the below workflow if you wanted to replace the new data with the old data in the same excel or else to write the new data to a new excel.

image
image880×820 40.2 KB

Try using the below workflow if you want to add the new data to the old data in the same excel.

image
image880×759 39.5 KB

Try the above steps but don’t forgot to change the above mentioned changes for the extract data table

Regards

14

After selecting the target point from where you want to extract data, you can open that selector and make changes in selector like passing asterisk or variable

And for append the content you can use “append range workbook” Activity

15

Thanks a lot.
I’ve tried it but it is not working :confused: