How to set the format for excel output to remain the wrap text after running alteryx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dear all,
I have the excel output which show the data obtained from Alteryx. For this excel, I would like to set the format for excel to be wrapping text. Thus, I decide to set the wrap text on excel file before running the alteryx workflow and I also select to preserve formatting on overwrite as shown in the picture.
However, after running the alteryx, the data is shown in the excel file but the wrapping text format is lost.
Please kindly suggest me about the trick to set the wrapping text format in excel output.
Thank you so much in advance.
Best regards,
Boontida P.
- Labels:
- Output
- Settings
- Tips and Tricks
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can use the python tool from Alteryx to format your recent generated excel file the way you want. In Output Data tool it will preserve the wrap text format for only those cells which were having data before overwriting and setting the format to wrap text.
https://xlsxwriter.readthedocs.io/format.html
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @Boontida
If you just like use output to excel and want to remain the warp text format,
1- you must set a excel sample file first.
2- set the cells format with warp text in sample.xlsx.
3- output data with select option with "Preserve formatting on overwrite".
