Retaining excel formatting in output

Question

I need to fill out an excel template based on workings information in another (so copying and pasting from the workings into the template).

However the template has some formatting that needs to be retaining for visual purposes as it's being sent externally.

From my experience so far, Alteryx doesn't retain any formatting in final outputs. Is there anyway around this? It's a one tab file.

messi007 · Answer

@kcoleman,

Yes to use this option you have to have a fixed cell.

Hope this helps!

Regards,

kcoleman · Answer

Thank you. That doesn't seem to be working for me just yet, but I am having trouble with my initial workflow.

What would be the best way to approach this - copying cells from one excel file to another? It's not a range, it's quite random.

So say B1 always must go to D4 in the template, B2 must go to E6 etc.

messi007 · Answer

@kcoleman,

You can use preserve formating on the output tools :

Best Regards,