Combine Data from Multiple Excel Files in Blue Prism | Extract & Merge Tutorial 2025 скачать в хорошем качестве

Combine Data from Multiple Excel Files in Blue Prism | Extract & Merge Tutorial 2025

📊 Learn How to Extract & Combine Data from Multiple Excel Files in Blue Prism! In this Blue Prism tutorial, I'll show you step-by-step how to extract data from two (or more) Excel workbooks, merge them together, and save to a single Excel file using collections and loops. ⏱️ TIMESTAMPS: 0:00 - Introduction & Excel Files Overview 0:22 - Sample Excel Files (Book2 with 14 records, Sample with 22 records) 0:47 - Output File: Appended Excel 1:05 - Blue Prism Process Studio Setup 1:18 - Code Overview & Step-by-Step Explanation 1:18 - Step 1: File Management (Get Files from Folder) 2:12 - Step 2: Create Instance & Handle 2:39 - Step 3: Loop Through Files 2:48 - Step 4: Open Workbook & Get Worksheet as Collection 3:05 - Step 5: Append Rows to Main Collection 4:02 - Understanding Collection Append Logic 4:24 - Step 6: Create New Workbook 4:56 - Step 7: Write Collection to Excel 5:12 - Step 8: Save Workbook As (Appended Excel) 5:58 - Step 9: Close Workbook & Close Instance (Best Practice!) 6:03 - Live Demo & Debug Mode Execution 7:13 - Watching Data Merge in Real-Time 7:37 - CRITICAL Best Practice: Always Close Workbook & Instance 8:07 - Verifying Final Output (37 Total Records) 8:26 - Comparing Original Files vs Merged File 🎯 WHAT YOU'LL LEARN: ✅ Extract data from multiple Excel workbooks automatically ✅ Use File Management utility to get files from folder ✅ Loop through multiple Excel files dynamically ✅ Get worksheet data as collection ✅ Append collections from different workbooks ✅ Create new workbook and write merged data ✅ Save combined data to single Excel file ✅ Best practices: Close Workbook & Close Instance 📊 PRACTICAL EXAMPLE SHOWN: Book2.xlsx: 14 records (Sheet1) Sample.xlsx: 22 records (Sheet1) Output: Appended Excel.xlsx with 37 total records 💡 KEY CONCEPTS COVERED: Utility - File Management (Get Files action) MS Excel VBO - Create Instance Loop through file collection Open Workbook with dynamic path Get Worksheet as Collection Collection Manipulation - Append Rows Create Workbook & Write Collection Save Workbook As with custom path Close Workbook & Close Instance 🔧 BLUE PRISM ACTIONS USED: 1. Utility - File Management: Get Files 2. MS Excel VBO: Create Instance 3. MS Excel VBO: Open Workbook 4. MS Excel VBO: Get Worksheet as Collection 5. Utility - Collection: Append Rows to the Collection 6. MS Excel VBO: Create Workbook 7. MS Excel VBO: Write Collection 8. MS Excel VBO: Save Workbook As 9. MS Excel VBO: Close Workbook 10. MS Excel VBO: Close Instance ⚠️ IMPORTANT BEST PRACTICE: Always call "Close Workbook" and "Close Instance" at the end of your Excel automation process. If you don't close these, Excel instances will remain running in Task Manager, consuming system resources! 📁 FILE STRUCTURE SHOWN: Input Path: RPA\Excel Operations\Appended from Excel\From 2 Excel\ Book2.xlsx (14 records) Sample.xlsx (22 records) Output Path: RPA\Excel Operations\Appended from Excel\ Appended Excel.xlsx (37 merged records) 🎓 USE CASES FOR THIS TUTORIAL: Merging monthly sales reports from different branches Combining employee data from multiple departments Consolidating inventory data from various warehouses Aggregating survey responses from multiple files Merging financial data from different periods 🔗 RELATED TUTORIALS: Remove Duplicate Records in Blue Prism Alert Stage Configuration Tutorial Session Variables in Blue Prism (Coming Soon!) Excel Automation Complete Guide 👨‍💻 ABOUT THIS CHANNEL: I create practical Blue Prism RPA tutorials with real-world examples. Subscribe for step-by-step automation tutorials, Excel operations, collection manipulation, and Blue Prism best practices! 💬 CONNECT WITH ME: 👍 Like if this tutorial helped you merge Excel files 💬 Comment: How many Excel files do you need to merge? 🔔 Subscribe for more Blue Prism Excel automation tutorials 📤 Share with your RPA development team #BluePrism #ExcelAutomation #RPATutorial #MergeExcel #DataExtraction --- 🏷️ TAGS FOR THIS VIDEO: combining data from two excel file in blueprism, blue prism, blue prism tutorial, merge excel files blue prism, extract data from excel blue prism, append data blue prism, collection manipulation blue prism, file management blue prism, excel automation rpa, combine excel workbooks, blue prism excel operations, loop through files blue prism, get worksheet as collection, append rows collection, rpa tutorial, blueprism automation