output formatting

[TonyMu]

Hello, 

Is there a way to have the output put I am writing through the output tool bold, in italic, colored or underlined? 

I have a template which I would like to overwrite every sheet of it each time with a new set of records. 

cheers

[Emil_Kos]

Hi,

The easiest way would be creating a template in excel and keep it original formating.

There is a great post about it:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-do-I-output-to-an-Excel-templat...

There are also reporting tools available which will allow you to format the data. Please see a brief example in the link below:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Export-Data-to-Excel-with-custom-forma...

Please tell me what is your current use case and I will guide you more.

[AkimasaKajitani]

Hi @TonyMu 

This link @Emil_Kos  mentions does not seem to be applicable in xlsx files (because there is no "Delete Data and Append" option at xlsx type file.)

I also tried again but could not it.

This approach with the Blob tool will work with xlsx files as well.

https://intersectionsandoverlaps.wordpress.com/2019/09/27/alteryx-excel-templates-with-blob-tools/

[TonyMu]

Hello Emil_Kos, 

These links did not really help me 😞 

Here is my usecase:

I have som data in form of combination of text (header) and data (values). I want to write this data into excel. would like to for example have the header bold and some data rows in red.

Since I have an already existing excel file(xlsx) as a template which I want to fill with this data, render tool does not really work for me because I want to wite into a specific sheet already existing in my excel file withought changing formatting or sheet layout on the rest of the sheets. As I understood, render tool doess not support this functionality. 

Is there a way to fix this?  

[Qiu]

@TonyMu 
Since the recent version of Alteryx, we have the option of preserving the formatting.
But then your highlight certain rows of data will not be possible.