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

Report: OUTPUT in Excel bold headers and lines

neromerob
10 - Fireball

Hello to everyone. 

 

I have try to produce a report into an Excel file but I´m having problems with with.

this is what I need.  

 

DUMMY_SUMMA.jpg

 

Don´t know exactly how to configure the bold headers and the lines considering that every new month is going to be attached to this report 

4 REPLIES 4
CarliE
Alteryx Alumni (Retired)

Hi @neromerob 

 

Attached is the workflow. In the table tool, you can modify the default table settings to bold headers etc. It gives this output:

CarliE_0-1655221546588.png

 

As for alignment, make sure to change the alignment on each field to Center including dynamic or unknown fields -- this will allow new fields to come in dynamically with center alignment

CarliE_0-1655221783000.png

 

If this solved your problem, please mark it as a solution!

 

Thanks

Carli
binuacs
21 - Polaris

@neromerob one way of doing this

 

binuacs_0-1655221244693.png

 

 

Adrian_T
Alteryx Alumni (Retired)

Hi @neromerob,

 

You would not require the Layout Tool. Here is where you can find the settings in the Table Tool:

 

To set up borders for your table:

Adrian_T_1-1655221357578.png

 

To bold your header row:

Adrian_T_2-1655221425770.png

 

To justify your headers to center-aligned:

Adrian_T_3-1655221537461.png

 

Hope this helps! 🙂

neromerob
10 - Fireball

It worked. 

Thank you. 

 

 

Labels