I HAVE TO SCRAP THIS SINGLE ELEMENT **AKOLA** FROM THE SITE, & want this in ExcelFile how could it be......?

Hey @Jay_manapure

Have you tried using get text activity to get the text of this element?

yes @Lahiru.Fernando
but Get text output is in generic value
how could be convert into DataTable

Based on your title, you seems to need to extract the element AKOLA. It’s a string. Is it something different that you are referring to here?

its string

Im trying it to convert into datatable

If you have taken out that as a string we can still assign it to a datatable then that datatable to a excel file
—so first create a datatable with build datatable activity with column structure we want and get the output with a variable of type datatable named dt
—now once after getting the text we want with a string variable use a ADD DATA ROW ACTIVITY and in the property panel mention this string variable as a value to the property ArrayRow like this
{str_variable} and in the datatable property mention as dt which will add this string variable and it’s value to the datatable as a row value to the first column
Here I have mentioned as {str_variable} taking like we have only one column the datatable dt
If we have more than one value the the ArrayRow property be like this
{value1,value2,value3,…,valuen} with respect to number of columns we have in our datatable

Kindly try this and let know for any queries or clarification
Cheers @Jay_manapure

1 Like