Power Automate Desktop Excel Tutorial | Excel Tips & Tricks

Опубликовано: 01 Апрель 2023
на канале: Thomas Janssen
4,699
63

Do you want to automate business processes with Power Automate Desktop? High chance you will run into Microsoft Excel. After watching this Power Automate Excel Tutorial, you'll know how to read data from Excel, how to iterate to an Excel file and how to write data to Excel.

⭐️ Download the Sample Excel file here ⭐
🔗 https://www.rpa-unlimited.com/youtube...

⭐️ Skip through the video ⭐
00:00:00 - Intro
00:00:28 - Use Launch Excel to connect with the Excel file
00:02:11 - Select Worksheet with Set Active Excel Worksheet
00:03:05 - Use Read from Excel Worksheet to read the data
00:05:10 - How to Loop through each row in Excel with Power Automate Desktop?
00:05:35 - How to Save Excel file with Close Excel in Power Automate Desktop?
00:06:16 - How to Write to Excel in Power Automate Desktop?
00:06:53 - How to Write to current row in Excel with Power Automate Desktop?
00:08:16 - How to convert text to number in Power Automate Desktop?
00:09:50 - How to perform calculations in Power Automate Desktop?
00:11:03 - The Result ;)

⭐️ Related videos ⭐
✔️ Dates in Power Automate Desktop:    • Power Automate Desktop DateTime Tutor...  
String Functions in Power Automate Desktop:    • String Functions in Power Automate De...  

⭐️ Follow me ⭐
💼 LinkedIn:   / thomas--janssen  
🧡 Instagram: TomsTechAcademy

#powerautomate #powerautomatedesktop #roboticprocessautomation


Смотрите видео Power Automate Desktop Excel Tutorial | Excel Tips & Tricks онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал Thomas Janssen 01 Апрель 2023. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 4,699 раз и оно понравилось 63 посетителям.