Render Multiple Excel Sheets with different sizes

[jiawenmai]

I need to output multiple tabs into one excel sheet file. One tab has many columns so that I need to use custom size on the Render tool. Other few tabs have only a few columns. Then, for the tabs that only have only few columns, the width of their columns looks extremely wide/weird.

By browsing at many posts that have similar issues as mine in alteryx's community, one of them said "the render tool renders every tab to a page size which is specified in the render tool at the bottom. So it will make all tabs the same width, like pages of a report"  it's said that we can try to get around it by adding column to it? I am not sure how to do it.

I tried to play around with the custom side in Render tool. But still, it doesn't work well on me.

Can someone please give me some help/guidance on this? Thank you so much in advance!!

I attached a draft version below to show the problem I am experiencing now.

[lwolfie]

I played with the settings a little, so look at the attached.  I set the layout to be landscape and legal, instead of custom.  I also changed formatting to be automatic, so it appears to do what I think you are trying to accomplish.  

[nagakavyasri]

@jiawenmai Alternatively you can use Block Until done tool to write to same excel:

[jiawenmai]

Thanks for responding! If we have more columns on the excel's tab that exceed the size of "landscape and legal", is there any alternative way to accomplish it? 

[jiawenmai]

By using block until done, we will lost all the formatting tho.

[lwolfie]

Sorry, I'm not aware of one but someone else may know.  

[grazitti_sapna]

Hi @jiawenmai 
I have made Workflow for your Problem. Please Check.
If it works Kindly accept it as Solution.
Thanks