Here are the steps to write/edit in Excel file using PowerAutomate Desktop:
- Open PowerAutomate desktop. Start with “New Flow”. Give a name to the flow and click on “Create” button.
2. Click on “Excel” in Actions:
3. Select “ Launch Excel” option from the Excel dropdown and drop it to workspace area ( drag and drop). Once you drop it to workspace area, it gives option to “select parameters” :
4. In “Select Parameters” option, “Launch Excel” has two options — start with blank document or open an existing option. Here we will try with second one i.e open and existing excel.
5. Once you select “ and open the following document” , it gives option to select existing excel file.
6. Click on folder icon to select the file from the folder ( as given in following image)
7. Note: here we should note that above step results in a Variable output. By default it is named as “ExcelInstance”. This can be renamed to any variable name and henceforth this variable will be used for further processing.
8.We can leave rest of the parameters as it is and click on “Save”. This will show it as first step in Workspace area.
8. Now select “ Write to Excel worksheet” from the excel dropdown in Actions. drag and drop this on Workspace area.
9. Once you drop it on workspace area, it will give option to select parameters
10. In the parameters note that, for field “Excel instance”, it has by default picked up the variable output from previous step and showing it between “%” symbol. No need to change this.
Next you can enter your data in “Value to write” field .
for “ Write mode” field there are two options. we will keep default one — “On specified cell”
then in column we have to mention column Letter or Column number. Note that this should be default excel column names like “A”,”B”,”C” etc.
In rows specify the row number like “1”,”2",”3" etc
Please find below screenshot for reference:
11. Click on “Save “ and this will appear as second step in workspace area.
12. Next select “ Save Excel” in Excel dropdown in Actions. Drag and drop this on workspace area:
13. Once you drop it on workspace area, it gives option to select parameters. keep the default one and click on save button.
14. On Save this appears as third step in workspace area:
15. Now our flow is ready for run and test. Click on Run button on top menu bar and wait for magic :). this will launch excel and fill the value in first column i.e A and 8th row.
