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
It is not possible. All sheets will follow the set paper size. One workaround is to add blank columns as padding and get the required table to be displayed in the desired size (I,e sheet is in the paper size, table is padded to display in the required size)
Hope this helps 🙂
Ah ok, no worries!
Thank you for letting me know 🙂
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
Hi @IraWatt
Surprisingly for some reason, I am getting the padding as a black box when I run your workflow. Any thoughts on that?
@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?