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 Multiple Excel Shee...  

👉👉 All About Configuration Files
   • UiPath -  Config File outside Nudget ...  

👉👉 What and How Series UiPath | Q n A
   • UiPath - What & How | Channel Q n A  

👉 Find the Orchestrator Module here: Master UiPath Orchestrator for Seamless RPA Management
https://mukeshkala.graphy.com/courses...
🟢 Discount Coupon: EARLY100 to avail 35% off - Applicable for first 100 enrolments.

👉👉Exception Handling Playlist
   • UiPath - Exception Handling  

👉👉 [HINDI] Exception Handling Playlist
   • Hindi UiPath Playlist | हिंदी  

👉👉 Using Assets in UiPath | Explained with Scenarios
   • 🔴 16 .Using Assets in UiPath | Explai...  

👉👉UI Frameworks | Understand UI Explorer | Selectors | Indicate Element | Repair | Highlight
   • UI Frameworks | Understand UI Explore...  

👉👉UiPath 2022.10 Updates | Data Manager in UiPath | Global Variables | Constants | UiPath New Features
   • UiPath 2022.10 Updates | Data Manager...  

👉👉RE Framework Complete Playlist
   • Robotic Enterprise  Framework  

👉👉 Excel Automation Playlist
   • Excel Automation Series  

Happy Automation!

►►►►►► Social Media Links ◀◀◀◀◀◀◀◀
👉 Instagram :   / uipathtutorials  
👉 LinkedIn :   / mukeshkala  
👉 Twitter :   / tweetmukeshkala  
👉 Facebook:   / uipathfb  
👉 YouTube :    / tutorialsbymukeshkala  
👉 Mail : [email protected]

#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