Preserve Formatting on Output

Hi,

I have specified the range and selected preserve formatting in my output, however the formatting for the borders on Col C was removed each time i run the workflow.

How can i preserve the borders formatting in my output with the attached workflow?

2145 (1).yxmd

Tradeblotter_06282024_ALT.xlsx

Output

Accepted answers

lwolfie

You could try using the Blob tools discussed in this article.

https://community.alteryx.com/t5/Engine-Works/Excel-Templates-with-Blob-Tools-and-Control-Containers/ba-p/1148262

Essentially, you set up the template and use a blob input tool, tell it where to save the template to and then follow it by the blob output tool, at the beginning of your workflow.

You then output to that saved template.

All comments

Raj

@JCTAN
please provide the workflow in zip format or add another input as well.

JCTAN

attaching another input, thanks

June 2024 Affirm Confirm_ALT.xlsx

JCTAN

Hi @Raj, i've attached another input, thanks

lwolfie

You could try using the Blob tools discussed in this article.

https://community.alteryx.com/t5/Engine-Works/Excel-Templates-with-Blob-Tools-and-Control-Containers/ba-p/1148262

Essentially, you set up the template and use a blob input tool, tell it where to save the template to and then follow it by the blob output tool, at the beginning of your workflow.

You then output to that saved template.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703