Optimizing Excel File Formatting Without Render/Table Function

I created a workflow that produces an Excel file containing multiple sheets. I want to change the background color of the header cells and adjust the cell width based on the text length, all without using the render/table function. When I use the render tool, my workflow takes more than two hours to generate the output file. Can someone help me with a solution?

Workflow

Output

Tips and Tricks

Best Practices

Dynamic Processing

Optimization

Database Connection

Accepted answers

All comments

Deano478

@adarsh2608 if you don't want to use the Altyerx tools one way would be output to a .xlsm file and have a macro in that file ready to run to this formatting once the output is generated

Raj

@adarsh2608
one way of doing this is using a pre generated excel template and using blob tools to replicate the template and writing data into it.

apathetichell

There are three ways:

1) Follow @Raj 's instruction.

2) create a VBA script. Run VBA script via command tool after creating your excel file.

3) Use Python.

@Raj's way is the only way to do this in Alteryx out of the box.

kkjain2904

Thanks

adarsh2608

Hello @apathetichell ,

I dont have technical skill to write python code , could you able to help me how to write to fix this

apathetichell

Not really how these community boards work. I'd recommend 1) and following the other solutions to that issue on this forum.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703