In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Text Wrapping in Excel

rajat_del
7 - Meteor

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?

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

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

CathyS_Slalom
9 - Comet

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

cathyshi525_0-1647365687086.png

 

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

Labels
Top Solution Authors