Render tool to specific Excel sheet

[Newt]

I would like to use the Basic Table and Render tool to output a specific named sheet in a named Excel file.

Whenever I try to use the "File.xlsx|||SpecificSheet" format in the Render tool, it tells me that is not a legal configuration.

I've tried to trick of inserting a Vertical Layout with Section breaks, and specifying the Sheet name in one of the fields going into the Layout tool...  and this does create an Excel file with the specified Sheet name.

BUT it also wipes out any previously existing sheet.

The standard Output tool allows a specified Sheet, and just adds that to the workbook, along with whatever sheets existed in the workbook previously.

Can I Render a pretty Excel output into a workbook without wiping out all the previously existing Sheets?

Thanks.

[PangHC · Accepted solution]

Excel Templates with Blob Tools and Control Contai... - Alteryx Community

you can refer to above link. where it more flexible and simple. 
mainly to manual prepare the excel template and just use it. 

pros:
-no need to do anything in color/bold/font size

-can add data via input tool

-can simply add new sheets.

-can use pivot table.

cons:

-no idea why sometime it not copy background color/format from rows about.

-but it might problem when your version is do not have control container. you need to play around the block until done to ensure it copy before your output tool.

[apathetichell]

Hey --- so a few things.

1) render format is filepath only... no sheets. sheets are set up by a layout tool.

2) there are substantial resources on this community for how to use Render without going crazy but the short is --- if you use a render tool to create a file --- it overwrites the existing file. If you use a render tool twice (or more)  to write to the same file --- in a single workflow --- it will keep overwriting that file.