Copy Information from a website and past it in an excel file

Hi there,

I want to copy an information from an website and then paste it in an excel file.

Unfortunately, I dont know the steps.

Can you please help me to realize this task?

Kind regards,
Fabian

2 Likes

Hi @Fabian17

Welcome to UiPath Forum!!!

Here is the sample workflow CopyToExcel.xaml (6.7 KB)

2 Likes

Hi @Fabian17

Step 1: open the browser with ur concern URL
Step 2: Use Data Scrap or Get Text activity u can get text and store in variable.
Step 3: Write in the excel by using excel application scope or workbook.

Thanks,
Manikandan Thangaraj

1 Like

Hi @Fabian17

Welcome to UiPath Community Forum

1.First using open browser activity pass url where you want get data.
2.use data scrapping its automatically create output data table variable.
3.use write range activity pass data table variable.

Regards,
Kommi Jeevan.

4 Likes

Hi,

Thanks for your excel. This is exactly my task.

Unfortunately I am not able to adapt it to my task…

Which values do I need to chance, so that I can choose my point of interest in this website?

Kind regards,
Fabian

2 Likes

You might need to change the selectors to change the point of interest in the website…

Hi @Fabian17

I don’t know about web site the structure .

  1. But you can able to copy the information some thing like Ctrl+C using the Send Hotkey activity.
  2. Here I have attached a link that it has an activity called “PasteClipboard”. Specify the start cell in the property of CellRange. It will paste the value inside the excel sheet.

Regards
Balamurugan.S