- Open file in Google Chrome - row “Link” in excel.
- Click Download
- Put the path from row “Document” in excel
- Rename it using row " Rename" in excel
See files below,
See files below,
To get the latest file from the downloaded folder, you can use the below code.
Directory.GetFiles(folder_path,“.xlsx”,SearchOption.AllDirectories).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Tolist(0)
After getting this you can use Move file activity, to paste at desired location.
Use Read Range activity to read your excel file-> Output to Datatable Variable
Use For Each Row to loop into your datatable
Use Open Browser activity inside For Each Row activity and give URL as row(“Link”).ToString
Once opened then choose click download as you said using click activity
Once you click on dowload button SaveAs Dialog box appears
Use TypeInto activity to write into Filename textbox as row(“Document”).ToString +""+row(“Rename”).ToString
This will save your file into the given path as in Excel file
Hope this may help you
Thanks
Hello @srini84 -
That’s actually what I did and it’s working. The problem is even though the ocndition that I put in the empty field is true, it’s not typing the path. if the before path is too long