Text Wrapping in Excel

Question

I have a excel output on which i write records from alteryx file. I have enabled wrap text option in my excel but when the alteryx adds data on to the excel file, the formatting is lost.

I have applied certain other formatting such as dollar symbol for values which gets retained but not the wrap text. I can't use a render tool.

Is there a trick to do it through excel or some specific function in alteryx?

CathyS_Slalom · Answer

@rajat_del You also can use the python tool from Alteryx to format your recent generated excel file the way you want.

https://xlsxwriter.readthedocs.io/format.html

Qiu · Answer

@rajat_del 
Have you try to turn on the option "Preserve Formatting".
It works on my side if we preset the template target cell as "Wrap Text"

0315-rajat_del.yxzp