UiPath | How to Merge multiple Excel sheets and write to a new sheet or Excel | What and How Series

👉 This Video talks about the Following
Merge Excel Data into a new Sheet
Merge Data from multiple sheets into a single one
Consolidate Data from multiple Excels
What and How Series in UiPath
►►►►►► This Video covers the Following ◀◀◀◀◀◀◀◀
► Timestamps ◀
0:00 Introduction
2:05 : Problem Statement
3:50 : Create a New Process
4:42 : Read the Excel in UiPath
6:09 : Get the sheets count and Names
12:41 : Loop and Read the Excel Sheets
19:21 : Merge the Datatables
22:36 : Object Reference not set to instance of an Object Error in UiPath
25:35 : Understand the scope of variables
30:11 : Add Final Data to existing Excel
32:02 : Writing Final Data to a New Excel
►►►►►► Links to Refer ◀◀◀◀◀◀◀◀
👉👉 Split CSV Data to Multiple Excel Sheets | Read CSV | ( Excel Automation UiPath ) | Scenarios | RPA
• Split CSV Data to Mult...
👉👉 All About Configuration Files
• UiPath - Config File ...
👉👉 What and How Series UiPath | Q n A
• UiPath - What & How | ...
👉 Find the Orchestrator Module here: Master UiPath Orchestrator for Seamless RPA Management
mukeshkala.graphy.com/courses...
🟢 Discount Coupon: EARLY100 to avail 35% off - Applicable for first 100 enrolments.
👉👉Exception Handling Playlist
• UiPath - Exception Han...
👉👉 [HINDI] Exception Handling Playlist
• Hindi UiPath Playlist ...
👉👉 Using Assets in UiPath | Explained with Scenarios
• 🔴 16 .Using Assets in ...
👉👉UI Frameworks | Understand UI Explorer | Selectors | Indicate Element | Repair | Highlight
• UI Frameworks | Unders...
👉👉UiPath 2022.10 Updates | Data Manager in UiPath | Global Variables | Constants | UiPath New Features
• UiPath 2022.10 Updates...
👉👉RE Framework Complete Playlist
• Robotic Enterprise Fr...
👉👉 Excel Automation Playlist
• Excel Automation Series
Happy Automation!
►►►►►► Social Media Links ◀◀◀◀◀◀◀◀
👉 Instagram : / uipathtutorials
👉 LinkedIn : / mukeshkala
👉 Twitter : / tweetmukeshkala
👉 Facebook: / uipathfb
👉 RUclips : / tutorialsbymukeshkala
👉 Mail : [e-mail]
#UiPath #RPA #Automation #mukeshkala #Discover #UiPathCommunity #automation #uipathmvp
►►►►►► Tags ◀◀◀◀◀◀◀◀
Tutorials by Mukesh Kala
UiPath Tutorials by Mukesh Kala
uipath
mukesh kala
uipath tutorial
uipath projects
rpa tutorial for beginners
uipath tutorial for beginners
rpa interview questions and answers
rpa projects
ui path
uipath rpa
rpa uipath tutorial
Triggers in Orchestrator
Job States
Clashing Triggers

[@csat2710]

Thank you sir now i got enough knowledge to read, write, merge and create new file from consolidated file.

[@MukeshKala]

Great

[@sharmadeepak9395]

Full of knowledge like always

[@MukeshKala]

Thank You

[@suraj_singh321]

Great video sir can you make a video on transpose row to column where rows are dynamic without using linq query and macro uipath

[@MukeshKala]

Okay , let me try - Thanks

[@suraj_singh321]

@@MukeshKala also for column to row where column are dynamic without linq query and macro

[@joshuamarrion66]

Thanks for your video Mukesh it was very helpful 🎉

[@MukeshKala]

Glad to hear that

[@dnyaneshkale8293]

Hello sir, thank you for this tutorial. But is there any way to merge(like outer join) two excel files based on single common column? Do you have any tutorial on that?

[@MukeshKala]

I don't have the tutorials but UiPath has the Join Data Table activity which you can use to do Inner , left outer join. So we just read both the data sets into 2 Data tables and apply the Join Data Table activity

[@rashmirekha5151]

Hi sir,
Can you please make one vodeo with sql database with exception handling.

[@MukeshKala]

Yes , I can thanks for suggesting

[@David-rm1wn]

Thanks for the video...Where can i get excel sheet file?

[@MukeshKala]

I am yet to uplaode the data to my website - You can drop me a mail on my mailid available in desc and i would revert with file

[@allthecommonsense]

Obsolete. Should be using modern activities and Excel *process* scope

[@MukeshKala]

True , Can be useful for the people where they are in older version of studio (Classic)