Free Trial

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
13 - Pulsar

@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
Top Solution Authors