Regarding the data extraction from web to excel

Help Robot
,
1

Hello,
I am facing an issue to extract particular the text format data into excel multiple times.
As I need only Work code, Material list no, Vendor name, Unit price, Quantity, Amount. in the excel file.
Please go through the attached image and web link. Please revert as soon as possible.
https://nregastrep.nic.in/netnrega/citizen/wrkbilldtl.aspx?lflag=local&district_code=0214&billno=01&Bill_date=6/27/2022%2012:00:00%20AM&work=0204003012/SK/7705061090031&state_name=ANDHRA%20PRADESH&district_name=ALLURI%20SITHARAMA%20RAJU&panchayat_code=0204003012&finyear=2022-2023&source=&Digest=25nnOTp2vhdTMrZhf3pSLw

Screenshot (25)
Screenshot (25)1366×768 91.2 KB

2

Hi @Ram_Shiva_Reddy
please have a look on this workflow
Main.xaml (23.0 KB)

3

Hello Ma’am,
Actually I’m facing the issue to write all the required data in excel. How can I assign the data in excel?

4

@Ram_Shiva_Reddy Build one datatable and add those data to the datatable Then write it in Excel

image
image627×657 16.3 KB

5

Hello Ma’am,
I’m unable to extract the columns of Material list and Vendor name using Get Text activity.
It throwing an error. for Material list(0204003-ML-1075). Which type of variable should be used? Even INT32 and Generic value is not working properly. Please suggest the possible solution.
Thankyou,

6

@Ram_Shiva_Reddy
The variable should be string. By the way,what is the error?