Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Text Transform to vertical in excel file output

dkma
8 - Asteroid

How to rotate the text of Headers in excel output file in Table render tool . 

 

 

Does anybody has any work arounf to achieve this. 

 

like :-

 

 

dkma_1-1641390072949.png

 

 

 

2 REPLIES 2
mbarone
16 - Nebula
16 - Nebula

You need to configure your Output Data tool using the Overwrite sheet option, preserve formatting, and most especially enter the range in the output string.  Look thoroughly at the Output Data Tool configuration in the attached module.

csmith11
11 - Bolide

@mbarone suggestion works very well as long as you have a more recent version of Alteryx. If his solution worked for you, please consider marking it as the solution so other community members can identify the solution faster.

 

If you have issues implementing the above solution because you are on an earlier version of Alteryx, Please see this discussion for alternative solutions:

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Writing-to-pre-formatted-Excel-in-spec...

Labels