Basic Table tool column widths are ignored when rendering to Excel

[Newt]

I am using the Reporting tools with a basic table with six columns that I have been rendering to Excel.

I want to group some columns, so that it is clear that material in columns 3 and 4 go together, and material in columns 5 and 6 go together.

I have the table width fixed at 7.5 inches.  Each of the columns is fixed width.  But no matter how I fiddle with the fixed width of each column -- making 3 and 4 to be 1.1 inches each and column 5 much wider (2.8 inches) to push it way from 3 and 4, nothing changes in the Excel output.

Column width changes DO affect rendered Word output, just not rendered Excel output.

Is there a workaround?  One person (@markalves) who tried inserting blank columns found they were being compressed down to a few pixels wide.

Thanks!

[mceleavey]

Hi @Newt ,

This is, unfortunately, yet another problem with Excel (stop using Excel!!), but the workaround may be to create a template in Excel and populate the pre-formatted ranges with the raw data from Alteryx. You can output to ranges by specifying cells in the output string, for example:

C:\Users\<username>\Desktop\Excel Example.xlsx|||'Test1A1:A3'

M.