topic Render Tool - column width on excel files in Alteryx Designer Desktop Discussions

Render Tool - column width on excel files

olimpio — Thu, 10 Feb 2022 03:41:38 GMT

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

Re: Render Tool - column width on excel files

Qiu — Thu, 10 Feb 2022 04:07:11 GMT

@olimpio
Can you try to look at these settings?

Re: Render Tool - column width on excel files

binu_acs — Thu, 10 Feb 2022 07:26:38 GMT

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

Betreff: Render Tool - column width on excel files

AlexEntz — Thu, 10 Feb 2022 07:33:28 GMT

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-output-Macro-attached/m-p/897907

Re: Render Tool - column width on excel files

olimpio — Thu, 10 Feb 2022 08:37:43 GMT

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

Re: Render Tool - column width on excel files

olimpio — Thu, 10 Feb 2022 08:40:19 GMT

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?

Re: Render Tool - column width on excel files

olimpio — Thu, 10 Feb 2022 09:40:51 GMT

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.

Re: Render Tool - column width on excel files

binu_acs — Thu, 10 Feb 2022 09:45:55 GMT

@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-p/5266

Re: Render Tool - column width on excel files

olimpio — Thu, 10 Feb 2022 11:41:48 GMT

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