Text Wrapping in Excel
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
rajat_del
7 - Meteor
‎03-14-2022
09:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Labels:
- Labels:
- Tips and Tricks
2 REPLIES 2
21 - Polaris
‎03-14-2022
09:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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"
CathyS_Slalom
9 - Comet
‎03-15-2022
10:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@rajat_del You also can use the python tool from Alteryx to format your recent generated excel file the way you want.
