Findchild to Excel

Help
1

Hello
Can any one help me , how to enter the values from findchild to excel.

I am having a web site

From this website i did the data scraping . and i am able to get all the distributor names above the table(there is only one value). I have marked it in square box in the below screenshot
image

Now you can see there are tables. I have extracted these tables using the - Find child activity.

But how to put all the values from the Find child activity in to the Excel file?

Can one please help me with this.

Thank you
Seema

2

@SeemaAA,

as you said that you did data scraping, so data scraping generates a datatable and you can write a datatable to excel by taking write rang activity.

Cheers,
Pankaj

3

@SeemaAA If you are getting data through findchildren activity

Follow these steps :
-1. Use FindChildren Activity [ output as UiElement]
0. Add Build DataTable

  1. Take ForEach Loop and pass the UiElement.
  2. Inside body add Add Data Row {Pass the data into row}
  3. By using write range print the data into excel.
1 Like
4

hi @SeemaAA if you really want to use the findchild activity, simply use a foreach loop for the childs and get the value and write back to excel .

2 Likes
5

@Pankaj.Patil
yes i have done it only for the scraped data, i.e for the fields i have highlighted in square box in screen shot.

But when it comes to table i want to extract all the tables and put it to the excel. Which dint happen , so i have taken the - find child activity.

image
image954Ă—432 26.9 KB

6

@Rashmi
I followed the steps you have mentioned.
But still not able to put it to the Excel.
Please find the below screenshots of the work i did.

image
image758Ă—421 24.6 KB

image

image

7

@SeemaAA Before add data row use “Get Attribute” and get the value as output

then pass that output variable into add data row.

And i am not getting why you have used the extract data table inside ForEach.

1 Like
8

Hi @Rashmi

add - Getattribute. Took the output to the result - its a string variable.

I am attaching here the .xaml.

Can you please help me where is it going wrong. Please

Main.xaml (28.1 KB)

image
image891Ă—467 27.9 KB

now the result- which is the output from getattribute i am passing it to the Add data row
image
image875Ă—260 20.4 KB

I really dont understand why its not working…
Can you please help me.

Seema

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.