I’m doing Active loans project from Bots DNA website, where bot has to go to website url https://botsdna.com/ActiveLoans/ and download input file and then click on loan code and download the zip file which contains columns like Account Number, Bank, Branch, Loan Taken on, Amount and Emi(month). And also bot has to get Status and Pan Number from the website along with the above columns present in zip file. Bot has to compare both and write to a separate excel file.
In this process bot is not writing the values for last two columns i.e, PAN Number and Status.
I’m sharing the code for your reference.
Can anyone please suggest me the solution for my problem.
Download_Input_File.xaml (11.7 KB)
Get Account Details From ZIP File.xaml (14.3 KB)
Get Loan Account Information.xaml (16.0 KB)
Main.xaml (15.6 KB)
Open Active Loans Application.xaml (7.9 KB)
Input.xlsx (14.7 KB)
Bot had downloaded 77 zip files. I’m sending one for the sample for your reference.
978503257325.txt (151 Bytes)
Bot’s DNA is for practicing the problems. I would suggest to try it on your own and ask for specific issue or suggestion while doing it.
Happy learning!
Thanks,
Ashok 
Yeah, I have done this and even though I didn’t got the data in excel file, I tried in other ways, but still the issue not resolved. That’s why I’m asking for help.
the problem is data is not getting for the last two columns only. Remaining all columns data is fetching except the last two columns.