Render Multiple Excel Sheets with different sizes

Question

I have a report that I output to Excel through a Render.

When rendering some of the columns are truncating and losing some of the information. To stop this I have changed the paper size to custom, however I only want one of the sheets on my output to be the custom format, the other two I would like to remain as letter.

Is this possible?

Thank you,

Lauren

IraWatt · Answer

@atcodedog05 that is very weird, the only way I can replicate that is by filling the Report Text tool black. I would guess it would have to be a Alteryx or Excell version issue?

If you add a browse tool after the report text tool do you have any indication it is black here or here?

atcodedog05 · Answer

Hi @IraWatt

Surprisingly for some reason, I am getting the padding as a black box when I run your workflow. Any thoughts on that?

IraWatt · Answer

Hey @Lauren_Holmes,

Here is an example workflow described by @atcodedog05:

This method I found from this post:

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

Mulit Tab with Different Table Size Render.yxmd