How to autofit column in output files

[prpanw]

Hi Folks,

I am stuck with autofit formating in output files. I have a workflow where I am generating 100 of excel files but issue is column width is not autofit.

Can anyone help me to how to autofit column for all the 100 excel file.

[lwolfie]

What are you currently try to use?  Render? Output tool? 

[prpanw]

my workflow has been completed and excel files also saved at outpur folder but now how to autofit all the columns for each excel file

[Deano478]

If you already have output files then you can just use VBA

[prpanw]

I know that we can do it through VBA but I want to do this in Alteryx becaseu I have to share email as well and will scheudle the workflow so it will run itself

[lwolfie]

I was asking what tools you used, because there are some options based on the approach you used.  

For instance, if you use an output tool and the files are the same, you could use a Blob Input/Output option, which would have the columns set up.  You could also use the render tool which has the option at the bottom to select paper size and then it will space it accordingly.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Auto-fit-width-for-extra-wide-...

[prpanw]

I have output tool to save excel files.

[lwolfie]

I would try the Blob tools then.  The key is making sure these run before the rest of your workflow. 

Check out these links below

https://community.alteryx.com/t5/Engine-Works/Excel-Templates-with-Blob-Tools-and-Control-Containers...

https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/...