Having a folder where multiple subdirectories are present, Each subdirectory has 2 Excel files with multiple sheets (Sheet1, Sheet2).
I am looking to merge both the Excel files from each repository wrt. to their respective sheets.
For Eg: Sheet1 data needs to be merged with Sheet1, Sheet2 with Sheet2, and finally give an Output Excel file containing both the sheets with merged data.
Industry categories for this use case: Marketing Sales
Skill level required: Beginners
UiPath Products that were used: UiPath Studio
Other applications that were used: -
Other resources: -
What is the top ROI driver for this use case?: Other