Using UiPath RPA tool - Robotic Process Automation.
Download Excel files from web SharePoint to a folder in local (name folder according to date)
- Download from different folders (all excel file have same input format but different name and data)
Assumptions:
- Use SSO for login, typically if access using company network then sharepoint will auto login into and does not require to key in username and password needed. If access from outside, then the sharepoint web will ask username and password.
2. Consolidate all Microsoft excel files in folder into 1 excel file tab. With the following condition:
- All excel file will be tabulated into only 1 line in the consolidated RA.