Freeze Columns and Every column Fit-to-Width&Height

[akvsachin]

In Alteryx, is it possible to configure the Render tool, Table tool, or any other tool to export an Excel sheet with a "Fit-to-Width" option?

For example, I want the column width to automatically adjust based on the cell contents (e.g., when some cells have around 200 characters while the column header has only 20 characters). Additionally, I’d like the row height to adjust to fit the font size of the cell contents.

I've attached a sample Excel sheet for reference.

[binuacs]

@akvsachin I don't think that is possible with the Render tool

[akvsachin]

Hi @binuacs ,

Is either of these scenarios possible in Alteryx when delivering the output?

Either Adjusting the widths or Height of rows or freezing the header row ?

[binuacs]

@akvsachin may be with the help of python script it is possible but not with the Render tool

[akvsachin]

Hi @binuacs ,

Somewhere I got this to solve the problem

"Create an excel template file where you have prestructured your sheets. copy this file using blob input/output and write to range"

Can you help me with this ?

[binuacs]

@akvsachin it is possible with pre-defined excel template using the blob tools, take a look at the below article, you can also find a sample workflow in there

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

[binuacs]

@akvsachin Here is the sample workflow attached

[akvsachin]

Hi @binuacs 

Apologies for the delayed response.

I'm currently facing an issue with overwriting the output file. While copying the template works perfectly, I need a way to overwrite it.

For instance, if I'm providing a different file dynamically, I want the prepared data to overwrite the template directly.

The error in Output Tools shows as : Unable to open file for write 'path\Sample_Output.xlsx' - Can't Open file 'path\Sample_Output.xlsx'

or "Specified range is not large enough for incoming data fields"

I'm writing to range of cells A2:AC4 for a total of 35R:29C