How to Automate Excel Tasks in UiPath | Consolidate & Filter Data Step-by-Step
🚀 Learn Excel Automation in UiPath like a Pro!
In this hands-on UiPath tutorial, we show you how to automate Excel file consolidation and filtering using UiPath Studio. You'll learn how to iterate through multiple department-based Excel files (HR, IT, Marketing, Sales), merge them into one file, and apply dynamic filters such as selecting rows with amount greater than 2000 or filtering by "Travel" category.
🔍 Covered in this video:
✔️Looping through the folder with the excel files
✔️Reading Excel files with modern design experience
✔️Merging multiple Excel sheets into one use the merge activity in UiPath
✔️Cloning DataTables
✔️Writing filtered results into a new Excel file
✔️Modern vs Classic activities explained
✔️How to use LINQ queries in UiPath
✔️How to use the filter datatable activity in UiPath
Link to the sample files used in the video
https://bit.ly/3Z5AP3l
🛠 Whether you're new to RPA or looking to enhance your UiPath Excel automation skills, this video is packed with tips to help you automate smarter and faster.
⏱️ Timestamps:
0:00 - Intro
3:17 - Modern vs classic activities
8:00 - Project Build
14:00 - Cloning dataTable
18:00 - Demo of the consolidation of the excel files into a single excel file
21:00 - Filtering based on Amount and Category
👍 Like | 🔁 Share | 📩 Comment | 🔔 Subscribe for more RPA videos
#UiPath #ExcelAutomation #RPA