Adopt the same colors and row format from Input

Question

Hi Guys,

Is there a way to copy the same colors and the format of the rows (such as in Picture 1 in the attachment) 1:1? If i just insert it, Picture 2 comes out. Maybe with a tool or something? I couldn't find anything on the web, i'm sorry. Thanks in advance!

Best regards,

Christian

Picture 1.PNG

Picture 2.PNG

TheMattLeonard · Answer

The quickest/dirtiest way to accomplish what you want is to copy/paste the formatting from the input to your output just in excel once. Then in your output tool, add "$A1:$ZZ10000000" (or any other similarly large range, doesn't need to be exact to your data set). Make sure the box is checked for "Preserve formatting on Overwrite".

There are a couple other ways to do formatting by using Alteryx. The Table Tool (would not recommend here) and the Blob Tool (would maybe recommend) but those would take a lot longer to explain.

Rayyl · Answer

I also specified the range, but the result is, as i said, the same (see attachment). I just want to "reproduce" the excel file 1:1 as i inserted it. Including color and formatting.

Picture 1.2.PNG

Picture 1.1.PNG

alexnajm · Answer

You’ll have to give more information then about your configuration as it works fine for me! Remember if the original run removed the formatting, you’ll have to put it back