Can one Render tool to write into multiple sheets with different paper sizes

[LAPONNEKANTI]

I'm trying to write multiple sheets into a single Excel workbook using the Render tool. When the same paper size is applied to all sheets, those with fewer columns appear too wide and spacious, while others with more columns look well-balanced.

Is it possible to:

1. Use different Render tools for each sheet and still write them into one workbook?

2. Adjust paper size or scaling individually for each sheet?

   
   
   Any alternative solutions or workarounds to handle this formatting issue are also appreciated.
   Thanks

[binuacs]

@LAPONNEKANTI I don't think 1 and 2 are possible with the Render tool, Each Render tool can only write one report (one sheet) per output file. If you try to write multiple Render tools to the same Excel workbook, the last Render tool will overwrite the file unless you use a workaround. 

Workaround would be to create two separate Excel files using 2 different render tool then with the help of python combine both the excel files into one.

[CharlieS]

The workaround I've used before is to use empty blocking tables to shrink down the column widths on the sheet that doesn't need as much paper size. After you build your workflow/rendering process to the largest table/paper size, you're left with other sheets with larger than desired column widths. On the sheet you'd like to be more narrow, layout blank tables on the right to add columns which will shrink all column widths. 

[Qiu]

@binuacs 
FYI　😁
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Render-to-multiple-tabs-in-1-e...

[LAPONNEKANTI]

 Can you please elaborate how we can add the blank columns 

[Dhrish]

@LAPONNEKANTI Just use formula tool and add a column with "" as string this will give you the blank columns