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.
@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.
Then I would just have the same problem in reverse.