web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Copy excel sheet to an...

Power Automate

Answered

Copy excel sheet to another workbook

(0) Share

Report

Report

Posted on by JeanPaul

32

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!!!

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (1)

Report
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

Was this reply helpful? Yes No
MW-21041403-0 32 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Suggested answer

takolota1 4,974 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No

Join the conversation