Render Multiple Excel Sheets - Different Size

[oliver_sayers]

I have a report that I output to Excel through a Render. I have selected A3 for size. I would like one of the sheets to not be A3, I would like it a different size.

Is this possible?

Thanks,

Oliver

[KaneG · Accepted solution]

Hi Oliver,

Can you use a block until done and output through 2 render tools? Like below,

Kane

[kpmike]

Hi, I'm trying to use this solution, but i'm having trouble naming the individual sheets.  I end up just having the second render overwrite the first render file.

[KaneG]

Hi @kpmike,

You will need the output file in the 2nd Render Tool to point to a different file.

[kpmike]

Hi @KaneG, thanks for the quick reply.  So just to confirm, it's not possible to render two different sized sheets in the same excel file?

[KaneG]

Sorry, I misunderstood.

I cannot find a way currently as you can't specify Sheet names directly. the only way to specify sheet names would be through a Layout Tool before the Render with a Grouping Field, however the 2nd Render still overwrites the first File rather than adding another sheet.

I do advise adding your vote with comment to this idea though... https://community.alteryx.com/t5/Alteryx-Product-Ideas/Render-Tool-Output-Multiple-Tabs-to-One-Excel...

[KasiaP]

Hi, I have the same problem as you describe here.

I am trying to set different page sizes in one excel workbook, but unfortunately with no success.

Did you manage to find any solution?

[PoojaSingh88]

same issue . I need to append tabs using two render tool.However the second render output overwrites the first.

Is there a way around this

[IraWatt]

Hey @PoojaSingh88 

Here is one round about way of doing this by adding some white space:

This method I found from this post:

Solved: Can't change column width when Unioning two tables... - Alteryx Community