New here - using trial version - looking for a good tutorial or step by step instructions

Learn Academy Feedback
#1

I am looking for a tool that will allow me to scrape static spreadsheet formatted data from a web browser and import it to Excel.

DataExample
DataExample1301Ă—222 23.1 KB

I have attached a screenshot of the data I am looking to extract.
As I have mentioned, it is static data and has no actionable features.
Can UiPath extract data like this and import to an Excel spreadsheet?
If so, can someone please point me to a suitable help topic or tutorial?
Thanks!

#2

@rmontena

Try with Data Scraping activity and will give you output as dataTable and then use Write Range activity to write into Excel file.

#3

@rmontena

Have a look on below topic which clearly explains how to scrap the data

https://studio.uipath.com/v2018.4/docs/about-data-scraping

#4

Hi @rmontena.

Welcome to UiPath Community!

You can use the Data Scraping function of UiPath Studio.
You can find its documentation below:

Then once you scraped it already, you will be using Write Range activity inside an Excel Application Scope. See documentations below:
https://activities.uipath.com/docs/excel-application-scope
https://activities.uipath.com/docs/write-range

Hope this helps.
Thanks and regards :slight_smile:

2 Likes
#5

Hi. Thanks for the reply. I opened UiPath Studio and clicked Process under New Project. Then Data Scraping. I clicked a cell in my table and did get prompted to extract the entire table. I replied yes. and the Preview Data looks nothing like my table. I have attached a screenshot of the preview data. Not sure what I am doing wrong or missing. If I click the Edit Data Definition button, this is all I see:
"<extract-table get_columns_name="1" get_empty_columns="1" />" And, once I click Finish, I see a graphical “flow chart” but I am not sure how to proceed after that to actually get the data formatted and exported to Excel.
I am limited to attaching only one file per post, so I have attached the Data Preview.

DataScraping1
DataScraping1816Ă—700 53.3 KB

#6

Hi @rmontena

Instead of extracting the entire table right away, try pointing to specific columns instead one by one.

It might be that the format of the table is not properly recognized which results in a messy output.