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.
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
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.
