Preserve Formatting on Output

[JCTAN]

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?

 

 

[Raj]

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

[JCTAN]

attaching another input, thanks

[JCTAN]

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

[lwolfie · Accepted solution]

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...

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.