Power Automate - Building Flows

Copy excel sheet to another workbook

Like (0) Share

Report

Posted on 18 Jan 2024 21:37:38 by JeanPaul

Hi,

Is it possible to just copy one Excel sheet to another workbook?

I have built some basic workflows in the online version, but this is my first time with Power Automate Desktop.

Why am I thinking about this option? because I need the whole sheet, not just a selection of cells or a table.

Any ideas? Thank you!!!

All responses (3)

Answers (1)

Suggested answer

takolota1 4,863 Super User 2025 Season 1 on 23 Apr 2025 at 00:34:11

Like (0)

Report

Copy excel sheet to another workbook

If you have access to Azure there are ways to do this with Azure Functions like in this template: https://community.powerplatform.com/galleries/gallery-posts/?postid=a5255ced-dc08-f011-bae3-6045bdf03fcb
MW-21041403-0 32 on 21 Apr 2025 at 14:49:27

Like (0)

Report

Copy excel sheet to another workbook

Hey there!

I'm new to power automate and have been having difficulty getting an excel sheet to copy to another workbook in the online version. Would you mind sharing your workflows?

Thank you!
Verified answer

v-xiaochen-msft on 19 Jan 2024 at 01:47:25

Like (1)

Report
Re: Copy excel sheet to another workbook

Hi @JeanPaul ,

Please try this

Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\Administrator\\Desktop\\Test1.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\Administrator\\Desktop\\Test2.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance2 Excel.SetActiveWorksheet.ActivateWorksheetByName Instance: ExcelInstance Name: $'''Sheet1''' Excel.CopyCellsFromExcel.CopyAllCells Instance: ExcelInstance Excel.AddWorksheet Instance: ExcelInstance2 Name: $'''tempSheet''' WorksheetPosition: Excel.WorksheetPosition.First Excel.PasteCellsToExcel.Paste Instance: ExcelInstance2 Excel.CloseExcel.Close Instance: ExcelInstance Excel.CloseExcel.CloseAndSave Instance: ExcelInstance2

Best Regards,

Wearsky