Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Adding Borders to Excel File using render tool

amaru1009
5 - Atom

Can anyone help me how do I add border in the excel output using render tool.

I'm not getting any border option in Style editor. Can anyone let me know correct way to create border in output excel file using render tool. Attached the snapshot of Style editor visible in my system.

2 REPLIES 2
carlosteixeira
15 - Aurora
15 - Aurora

Good morning my friend @amaru1009  how are you
You can do this using the RENDER tool right after the table tool. Format the table and then send it to the rendering tool, using the temporary XLS output.

carlosteixeira2005_0-1587998537671.png

 

carlosteixeira2005_1-1587998557449.png

The best way to include formats (colors, filters, etc.) in an excel output is using the Preserve formatting option of the Output tool.

 

3.png

 

In this way, you can color whatever you want in Excel, and each time Alteryx saves / overwrites the sheet, those formats will be respected.

The only requirement is that you type in a range (eg Sheet1 $ A1: XX15000)

Carlos A Teixeira
amaru1009
5 - Atom

It worked. Thank you so much

Labels