Power Automate Desktop Excel Automation Tutorial (Part 1 of 3)

hi guys welcome to ms power automate in today's video we will be going through the different type of excel actions the different type of accelerations are launch excel attached to running well read from excel worksheet save excel write to excel worksheet close excel set activation and lastly get first free column or row from excel worksheet so there are also other different actions but we will go through the most common excel actions so in this case let's go through the launch excel to open a new document you may select this with a blank document option otherwise if you would like to open an existing file you may select and open the following document you mean to enter the document path or you may select a file to view the excel while the process is running you may enable this make instance visible in the advanced option you can also enable the load add-ins and macros do take note there is also a variable produce called the excel instance this variable will be used for other further actions such as uh read from excel worksheet or write to excel would she set lt visa machine or get first free row from the column okay so you can also attach to a running excel so in this case for example i would like to attach this document okay but in this case i need to launch the excel first okay next i would like to show a safe excel example okay so if you want to save the excel we will require to indicate the instance and there are also different type of safe mode save document or save the document as other different types you may also select a different type of format okay other than that you can also use the close excel you can also choose to save the document before closing okay now let's move on with the read from excel worksheet there are different ways to retrieve the value in excel so in this case there are few options here available the value of a single cell or values from one range of cells okay you may need to indicate the start column and the stack rule under advanced option you may choose to get the cell contents as a text and it will produce a variable called the excel data so this really depends if you choose a single cell it will return a single string variable if you choose a range of cells this variable will be produced as a data table and you may need to indicate the start column start row and column and end row okay so let's try to make this one example i want to start at row at column a row one i end at column b and row two and i would like to enable the first line of french contains column name okay so in this case the end cannot be empty let me double check okay two see okay let me open the file okay so in this case i have up to three rows all right so if i were to run this it will launch my excel here and then if you can see here under my excel data i have one rows and two columns okay so in this case i read i start from column a and one and at column b two so i read from here i end here that's why i only have one rows of record so how do we make this dynamic in this case what we can do is you may want to select this get first free row or column you indicate the excel instance they will provide you a variable called first free column and first free row once you click save in this case you may choose to select here at column a and add first free row okay let's try around and we see the output so it returns me four rows and two column so we compare it only returns me up to 1 and 2 and everything okay so in this case this actually makes this set of script more dynamic let's say i try to increase the number of rules [Music] okay let me run one two three four five six six rows but they give me seven rules okay let's check one two three four five six seven one of this is empty why is it empty it's because a data table will always start with zero the index okay the index will always start from zero this one will be row zero row one row two row three row four row five but in this case when we get the first free row the value here is eight so in order to make this more dynamic you have to put here first three row minus one okay close the excel and run again one two three four five six one two three four five six okay since we already get the correct records now let's move on with the right to excel worksheet in this case i need to indicate the excel instance and the value to right so in this case i would like to choose an unspecified cell all right i need to indicate the column let's say i press column b row at which row i need to select the first free row all right the value to write i will do hello click save so let's try to run the board again okay as you can see here the hello is already written in this excel form that's all for the most common excel actions so if you're keen to learn more do remember to subscribe our channel as we have constant update and tutorial video on microsoft power automate desktop thank you

Channel: MS Power Automate

Views: 309

Rating: 4.6923075 out of 5

Keywords: microsoft power automate desktop, microsoft power automate, power automate desktop, power automate, power automate desktop tutorial, power automate tutorial, power automate desktop for beginners, excel automation, power automate desktop excel

Id: XmRXjpMb2Rg

Length: 9min 5sec (545 seconds)

Published: Fri Aug 13 2021