Text Transform to vertical in excel file output

[dkma]

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 :-

[mbarone]

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]

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