Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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