Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Color cells & then export these to an Excel file

sabidor829
7 - Meteor

Hi,

 

I know it is possible to conditionally format cells with color through Alteryx. 

 

My question to you is whether we can then export this to excel and have the colors move along with it?

 

Thanks,

 

Stephen

7 REPLIES 7
JosephSerpis
17 - Castor
17 - Castor

Hi @sabidor829 you can this post shows you can push the color into excel.

sabidor829
7 - Meteor

Thanks. Is there any reason why words are cut off after you generate a report ? Is there a way to stop this ? 

VianneyM
Alteryx
Alteryx

Hi @sabidor829,

 

which words are cut? can you add an screenshot to have a look? (Results and configuration of the table tool)

 

Best,

Vianney

Best,
Vianney
sabidor829
7 - Meteor

I was able to fix it. I had to readjust the table size in the report style.

 

Do you know if there is way to reorder columns in alteryx? 

VianneyM
Alteryx
Alteryx

hi @sabidor829,

 

You can do that on the table tool, you have within the Per column configuration the option to move the columns position (like the select tool)

 

VianneyM_0-1578579145069.png

 

Or you can also use the select tool for that

 

Best,

Vianney

Best,
Vianney
sabidor829
7 - Meteor

Thank you!

sabidor829
7 - Meteor

The solution that worked for me was the select tool option. Thanks. 

Labels