Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Copying Formatted sheet from one Excel workbook to another

Alt_eryx22
7 - Meteor

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.

2 REPLIES 2
OTrieger
12 - Quasar

@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.

Alt_eryx22
7 - Meteor

Then I would just have the same problem in reverse.

Labels