How to copy the data from web page to Excel

Hi,

I have an data in web pages like below highlighted. I wanted to copy & paste in excel sheet.
Can someone help to understand that what activity needs to use pl?

Capture

Hi @Pandiyan_D,

You can use SendHotKey Activity like Ctrl+C as below.

image

Regards
Balamurugan.S

Hi @balupad14,

then how to paste the data’s to excel?

Hi @Pandiyan_D,

Please follow these steps.

  1. Use the Get From Clipboard activity to store the value into a variable.
  2. Use the Write Cell. Can able to write it where ever you desire.

Regards
Balamurugan.S

1 Like

Thanks Balamurugan.

Hi Bala,

I have one more query. I have written For each row activity to do the same activity for the data’s mentioned in excel sheet. But process is running for the 1st row only and the same one repeating and not going to next row.
I have attached the excel sheet & XAML file. Pl check and support me to correct the same. Thanks in advance.RFS.xaml (100.5 KB)
Bailment RFS.xlsx (38.0 KB)

Hi @Pandiyan_D,

After I analysed your xmal. It has small change .

image

In the above you have fixed the row value as 0.So always it takes the value from the first row of the datatable.

Here I have changed that I attached it .

Reards
Balamurugan.S

3 Likes

Hi Bala,

Apart from Get From Clipboard & Write cell, Is there any other way to copy the data from web page and paste it to excel sheet (inside for each activity) ?

Yes. You can . You have options. You can use the Get Attribute activity by assigning the target like element or selector.

Regards
Balamurugan.S

Hi Bala,
Could you please share some samples?

Hi @Pandiyan_D,

I have done some data scrapping for a user. You can get it here.

Regards
Balamurugan.S