Hi everyone, Is there a way to format an Excel output file? I wanted to do the following on my output file: * column heading to be bold and highlighted with different color * set column width for each columns * set column height * wrap text * freeze column and rows Happy holidays and thank you for your help. -Florence Lorenzo

Hi @DivRK, If it makes you feel any better, I am also still having the same issue...when overwriting an existing sheet, only the columns unaffected will keep the original formatting of the excel sheet. If you found a solution to this, please let me know :)

Hi, Render tool only overwrites a file. It will not append an existing sheet or over write an existing sheet. Any formatting solution for that? Keeping the original format is not helping my output. it is keeping the original format only for columns that are not getting updated. Thanks

Formatting Excel Output File

fjlorenzo

Hi everyone,

Is there a way to format an Excel output file? I wanted to do the following on my output file:

column heading to be bold and highlighted with different color
set column width for each columns
set column height
wrap text
freeze column and rows

Happy holidays and thank you for your help.

-Florence Lorenzo

Output

Accepted answers

All comments

Christine_Assaad

Hi @fjlorenzo

You can create your own template and configure the Output to write to this template while preserving the format. Please refer to screenshots below. Cheers!

pedrodrfaria

Hi @fjlorenzo

If you are trying to create this formatting inside of Alteryx to then output to an excel file. I answered your questions below and added a workflow for education purposes. You will have the option of setting up a template and using it as well as an output option while keeping the template formatting.

column heading to be bold and highlighted with different color

set column width for each column

set column height

I'm not really sure what you mean by this, would it be row height?

wrap text

This is something Alteryx does automatic when using the reporting tools

freeze column and rows

If you are talking about freezing as in excel, it is not an option.

Pedro.

New Workflow16.yxmd

fjlorenzo

Thanks @christine_assaad and @pedrodrfaria. Can you give me a sample workflow.

BGeregach

Christine Assaad,

What if the length of one of my columns changes. For example, one column is a list of store names and I open a new store. Or for that matter, close a new store.

Brian

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703