Hi! Guys hope you all doing well. let’s get in to the question. i have 2 excel files. i’ll attach\link both the files here.
link:- https://gramawardsachivalayam.ap.gov.in/GSWSDASHBOARD/#!/JagannaThoduReport
what you’ll do is just select the date from 4-7-2021 to 14-7-2021 and download the two excel files 1.R\U FLAG and 2.U from the site.
what output i actually need is file R should generate. in detailed “Total Mandals” column from both the files i need to subtract it. and i wants to print the output file as result from file1 and file 2.
example: In R\U FLAG file “Total Mandals” i can see the data as 75.
in U file “Total Mandals” i can see the value 12.
from this i need to print the output data as (75-12)=63.
like this i need to print all the data from both the files.
what i done is.
step1:- sequence created
step2:- Excel application scope
step3:- “Read range” properties output:- dt1
step4:-“Read range” properties output:- dt2
step5:- For each “row” in “dt1”
i stopped here don’t know what to do next please can you help me.
regards
