This quick tutorial shows you how to use Power Automate Desktop to create and save an Excel spreadsheet.<\/p>\n\n\n\n
You\u2019ll learn how to use Power Automate Desktop to:<\/p>\n\n\n\n
Table of Contents<\/p>\nToggle<\/span><\/path><\/svg><\/svg><\/span><\/span><\/label>Prerequisites<\/a><\/li>Video Walkthrough<\/a><\/li>Using Power Automate Desktop To Create An Excel Spreadsheet<\/a><\/li>What The Completed Flow Looks Like<\/a><\/li>Run The Full Flow<\/a><\/li><\/ul><\/nav><\/div>\n<\/span>Prerequisites<\/span><\/h2>\n\n\n\nYou will need these two applications installed on your local machine:<\/p>\n\n\n\nPower Automate Desktop<\/li>A version of Microsoft Excel<\/li><\/ol>\n\n\n\n<\/span>Video Walkthrough<\/span><\/h2>\n\n\n\nIf you prefer video, here’s the walkthrough of the contents of this article.<\/p>\n\n\n\n\n<\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"block-d2fe5f78-8434-4ffd-bbae-f06b2effe04f\"><span class=\"ez-toc-section\" id=\"Using_Power_Automate_Desktop_To_Create_An_Excel_Spreadsheet\"><\/span>Using Power Automate Desktop To Create An Excel Spreadsheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p id=\"block-ac33d3c9-4e53-4ffa-a663-638dbfd599b8\">Launch Power Automate Desktop.<\/p>\n\n\n\n<p id=\"block-c56f85a3-c6fd-4d7b-afe4-323e1125a878\">Add a new flow by clicking on the + icon in the top left of the window. Name your flow \u201cexcel_hello_world\u201d and hit the Create button.<\/p>\n\n\n\n<div id=\"block-3256b856-0b19-4506-a867-50e1c3f3089a\" class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/boyneanalytics.com\/wp-content\/uploads\/2021\/10\/pad_create_new_flow.jpg\" alt=\"This image has an empty alt attribute; its file name is pad_create_new_flow.jpg\"\/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"block-910d58a9-3c88-462e-8c5d-43c16145735e\">Finding and choosing the Excel actions<\/h3>\n\n\n\n<p id=\"block-ece98010-d20a-4449-a97e-cc5d6a6f6a52\">The left pane of the Editor shows all the categories of actions available to you.<\/p>\n\n\n\n<p id=\"block-3882e5d6-1053-4641-b2d1-ed77a684f165\">You\u2019ll find \u201cExcel\u201d in the middle of the list. Expand the category to see individual actions for controlling Excel.<\/p>\n\n\n\n<p id=\"block-f1d05f50-3029-4727-8fdd-6a4b829ad821\">We\u2019ll be using three actions in this starter project. I\u2019ve labeled them in order in the picture below.<\/p>\n\n\n\n<div id=\"block-939cafd7-3a53-4ac8-ad91-2208cabb3038\" class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/boyneanalytics.com\/wp-content\/uploads\/2021\/10\/actions_excel_category_expanded.jpg\" alt=\"This image has an empty alt attribute; its file name is actions_excel_category_expanded.jpg\"\/><\/figure><\/div>\n\n\n\n<p id=\"block-9051305d-6498-40ed-aa0e-b956a6ac4255\">The first action we\u2019ll use is to launch Excel on your machine.<\/p>\n\n\n\n<p id=\"block-9b767d95-9d61-4b6d-bdec-b9196eee7c8f\">This action will launch a new instance of Excel, regardless if you already have a spreadsheet already open or not.<\/p>\n\n\n\n<p id=\"block-bd3655cc-f706-4e36-9e1a-4c874fd09071\"><em>It\u2019ll be less confusing for you now if you close any instances of Excel that are currently running.<\/em><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"block-51000adf-c158-45e5-832d-a17e8c13e106\">Choose \u201cLaunch Excel\u201d<\/h3>\n\n\n\n<p id=\"block-e51f0f7a-1bbe-43a2-a543-ad8ef416020e\">Drag and drop \u201cLaunch Excel\u201d into the Main window in the editor.<\/p>\n\n\n\n<p id=\"block-5fbfa991-31d2-4d93-b716-521c9b78413b\">You will see a pop-up window that allows you further control over when Excel opens. For our tutorial, leave all the defaults.<\/p>\n\n\n\n<p id=\"block-4fc839f9-0c03-4d98-a76a-6ffaae0f7f9a\">This will result in Excel launching with a blank worksheet.<\/p>\n\n\n\n<p id=\"block-c288b54d-464b-4aa0-85fd-df6ec23d6e3f\">Now we want to do something useful with this worksheet.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"block-0690a747-8d52-4d22-b7a7-f0d4b513951a\">Write to the worksheet<\/h3>\n\n\n\n<p id=\"block-9ff6c9b3-50e7-45d3-bb95-3e52e9418a17\">Drag and drop \u201cWrite to Excel worksheet\u201d into the editor as the next action.<\/p>\n\n\n\n<p id=\"block-31b9634c-001b-413b-877c-0835a2d33132\">We\u2019re going to keep things simple in the pop-up window.<\/p>\n\n\n\n<p id=\"block-a623950f-c886-4396-beb2-01f31a3d2796\">I simply want to write \u201cHello World\u201d into the first cell of the spreadsheet.<\/p>\n\n\n\n<p id=\"block-9e92a593-c59c-4507-becb-1fcef7ce5e55\">To achieve this, type into three input boxes:<\/p>\n\n\n\n<ul id=\"block-a74e114c-e81b-42ef-8600-7956c6e7edc2\"><li><em>Value to write:<\/em> Hello World<\/li><li><em>Column:<\/em> 1<\/li><li><em>Row:<\/em> 1<\/li><\/ul>\n\n\n\n<p id=\"block-43550cd6-9564-4987-ae6e-ae2436fdee2f\">Check the picture below to see exactly what we\u2019re putting where.<\/p>\n\n\n\n<p id=\"block-133292c2-33ee-40fe-8e63-6fcd6649c157\">Leave the other input boxes unchanged and click the \u201cSave\u201d button.<\/p>\n\n\n\n<div id=\"block-bd9bedeb-2032-4052-8cab-9ff4cdf6e389\" class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/boyneanalytics.com\/wp-content\/uploads\/2021\/10\/actions_write_to_worksheet.jpg\" alt=\"This image has an empty alt attribute; its file name is actions_write_to_worksheet.jpg\"\/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"block-9cfe3659-11a1-428b-a46b-0decdf2b9a5b\">Testing what we\u2019ve got so far<\/h3>\n\n\n\n<p id=\"block-1b5ed908-935c-4023-a48c-f40f3999c96f\">At this point, you can test what you\u2019ve done so far by running the flow.<\/p>\n\n\n\n<p id=\"block-76546f43-e30e-4465-9a07-631914651525\">When you hit the play button in the top bar, keep an eye on the bottom taskbar in Windows. You\u2019ll see the Microsoft Excel icon appear, as it is launched by your flow.<\/p>\n\n\n\n<p id=\"block-ca674ebf-4fc7-43aa-a82b-c1580a48f015\">Unless you quickly minimize the PAD editor, you may not see the flow actually writing on the spreadsheet.<\/p>\n\n\n\n<p id=\"block-5cecde62-00cd-4441-be10-4dfbcb38111c\">But you can switch from the editor to Excel and you should see what\u2019s shown in the picture below.<\/p>\n\n\n\n<div id=\"block-95a7aba5-6ea1-4b49-bed3-083547513b23\" class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/boyneanalytics.com\/wp-content\/uploads\/2021\/10\/test_open_worksheet_with_hello_world.jpg\" alt=\"This image has an empty alt attribute; its file name is test_open_worksheet_with_hello_world.jpg\"\/><\/figure><\/div>\n\n\n\n<p id=\"block-21230552-8533-4745-9d36-a1fe3cd8665f\">I\u2019ll call out two points.<\/p>\n\n\n\n<p id=\"block-1ac18208-266e-4928-a7b8-0b4c8206969b\">This is a new instance of Excel with an unsaved workbook. So, the focus is on Sheet1 of Book1.<\/p>\n\n\n\n<p id=\"block-6a0121e2-e881-4e43-82d3-ff1721c81fb6\">The second point is that \u201cHello World\u201d has been written into the first cell of the worksheet. That is exactly what we specified.<\/p>\n\n\n\n<p id=\"block-265c7a4b-1ef5-4bb7-81c7-9d552cd00e48\">We ran this flow without an action to close Excel. So the spreadsheet is left open for us to peruse. That\u2019s quite useful to check that we\u2019re on the right track.<\/p>\n\n\n\n<p id=\"block-b20e4e9b-de3d-446f-95f2-0119ca5c30ea\">But we do want to save the spreadsheet. So, let\u2019s move on to add the final action.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"block-a831edee-cc80-443f-97b3-0f614167be90\">Save and close the Excel file<\/h3>\n\n\n\n<p id=\"block-aea4aff5-87d5-4de1-9b47-eefba636b057\">Our final step is to save and close the file.<\/p>\n\n\n\n<p id=\"block-8c20f6a0-1309-46e2-97b0-18d2fee8f955\">You\u2019ll see an action under the Excel category for both \u201cSave Excel\u201d and \u201cClose Excel\u201d.<\/p>\n\n\n\n<p id=\"block-82e34aff-f8e8-490d-98c1-010e930f3b9f\">We could use both actions to save the spreadsheet first and then close it. But we can do what we need with a single action.<\/p>\n\n\n\n<p id=\"block-55b55887-b11f-4de5-bb36-82221b8e2017\"><strong><em>Drag and drop the \u201cClose Excel\u201d action into the Main flow.<\/em><\/strong><\/p>\n\n\n\n<p id=\"block-b0318cc7-a153-4d59-85e4-5d6b2f9d1ed4\">The default parameters for this action are to close the spreadsheet without saving it. We want to change this!<\/p>\n\n\n\n<p id=\"block-116581d5-58ba-484a-ace4-2815521ae767\"><strong><em>Expand the dropdown for the closing parameter and switch to \u201cSave document as\u201d.<\/em><\/strong><\/p>\n\n\n\n<div id=\"block-b054c3b8-f3d7-44c2-8182-2aef2bdc62e8\" class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/boyneanalytics.com\/wp-content\/uploads\/2021\/10\/actions_excel_save_as.jpg\" alt=\"This image has an empty alt attribute; its file name is actions_excel_save_as.jpg\"\/><\/figure><\/div>\n\n\n\n<p id=\"block-ff5d9de4-0ee2-43fe-bcb9-4fa8e1b2cc14\">This will open two new parameters. The first allows you to set the extension. You can leave it as the default.<\/p>\n\n\n\n<p id=\"block-1715e297-c43b-4b2a-8d16-c36049eba1be\">The second parameter lets you input a full file path and name (you don\u2019t need to include an extension).<\/p>\n\n\n\n<p id=\"block-dfa5c6b4-4c53-41a3-87cf-cfa5c93cd70c\">I set my document path to: \u201c<strong>c:\\users\\public\\hello_world<\/strong>\u201d.<\/p>\n\n\n\n<p id=\"block-1ef274cc-772d-4045-a132-2373be712b8e\">And that\u2019s it!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"block-4f601541-a447-4815-ad76-ea752df42128\"><span class=\"ez-toc-section\" id=\"What_The_Completed_Flow_Looks_Like\"><\/span>What The Completed Flow Looks Like<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p id=\"block-54056ce1-c2a0-4cac-bb97-55e98df18dec\">This picture shows what your full flow should look like.<\/p>\n\n\n\n<div id=\"block-e4be1f17-fae7-480a-b361-49830ceb93e5\" class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/boyneanalytics.com\/wp-content\/uploads\/2021\/10\/main_flow_completed.jpg\" alt=\"This image has an empty alt attribute; its file name is main_flow_completed.jpg\"\/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"block-85b6a38c-d942-4773-b89f-1e55e201497c\"><span class=\"ez-toc-section\" id=\"Run_The_Full_Flow\"><\/span>Run The Full Flow<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p id=\"block-c96547bd-7e8b-4251-8306-4794dae348ec\">When you click the run button, you\u2019ll be forgiven for wondering if anything has happened.<\/p>\n\n\n\n<p id=\"block-f8c236fb-7e05-458a-84da-906bad9ea016\">This is because the Excel application has a very simple and quick task to perform before it closes itself. You may see the Excel icon appear in the taskbar at the bottom of Windows, but it will only be there for seconds.<\/p>\n\n\n\n<p id=\"block-1f4acc98-502e-48e8-8dfa-af12b8a0e9d4\">To verify that the flow has done what you expected, open the folder where you specified the file to be written.<\/p>\n\n\n\n<p id=\"block-2ba4854c-6e74-444d-917c-c08daf1d4b30\">There should be an excel file with the name you specified in this folder. And its contents should contain the text \u201cHello World\u201d in the first cell.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This quick tutorial shows you how to use Power Automate Desktop to create and save an Excel spreadsheet. You\u2019ll learn how to use Power Automate Desktop to: Launch Excel on your local machine Create a new Excel workbook Write content to a worksheet Close and save the Excel file to a specific location Prerequisites You … <a title=\"Power Automate Create Excel File (Tutorial)\" class=\"read-more\" href=\"https:\/\/bandittracker.com\/create-an-excel-file-with-power-automate-desktop\/\" aria-label=\"More on Power Automate Create Excel File (Tutorial)\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[24],"tags":[],"_links":{"self":[{"href":"https:\/\/bandittracker.com\/wp-json\/wp\/v2\/posts\/655"}],"collection":[{"href":"https:\/\/bandittracker.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bandittracker.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bandittracker.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bandittracker.com\/wp-json\/wp\/v2\/comments?post=655"}],"version-history":[{"count":4,"href":"https:\/\/bandittracker.com\/wp-json\/wp\/v2\/posts\/655\/revisions"}],"predecessor-version":[{"id":802,"href":"https:\/\/bandittracker.com\/wp-json\/wp\/v2\/posts\/655\/revisions\/802"}],"wp:attachment":[{"href":"https:\/\/bandittracker.com\/wp-json\/wp\/v2\/media?parent=655"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bandittracker.com\/wp-json\/wp\/v2\/categories?post=655"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bandittracker.com\/wp-json\/wp\/v2\/tags?post=655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
You will need these two applications installed on your local machine:<\/p>\n\n\n\n
If you prefer video, here’s the walkthrough of the contents of this article.<\/p>\n\n\n\n\n<\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"block-d2fe5f78-8434-4ffd-bbae-f06b2effe04f\"><span class=\"ez-toc-section\" id=\"Using_Power_Automate_Desktop_To_Create_An_Excel_Spreadsheet\"><\/span>Using Power Automate Desktop To Create An Excel Spreadsheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p id=\"block-ac33d3c9-4e53-4ffa-a663-638dbfd599b8\">Launch Power Automate Desktop.<\/p>\n\n\n\n<p id=\"block-c56f85a3-c6fd-4d7b-afe4-323e1125a878\">Add a new flow by clicking on the + icon in the top left of the window. Name your flow \u201cexcel_hello_world\u201d and hit the Create button.<\/p>\n\n\n\n<div id=\"block-3256b856-0b19-4506-a867-50e1c3f3089a\" class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/boyneanalytics.com\/wp-content\/uploads\/2021\/10\/pad_create_new_flow.jpg\" alt=\"This image has an empty alt attribute; its file name is pad_create_new_flow.jpg\"\/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"block-910d58a9-3c88-462e-8c5d-43c16145735e\">Finding and choosing the Excel actions<\/h3>\n\n\n\n<p id=\"block-ece98010-d20a-4449-a97e-cc5d6a6f6a52\">The left pane of the Editor shows all the categories of actions available to you.<\/p>\n\n\n\n<p id=\"block-3882e5d6-1053-4641-b2d1-ed77a684f165\">You\u2019ll find \u201cExcel\u201d in the middle of the list. Expand the category to see individual actions for controlling Excel.<\/p>\n\n\n\n<p id=\"block-f1d05f50-3029-4727-8fdd-6a4b829ad821\">We\u2019ll be using three actions in this starter project. I\u2019ve labeled them in order in the picture below.<\/p>\n\n\n\n<div id=\"block-939cafd7-3a53-4ac8-ad91-2208cabb3038\" class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/boyneanalytics.com\/wp-content\/uploads\/2021\/10\/actions_excel_category_expanded.jpg\" alt=\"This image has an empty alt attribute; its file name is actions_excel_category_expanded.jpg\"\/><\/figure><\/div>\n\n\n\n<p id=\"block-9051305d-6498-40ed-aa0e-b956a6ac4255\">The first action we\u2019ll use is to launch Excel on your machine.<\/p>\n\n\n\n<p id=\"block-9b767d95-9d61-4b6d-bdec-b9196eee7c8f\">This action will launch a new instance of Excel, regardless if you already have a spreadsheet already open or not.<\/p>\n\n\n\n<p id=\"block-bd3655cc-f706-4e36-9e1a-4c874fd09071\"><em>It\u2019ll be less confusing for you now if you close any instances of Excel that are currently running.<\/em><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"block-51000adf-c158-45e5-832d-a17e8c13e106\">Choose \u201cLaunch Excel\u201d<\/h3>\n\n\n\n<p id=\"block-e51f0f7a-1bbe-43a2-a543-ad8ef416020e\">Drag and drop \u201cLaunch Excel\u201d into the Main window in the editor.<\/p>\n\n\n\n<p id=\"block-5fbfa991-31d2-4d93-b716-521c9b78413b\">You will see a pop-up window that allows you further control over when Excel opens. For our tutorial, leave all the defaults.<\/p>\n\n\n\n<p id=\"block-4fc839f9-0c03-4d98-a76a-6ffaae0f7f9a\">This will result in Excel launching with a blank worksheet.<\/p>\n\n\n\n<p id=\"block-c288b54d-464b-4aa0-85fd-df6ec23d6e3f\">Now we want to do something useful with this worksheet.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"block-0690a747-8d52-4d22-b7a7-f0d4b513951a\">Write to the worksheet<\/h3>\n\n\n\n<p id=\"block-9ff6c9b3-50e7-45d3-bb95-3e52e9418a17\">Drag and drop \u201cWrite to Excel worksheet\u201d into the editor as the next action.<\/p>\n\n\n\n<p id=\"block-31b9634c-001b-413b-877c-0835a2d33132\">We\u2019re going to keep things simple in the pop-up window.<\/p>\n\n\n\n<p id=\"block-a623950f-c886-4396-beb2-01f31a3d2796\">I simply want to write \u201cHello World\u201d into the first cell of the spreadsheet.<\/p>\n\n\n\n<p id=\"block-9e92a593-c59c-4507-becb-1fcef7ce5e55\">To achieve this, type into three input boxes:<\/p>\n\n\n\n<ul id=\"block-a74e114c-e81b-42ef-8600-7956c6e7edc2\"><li><em>Value to write:<\/em> Hello World<\/li><li><em>Column:<\/em> 1<\/li><li><em>Row:<\/em> 1<\/li><\/ul>\n\n\n\n<p id=\"block-43550cd6-9564-4987-ae6e-ae2436fdee2f\">Check the picture below to see exactly what we\u2019re putting where.<\/p>\n\n\n\n<p id=\"block-133292c2-33ee-40fe-8e63-6fcd6649c157\">Leave the other input boxes unchanged and click the \u201cSave\u201d button.<\/p>\n\n\n\n<div id=\"block-bd9bedeb-2032-4052-8cab-9ff4cdf6e389\" class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/boyneanalytics.com\/wp-content\/uploads\/2021\/10\/actions_write_to_worksheet.jpg\" alt=\"This image has an empty alt attribute; its file name is actions_write_to_worksheet.jpg\"\/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"block-9cfe3659-11a1-428b-a46b-0decdf2b9a5b\">Testing what we\u2019ve got so far<\/h3>\n\n\n\n<p id=\"block-1b5ed908-935c-4023-a48c-f40f3999c96f\">At this point, you can test what you\u2019ve done so far by running the flow.<\/p>\n\n\n\n<p id=\"block-76546f43-e30e-4465-9a07-631914651525\">When you hit the play button in the top bar, keep an eye on the bottom taskbar in Windows. You\u2019ll see the Microsoft Excel icon appear, as it is launched by your flow.<\/p>\n\n\n\n<p id=\"block-ca674ebf-4fc7-43aa-a82b-c1580a48f015\">Unless you quickly minimize the PAD editor, you may not see the flow actually writing on the spreadsheet.<\/p>\n\n\n\n<p id=\"block-5cecde62-00cd-4441-be10-4dfbcb38111c\">But you can switch from the editor to Excel and you should see what\u2019s shown in the picture below.<\/p>\n\n\n\n<div id=\"block-95a7aba5-6ea1-4b49-bed3-083547513b23\" class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/boyneanalytics.com\/wp-content\/uploads\/2021\/10\/test_open_worksheet_with_hello_world.jpg\" alt=\"This image has an empty alt attribute; its file name is test_open_worksheet_with_hello_world.jpg\"\/><\/figure><\/div>\n\n\n\n<p id=\"block-21230552-8533-4745-9d36-a1fe3cd8665f\">I\u2019ll call out two points.<\/p>\n\n\n\n<p id=\"block-1ac18208-266e-4928-a7b8-0b4c8206969b\">This is a new instance of Excel with an unsaved workbook. So, the focus is on Sheet1 of Book1.<\/p>\n\n\n\n<p id=\"block-6a0121e2-e881-4e43-82d3-ff1721c81fb6\">The second point is that \u201cHello World\u201d has been written into the first cell of the worksheet. That is exactly what we specified.<\/p>\n\n\n\n<p id=\"block-265c7a4b-1ef5-4bb7-81c7-9d552cd00e48\">We ran this flow without an action to close Excel. So the spreadsheet is left open for us to peruse. That\u2019s quite useful to check that we\u2019re on the right track.<\/p>\n\n\n\n<p id=\"block-b20e4e9b-de3d-446f-95f2-0119ca5c30ea\">But we do want to save the spreadsheet. So, let\u2019s move on to add the final action.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"block-a831edee-cc80-443f-97b3-0f614167be90\">Save and close the Excel file<\/h3>\n\n\n\n<p id=\"block-aea4aff5-87d5-4de1-9b47-eefba636b057\">Our final step is to save and close the file.<\/p>\n\n\n\n<p id=\"block-8c20f6a0-1309-46e2-97b0-18d2fee8f955\">You\u2019ll see an action under the Excel category for both \u201cSave Excel\u201d and \u201cClose Excel\u201d.<\/p>\n\n\n\n<p id=\"block-82e34aff-f8e8-490d-98c1-010e930f3b9f\">We could use both actions to save the spreadsheet first and then close it. But we can do what we need with a single action.<\/p>\n\n\n\n<p id=\"block-55b55887-b11f-4de5-bb36-82221b8e2017\"><strong><em>Drag and drop the \u201cClose Excel\u201d action into the Main flow.<\/em><\/strong><\/p>\n\n\n\n<p id=\"block-b0318cc7-a153-4d59-85e4-5d6b2f9d1ed4\">The default parameters for this action are to close the spreadsheet without saving it. We want to change this!<\/p>\n\n\n\n<p id=\"block-116581d5-58ba-484a-ace4-2815521ae767\"><strong><em>Expand the dropdown for the closing parameter and switch to \u201cSave document as\u201d.<\/em><\/strong><\/p>\n\n\n\n<div id=\"block-b054c3b8-f3d7-44c2-8182-2aef2bdc62e8\" class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/boyneanalytics.com\/wp-content\/uploads\/2021\/10\/actions_excel_save_as.jpg\" alt=\"This image has an empty alt attribute; its file name is actions_excel_save_as.jpg\"\/><\/figure><\/div>\n\n\n\n<p id=\"block-ff5d9de4-0ee2-43fe-bcb9-4fa8e1b2cc14\">This will open two new parameters. The first allows you to set the extension. You can leave it as the default.<\/p>\n\n\n\n<p id=\"block-1715e297-c43b-4b2a-8d16-c36049eba1be\">The second parameter lets you input a full file path and name (you don\u2019t need to include an extension).<\/p>\n\n\n\n<p id=\"block-dfa5c6b4-4c53-41a3-87cf-cfa5c93cd70c\">I set my document path to: \u201c<strong>c:\\users\\public\\hello_world<\/strong>\u201d.<\/p>\n\n\n\n<p id=\"block-1ef274cc-772d-4045-a132-2373be712b8e\">And that\u2019s it!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"block-4f601541-a447-4815-ad76-ea752df42128\"><span class=\"ez-toc-section\" id=\"What_The_Completed_Flow_Looks_Like\"><\/span>What The Completed Flow Looks Like<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p id=\"block-54056ce1-c2a0-4cac-bb97-55e98df18dec\">This picture shows what your full flow should look like.<\/p>\n\n\n\n<div id=\"block-e4be1f17-fae7-480a-b361-49830ceb93e5\" class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/boyneanalytics.com\/wp-content\/uploads\/2021\/10\/main_flow_completed.jpg\" alt=\"This image has an empty alt attribute; its file name is main_flow_completed.jpg\"\/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"block-85b6a38c-d942-4773-b89f-1e55e201497c\"><span class=\"ez-toc-section\" id=\"Run_The_Full_Flow\"><\/span>Run The Full Flow<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p id=\"block-c96547bd-7e8b-4251-8306-4794dae348ec\">When you click the run button, you\u2019ll be forgiven for wondering if anything has happened.<\/p>\n\n\n\n<p id=\"block-f8c236fb-7e05-458a-84da-906bad9ea016\">This is because the Excel application has a very simple and quick task to perform before it closes itself. You may see the Excel icon appear in the taskbar at the bottom of Windows, but it will only be there for seconds.<\/p>\n\n\n\n<p id=\"block-1f4acc98-502e-48e8-8dfa-af12b8a0e9d4\">To verify that the flow has done what you expected, open the folder where you specified the file to be written.<\/p>\n\n\n\n<p id=\"block-2ba4854c-6e74-444d-917c-c08daf1d4b30\">There should be an excel file with the name you specified in this folder. And its contents should contain the text \u201cHello World\u201d in the first cell.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This quick tutorial shows you how to use Power Automate Desktop to create and save an Excel spreadsheet. You\u2019ll learn how to use Power Automate Desktop to: Launch Excel on your local machine Create a new Excel workbook Write content to a worksheet Close and save the Excel file to a specific location Prerequisites You … <a title=\"Power Automate Create Excel File (Tutorial)\" class=\"read-more\" href=\"https:\/\/bandittracker.com\/create-an-excel-file-with-power-automate-desktop\/\" aria-label=\"More on Power Automate Create Excel File (Tutorial)\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[24],"tags":[],"_links":{"self":[{"href":"https:\/\/bandittracker.com\/wp-json\/wp\/v2\/posts\/655"}],"collection":[{"href":"https:\/\/bandittracker.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bandittracker.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bandittracker.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bandittracker.com\/wp-json\/wp\/v2\/comments?post=655"}],"version-history":[{"count":4,"href":"https:\/\/bandittracker.com\/wp-json\/wp\/v2\/posts\/655\/revisions"}],"predecessor-version":[{"id":802,"href":"https:\/\/bandittracker.com\/wp-json\/wp\/v2\/posts\/655\/revisions\/802"}],"wp:attachment":[{"href":"https:\/\/bandittracker.com\/wp-json\/wp\/v2\/media?parent=655"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bandittracker.com\/wp-json\/wp\/v2\/categories?post=655"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bandittracker.com\/wp-json\/wp\/v2\/tags?post=655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}