Adding Borders to Excel File using render tool

Question

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.

Render tool - Need to create border in excel.docx

carlosteixeira · Accepted Answer

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.

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

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)