Power Automate for Desktop with Microsoft Excel
Power Automate for Desktop with Microsoft Excel
Hey Everyone,
In this video, we will take a look at the integration of Power Automate Desktop with Microsoft Excel. This is a continuation of my Power Automate for Desktop Series.
In this video, here are the key items I have covered:
1) Introduction to the Excel actions
2) Launch, save and close Excel spreadsheets
3) Count the number of rows and columns with data
4) Loop through all the rows to read data
5) Write a row of data
6) Run SQL query to manipulate Excel
Table of contents
Introduction 00:00
Create flow and review the Excel sample spreadsheet 00:46
Launch the Excel spreadsheet 02:09
Count rows and columns 03:20
Create a variable 05:40
Create a loop condition 06:42
Read from Excel worksheet 08:00
Write to Excel worksheet 10:23
Close the Excel worksheet 13:20
SQL query to manipulate Excel 13:57
Excel automation advanced example 20:14
Helpful link
- https://learn.microsoft.com/en-us/tra...
Power Automate for Desktop series
1) Introduction to Power Automate for desktop • Introduction to Power Automate for De...
2) Power Automate for desktop recorder • Power Automate Desktop Recorder
3) Power Automate for desktop message box • Power Automate for Desktop Message Boxes
4) Power Automate for desktop variables • Power Automate Desktop Variables
5) Power Automate for desktop machine management capability • Power Automate for Desktop Machine Ma...
Contact information:
Twitter: / dchristian19
Facebook: / www1.christianfamily.biz
Instagram: / dan.christian.33
LinkedIn: / danchristian19
Join this channel to get access to perks:
https://www.youtube.com/@DanielChrist...
#PowerAutomate #PowerAutomateDesktop #Attendflow #UnAttendedflow #Excel
