UiPath Data Scraping (Web Page to Excel) - Tutorial

UiPath Data Scraping (Web Page to Excel) - Tutorial

Anders Jensen

4 года назад

58,030 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

Nagaraja M H M
Nagaraja M H M - 08.08.2022 16:47

Hi Andres, This was very helpful. I need your help with a step further to this, How can we update each page's details into multiple sheets (say page 1, page 2, page 3, etc) in excel instead of scarping all page data into a single sheet?

Ответить
Minal Saini
Minal Saini - 08.07.2022 09:13

Hi Anders, I'm using UIpath version 2022.4.3 and I'm not able to find the Data Scraping feature in Debug section. Could you please help me to navigate it

Ответить
Adriel Pasamonte
Adriel Pasamonte - 04.02.2022 12:03

Good day, How I can able to cancel verifying other emails in singing up in UI Path sir? I tried other email address but I can't cancel it anymore. Thank you.

Ответить
Priyanshu Mishra
Priyanshu Mishra - 29.01.2022 09:48

data Scraping option not available in my ui path ?? What do i do???

Ответить
Shun Hsiang Chang
Shun Hsiang Chang - 22.01.2022 11:39

Thanks for sharing this tutorial and it is impressive for me about the function of UiPath. But I can't find "Data Scraping" button on my UiPath Studio. Could it be a different version issue?

Ответить
Somnath Banerjee
Somnath Banerjee - 14.01.2022 15:35

I found this useful but I would be grateful if you can help me with one use case.
Step 1: Open browser and loop through given rows of a column in excel sheet
Step 2: scrape the data(for example name and mail id)
Step 3: Write to a different sheet or the same but I want the corresponding (existing)records against the scrapped columns. Suppose I have product category mentioned in the excel sheet, and I scrapped multiple product subcategories and cost values against a single category.
Could you please help me with this...???

Ответить
Steve E
Steve E - 13.01.2022 15:14

I have a weird problem where what is scraped by the wizard, does not tie up to the actual aaname (there's a few extra spaces). Consequently when I try to dynamically click through each on one, it does not click as it's not a 100% match. I've looked at using Fuzzy data but would prefer to get to the bottom as to how i can overcome this.
I did remove all spaces from the variable and all spaces from items in the datatable, but when running, it was still trying to find the actual aa name which has the extra spaces at the end.

Ответить
CallMeBob
CallMeBob - 26.08.2021 18:04

I really think you can say Pain in the ASS of in the But.

Ответить
Mohammad Hafriz
Mohammad Hafriz - 02.07.2021 17:40

Thank you so much. Have a good day

Ответить
mohammedh fayaz
mohammedh fayaz - 15.06.2021 12:04

Hey bro! Instead of going to the next page I want to select by the page number like 12345678...etc
Because the site which I'm using for data scraping is having that kind of feature only...there is no next button...so in this case how can I do the data scraping bro ?

Ответить
Selva Mani
Selva Mani - 13.06.2021 18:39

Thanks a lot. It helps. Keep doing great work 👍

Ответить
Qandeel Maqsood
Qandeel Maqsood - 22.05.2021 13:17

Hi, Your video is really amazing but i am facing an issue. i am creating a bot just like you have explained above but the difference is i need to take reviews against every new order placed in an excel sheet. My process which i have developed after learning from u througjh this video is just giving results agains one single order. it does not give any data when bot puts new order and go to new order's relevant page. Note: the format of all the reviews against different orders is same. Please help me its urgent

Ответить
Анастасия Кузьмина
Анастасия Кузьмина - 19.05.2021 10:24

Thanks a lot Anders!

Ответить
rutuja jagtap
rutuja jagtap - 14.05.2021 18:33

hi!!
i was wanting to add loop of search and add data to exact same workbook how can i do that

Ответить
Kunal Thakor
Kunal Thakor - 26.03.2021 22:11

How can we extract data from only specified number of pages? For example we have results spanning across 50 pages but we only want to scrap the data from 9th to 20th page.

Ответить
Kenneth Law
Kenneth Law - 21.03.2021 19:24

How can i get the text values If I have a column of icon in the whole table that only shows when i mouse over it?

Ответить
Richard Lazaro
Richard Lazaro - 21.03.2021 10:53

Hey Anders, Good day to you, This is Richard, i am continuously watching your session, just need you expertise for some project that we need to provide with Event Viewer. Step1 Type in the Event Viewer on the search tab, press enter Step 2: Double click Windows logs and click Application. Step 3 is the critical part that i cannot figure out. Client wants me to only get the "Error" without using the Filter logs. they want me to get the data for all Error for "Date and time", "Source" , "Event ID" and the message in "General" automatically save it to Excel file. what function in UI path do i need to use? filtering the log for error will have more or less 2899 datas that need to be extracted.can i use web scrapping with while loop and event exists. to repeat the action of each error and continue to paste it and save to excel the description of the error.
Appreciate your help.

Ответить
LYS
LYS - 13.03.2021 15:54

thanks for the tutorial, but the loop i created not able to go next page, it went to 2nd page then back to 1st page again, and its keep looping within pages1 and 2. My data have total 47 pages, your advise please.

Ответить
suwetha sengutti 4916
suwetha sengutti 4916 - 04.03.2021 12:20

Great Video Anders! Can you help me to write both results in same sheet
like One below one

Ответить