Can report width tailor made for each tab using the Render tool?

[JokeFun]

In my case, I have several data streams that are finally exported to one workbook in different sheets. The number of columns vary from 2 to maybe 20 for each sheet. I use the Basic Table to list each of streams and then combine all report by the Union tool before it goes to the Layout tool and then finally the Render tool.

Currently I have to select the Paper size as A3 Landscape to cater for the widest sheet. But in this case, the sheet with only two columns will have a too long column width.

So I am just wondering if each sheet can have the columns auto-fit by the cell content?

[TrevorS]

Hello @JokeFun 

Thanks for posting to the Community!

I believe you are limited to a one-page size for the whole workbook w/ the Render tool.

One thing you could try is to pre-format the excel file with the widths you want on each tab and check the box on the output tool to write the data to a specific range of cells... (instead of using the render tool)

I hope this helps!

[kitkat]

I have same question.  While being an interesting idea, the range option is only available for the Output tool and not the Render tool that is being asked.