I am extracting data from web page and i want write into the Excel

Help Activities
,
1

Here I am extracting data from web page and i want write into the Excel .But i am unable to write it.Could someone help me with this.

IMG20230607095213
IMG202306070952131920×2560 742 KB

2

@Pushpendra_kowthavarapu

If you want to write all the data at once…then first use a build datatable add the columns you need to create a structure

And then use add data row with array row as {str_market,str_varible1,so on..} and datatable as the datatable used in build datatable output field

Then use write ramge activity and provide the datatable

Cheers

3

Hi @Pushpendra_kowthavarapu ,
Kindly find the following steps,

Step1: Create the new datatable by using Built data table activity(Output is Datatable datatype)
Step2: Use add data row activity to store the data which is getting from the website, To store the data like {StrData1,StrData2,StrData3}
Step 3: Finally use write range activity to write your data into the Excel file.

Regards,
KarthickKumaran

4

Extract a table directly using scraping from the application and write using write range activity

5

Hi @karthickrkumaran,

Trying to do the same thing . But can’t get the expected output. Could you please tell me what is wrong in the below code

IMG20230619155136
IMG202306191551361920×2560 632 KB

Blockquote

6

Hi @Pushpendra_kowthavarapu,
What is your expected output?
Kindly find the workflow File.
Get_Text_Forum.xaml (18.2 KB)
Test.xlsx (6.1 KB)