Data scraping a section in web page

[XYZ_1991]

Hi

I have a web page and I need to get the Datab table out from page . I applied Data scrapping extracted table and pasted tat in word using word activities . Now, When I am executing the code it is not fetching the data table elements reason the Data table exists at a section which is present at bottom section of web page how does the BOT knows which section to scrap while executing ?

Please advice

[Sasi.lalo (Sasikumar)]

Hi @XYZ_1991,

Try using SetFocus activity, passing the Datatable selector.

Set Focus

Regards,
Sasikumar K

[XYZ_1991]

Ok, It worked but I am not sure why it worked now ? Can you explain as what difference it created using Set Focus activity ?

NOTE : When I was not using Set Focus activity and made output Data table and displayed on screen the string value of table was displayed then why it was not inserting into WEB the Data table ?
ii) I also removed the open browser activity and simply entered the Insert Data table in Word application scope not sure it that created the entire difference

So want to understand where was the miss

[Sasi.lalo (Sasikumar)]

Hi @XYZ_1991,

The DataScrap element should be visible to extract the datatable, since I faced the same issue I used this Set Focus and worked for me.

Regards,
Sasikumar K

[XYZ_1991]

Hi

I have one more doubt for this data table , now the data table namedExtract data is inserted in Word document and It contains user names and a number in front of user name this has been extracted from web page which has hyperlinks to each user name .

Now , If there are 5 rows in Data table that means it has 5 user names and I want to click each user name on web page and fetch next details .

SO i tried using Click Text activity but what should be input text . I want the column value to be the text .

So it searches the text value from column 2 of Data table and clicks the same user over web page .

Please advice.

ExtractData.Columns. " How should the expression look"?

[Sasi.lalo (Sasikumar)]

Hi @XYZ_1991

You need to loop through the Datatable to get the column text.

Please check the below link:

How to perform string operations on a selected rowItem using foreach Loop datatable

Hi, I am doing MS excel file related activity… which is doing simple read the xl → save it in a Datatable → Iterate through all rows and → write the rowitem. [image] [image] This While iterating rowitem using get row item activity, it is throwing exception of Null reference… Hence I can not perform any operation eg. convert to string, convert to int, split, substrings etc

Regards,
Sasikumar K