Copying Formatted sheet from one Excel workbook to another

Question

Hello, I'm building a, Excel template (output) and want to copy a formatted sheet from one Excel workbook into another already-established workbook. Normally to duplicate entire Excel files I use a blob tool, but it seems I can't use a blob tool to copy just a sheet from one workbook to another. Does anyone have any tips how to do this?

E.g.: I'd like to copy 'Sheet1' from the attached "Input File.xlsx" to the attached "Output File.xlsx" as a sheet named 'Table 5', preserving the table formatting/style.

Also included: workflow example with blob tool errors to help give context on my attempt/thought process.

New Workflow4.yxzp

Output File.xlsx

Input File.xlsx

Alt_eryx22 · Answer

Then I would just have the same problem in reverse.

OTrieger · Answer

@Alt_eryx22

What you can do, if you will always going to use the same excel sheet, you could create that template sheet as a stand alone file, write it out with Blob and then add the rest of the sheets to it, in that you will manage to do it.