Auto-fit width for extra wide Table and Render outputs

[prezharr]

Hi!

I am currently using the Table, Layout and Render tools to output results from my workflow. There are multiple, different structured tables on different sheets of the output. One of which is very wide, and so the only way to output without corrupting has been to set a custom size paper at 55 inches wide. However, this then causes all the other tables (set to automatic width) to fill the size of the page, and so stretch out and look really weird. This doesn't happen when the paper size is set to one of the default sizes offered.

This appears to be a bug mentioned on a few other threads, but wondered if anyone has a fix.

Thank you!

[apathetichell]

There are three fixes here: 1) create an excel template file where you have prestructured your sheets. copy this file using blob input/output and write to range.

2) render all sheets first at a normal size to fix your report (thin) data. only create sheet names/single lines on your wide sheets. After creating all sheets in render use an output data tool to write over your wide sheets. This assumes your wide sheets are database types - and formatting is less key.

3) use some type of coding.