How to copy value from web site in to excel

Help
1

how to copy value from web site in to excel

2

please kindly any one help

3

Hello, Amila :slight_smile:

1.Use Data Scraping from Design Panel. It will ask you to indicate minimum 2 similar fields to create a pattern and it will store the data into a DataTable variable.

2.Use Write CSV activity. In the first field, you can type the name of the file, with .csv extenstion and it will be saved in the process’s location. In the second field introduce the DataTable variable

Have a great night!

4

i need to click add and go to the contact tab and save the relevant contact

image
image758×430 7.06 KB

can’t tag the pattern please kindly help

5

@Amila_Darshana If you want to scrap only contact number means than you can use get text activity

6

how to get in to excel that value please advise

7

@Amila_Darshana Use build data table assume (dt) variable now create column name and use add data row activity and in array row property pass get text variable and pass dt than finally use write range and pass dt

8

From the following steps You can easily import a table of data from a web page into Excel, and regularly update the table with live data.

  1. Open a worksheet in Excel.
  2. From the Data menu select either Import External Data or Get External Data.
  3. Select New Web Query.
  4. In Excel XP:
    Enter the URL of the web page from which you want to import the data and click Go…
    Choose the table of data you wish to import, then click the Import button.
  5. In Excel 2000:
    Fill in this dialogue with the URL of the web page, the table of data you want and the
    formatting you want to keep.
  6. Choose how often you want to refresh the data. From the Data menu select Import External Data again, then choose Data Range Properties.

For more details you can refer Windmill. Co. Uk

9

could you please come though the team viwer and help me please