How to merge 2 Excel data with multiple sheets
Use Case Description
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.
AS-IS WORKFLOW, TO-BE WORKFLOW
Other information about the use case
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
Anil_G
Yoichi
Chirag_Shetty_Divakar
fernando_zuluaga
Jithesh_R
loi.nguyen
Samraat_Maharjan1
prabin_chand1
supermanPunch
supriya117