How to copy search result of a website and paste in an Excel?


#1

Hi All,

How to copy search result of a website and paste in an Excel? Here was my approach-

  1. Launch Browser-IE- A flight booking site
  2. Set Text
  3. Click on Search
  4. CopySelected text
  5. Tried to copy step 4 in an excel which is not happening.

Please suggest.

Regards,
Anto


#2

@Anto125

You have to read the excel sheet first and then store it in a datatable variable dt
then after copying the selected text you can assign to the excel sheet by using Assign activity
dt.Rows(index of row)(column_name)=copiedText

else
1.By using Build datatable activity you can build a datatable dt.
2.After that use Add DataRow activity to add the values.
3. At last you can write in excel sheet by using write Range activity.

Regards,
Mahesh


#3

Hi,

Actually I am looking to copy data from website and copy into an excel.

Regards,
Anto


#4

@Anto125
My suggestion was for the last step.
first follow first four steps and then follow the procedure that i have posted,

Regards,
Mahesh


#5

Getting an error-
Main.xaml (12.5 KB)
Attached XAML file for reference.


#6

@Anto125

Can you explain me what you want to extract .

Regards,
Mahesh


#7

@Anto125
Main.xaml (30.4 KB)
Refer this I have made some modifications, I think that will be your requirement , run the code once and check

Regards,
Mahesh


#8

Thanks a lot Mahesh. The code worked. I was not aware to use data scrapping here.

Regards,
Anto