This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
There's not a way for Alteryx to make the columns wider in Excel using a normal Output tool. However, what you can do instead is to specify a range that Alteryx should write to. This case, it wont overwrite the entire sheet, rather, overwrite the contents within the range you specified only. Since the sheet is technically not deleted, it'll retain the column/row sizes that are currently established in the sheet.
To do this, modify the file path of your output tool by adding the cell range. For example, C:\directory\outputfile.xlsx|||Sheet1$A1:Z100. Change the bold part to whatever range works for you. if you want it to overwrite all contents of the sheet, you can specify A1:XFD1048576,
P.S. If you use this method, make sure to change the "Output File:" in the Render tool to the full path. In my example I just put "sample.xlsx". Also, you will probably need to play around with the settings in the Table tool until you get it just right.