Different Table widths for multiple tabs in excel using Reporting Tool

[SH_94]

Dear Community,

Currently , i am using the Reporting Table tool to output reports to Excel. They can have multiple tabs, and the width of the data on each tab is different.  When Rendered to Excel, all the tabs have the same width -- so the narrow data stretches out and is not very readable.

I have tried adjusting the settings on the Table tool (Fixed width), on the Layout tool (fixed width), and the separate tables look good on their own.  But it seems like the Render is a Procrustean bed, and chops them or stretches them all to the same size.

Is there any way around this? 

Many thanks for your assistance

[atcodedog05]

Hi @SH_94 

You are getting the same size because the table width is set in the render tool configuration of page size

I am not sure about there is a options where widths can be flexible. 

Hope this helps 🙂

[IraWatt]

Hey @SH_94,

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

[IraWatt · Accepted solution]

Hey @SH_94,

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