Merge Multiple Excels to Single Excel using UiPath | Input sheets to separate sheets in output Excel

In this video, you are going to learn the steps to combine different input excels into a single Output excel file. This is the part 1 video and we have covered the scenario if there is only sheet1 in the Input Excel. The logic to solve the multi-sheet input will be covered in Part2.
Used modern activities to create the logic in the video. Those who are using the classic activities can also use the same logic with classic activities.
Selenium Playlist: • Selenium
UiPath playlist: • UiPath
Python&Powershell playlist: • Python&Powershell
Dataiku Playlist: • Dataiku
VB Playlist: • VB
Coding Playlist: • Coding
channel: / @autobotbyrahul
Please like the video, Comment with your valuable opinions, and share it with your friends. Don't forget to subscribe and enable the notification.
#uipath #excelautomation #uipathexcel

[@saurabhsoni4415]

thank you sir

[@user-zp4wr7rj4k]

Thank you sir, almost I can run the result, but a little bit trick is after created output and then always give me the error information. I try to delete this output file and run again, the error occur. Every time give me the error information is the same with you video. Could you tell me how to fix it? Thank you very much

[@praneethreddy3534]

Hi Sir, if we are using studio X instead of assign do we have any alternative option to use as assign option not available in Studio X

[@user-tv8mp4cm5j]

Hi Sir, Thank you for all. when i put "item" in "Use Excel file", dont work. I have 3 documents in that folder. ERROR: Main.xaml: BC30451: 'item' is not declared. It may be inaccessible due to its protection level. The "item" variable is missing. Use Data Manager to recreate it. Help Me please, i need read all documents and put in one sheet

[@autobotbyrahul]

I believe you failed to create a variable. If you followed the same steps from video please make sure the variables are in place.

[@user-yw2sm4bf1e]

What ot do if sheet names are different instead of Sheet1

[@autobotbyrahul]

You can get sheet names and then use a loop

[@kattanikhil474]

for me its not working bro .... its opening and reading all the files but writing only the last file =...plz respond

[@autobotbyrahul]

Plz confirm whether you did the same steps as in the video. If yes, plz create a post in UiPath community and share me the link. I can share you the worklfow there.

[@SyedSAhmed3]

Hi .. thanks for ur video it's very useful...i have 9 files to merge in single excel but the sheet name of every file is different...how can we loop that... there i m getting stuck...

[@autobotbyrahul]

@@SyedSAhmed3 You can use For Each Excel sheet activity to loop through all the sheets in an excel.

[@user-zp4wr7rj4k]

@@autobotbyrahul hi, could you post a video to show us how to use For Each Excel Sheet to loop through all different folder's name but same excel in every individual folder. To merge every different folder's excels in one excel. Thank you very much.