How to append the data to excel without changing it's formatting?

[akshayhendre]

Hello All,

Is it possible to write to the excel sheet without changing it's formatting?

Attached file has two sheets, template and output, actually both are the different files at different locations.

Output sheet is a result of some workflow and template is the standard format in which I have to present the data, currently I am manually pasting the output to template sheet.

Is there a way in Alteryx to automate this manual task?

Thank you

[DavidP]

Hi @sarahkelly.

I just noticed that I never got back to you on this. Is this still a problem? If so, I can try to replicate.

[DavidP]

Hi @jemjem,

This functionality only works if you write to a specific range, which means you can only do it for one sheet at a time. I guess, it would be possible to be clever and update the range with a batch macro if you really want to.

[jemjem]

Yes, I still haven't figured it out. I haven't used batch macros before. If you can provide some guidance, I would appreciate that. Thanks

[sblanchard]

how do I set up conditional formatting in the Table Tool for column rule to format as percentage?