Free Trial

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
Top Solution Authors