Gettext on the Web and add to datarow

Help
, ,
1

Hi Everyone.

I have list items in excel file… I want to search them one by one on the web…each with item will got text on the web by using GetText Activity.

I’m confusing when gettext and then add them into datatable… how to make properly in Add Data Row as below picture ?

And then I want to add datatable in the next empty row of excel file from “B2”

Thanks you!

1
11920×1080 182 KB
2
21920×1080 192 KB

1 Like
2

Hi
Hope these steps would help you resolve this
—use a build datatable activity and create a similar structure of datatable and get the datatable variable as output with a variable named Finaldt
—now use a EXCEL APPLICATION SCOPE pass the file path of excel and inside the scope use a READ RANGE ACTIVITY and get the output with a variable of type datatable named dt
—and now use a for each row loop and pass the variable dt as input
—inside the loop use OPEN BROWSER activity and mention the url as string input
—inside that container watch for your text and get the output with a variable of type string named str_input using GET TEXT activity
—followed by this use a ADD DATAROW activity and mention the ArrayRow property as {str_input.ToString} and datatable property as Finaldt

This will add value to the datatable {with single column} for each value in the excel
but make sure that GET TEXT activity has wildcard along dynamic attribute values

Cheers @trunghai

1 Like
3

Hi Bro

I have excel file and want to search items in list into the web… and then get price, write into the Price Column.

Could you pls try to get text and make short xaml file?

Thanks you so much bro!
Stock.xlsx (8.0 KB)

1
11920×1080 159 KB

4

Hi Bro

I have made XAML file… but might has anything not correct.
Main.xaml (19.3 KB) Stock.xlsx (8.0 KB)

1 Like
5

Let me check once buddy
Cheers @trunghai

1 Like
6

here you go buddy
hope this would help you
had.zip (16.1 KB)

Cheers @trunghai

2 Likes
7

Thanks you bro.

But i want to use get text and then write it into “Price” column in excel file as workflow which you have suggested as above.

We can use open browser out of loop to avoid open webpage many time.

Pls support me.

Thanks you so much!

8

Thanks you Bro.

I have made XAML file and it run OK. :slight_smile:

Thanks you so much always!

1 Like
9

Cheers @trunghai

1 Like
10

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