Render Tool - column width on excel files

[olimpio]

Hi everyone,

i am trying to use the render tool to output data to an excel file however, the column width of the cell get really constricted.

is there any solution to fix the issue.

i have tried adding a table tool prior to the render and tried different combinations on the paper size and table width with no fix.

any assistance would be greatly appreciated 

[Qiu]

@olimpio 
Can you try to look at these settings?

[binuacs · Accepted solution]

@olimpio Change the Render tool paper size to custom and adjust the size

[AlexEntz]

Hello,

if the other two answers don't work for you, I recently wrote a macro that autosizes excel columns: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-Autosize-columns-in-excel-outpu...

[olimpio]

Hey, i tried changing the paper size, to custom but it still constricts the columns, is there any changes to be done in the table tool, there are around 200 columns in the output i'm rendering

[olimpio]

Hi there are 200 columns in the actual output, the one i posted was just to provide a view of what happens to the columns when it renders. on the cell and column padding do i need to anything specific?

[olimpio]

One point i forgot to mention is , in the workflow the input is a query that runs and returns around 200 + columns.

Questions:

1. Is it because data is being queried the table size shrinks?

2. is there any adjustment in the table or render tool that could help fix this?not sure what im doing wrong.

[binuacs]

@olimpio Can you check the post and see you are facing the same issue?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Weird-Excel-Headers-using-Reporting/td...

[olimpio]

hey thanks alot, this helped

i changed the size in field to 500x500 and it works fine now.. i will play around with it but this helps me thanks