Скачать с ютуб UI Automation: Get Excel files in folder, enter data in app & write results back to Excel в хорошем качестве

UI Automation: Get Excel files in folder, enter data in app & write results back to Excel

In this video tutorial, we are going to show you how to automate the following steps using Microsoft Power Automate for desktop: 00:00 Introduction 00:10 The scenario 01:04 Get all Excel files (.xls, .xlsx and .xlsm) in folder 01:54 Iterate through all the Excel files using the "for each" loop 02:26 Reading Excel data (of variable size) using "get first free row/column from Excel worksheet" and "read from Excel worksheet" actions (remember to enable the option "first line of range contains column names") 03:14 Creating a subflow to improve modularity, readability and maintainability of the overall desktop flow 03:17 Check if an app is already opened using "if window" action; if not, start the app using the "run application" action 03: 28 Perform data entry and data extraction on application using "populate text field in window" and "get details of the UI element in window" actions 03:33 How to reference the items in the current datarow 04:25 Using "run subflow" action to trigger the subflow from the main flow 04:40 Update Excel using "write to Excel worksheet" action; this requires a row counter so that we are always updating the Transaction ID into the correct row 05:45 Create another subflow to terminate Excel and AnyTellerDemo application; this subflow will be run at the start and end of the main flow 07:31 Using "move file" action to move all the processed files into a success folder Related videos of concepts used in this video: • Excel automation playlist:    • Power Automate Desktop Excel Automati...   • UI automation playlist:    • How to Interact with Windows and Appl...   Keep in touch! Website https://mspowerautomate.com/ Twitter   / msautomate   Facebook   / ms-power-aut.  . LinkedIn   / power-aut.  . #rpa #PowerAutomateDesktop #RoboticProcessAutomation #PowerAutomate #ExcelAutomation #UIAutomation