Producing one excel workbook with multiple tabs

Ash___123

Hi,

I have two questions about how to produce Excel workbooks with multiple tabs.

1.) Is it possible to produce one Excel workbook output with multiple sheets, which can be filtered corresponding to the desired sheet name.

2.) Is it possible to produce a workbook with your desired Alteryx output attached but has other tabs which DO NOT feed through Alteryx workflow. The other tabs will be used as document control and the formatting / formulas that exist in there are important. The other tabs will already be created and ready to be used as a blank template for the Alteryx output.

Both of these will be used in Alteryx apps but someone who is not familiar with Alteryx, nor will they have designer access, so ideally minimal user interaction is preferred.

Any help or guidance will be greatly appreciated.

Thanks!

markcurry

Hi @Ash___123 

I've just posted reply to a query about creating multiple sheets, see here : 

Create multiple sheets on the same excel file with... - Alteryx Community

Then on your 2nd query, yes this is possible.  You can have the Output file already created with existing tabs, and these won't be changed when your workflow creates\updates the sheets from your workflow.  

Hope that helps,