Excel Layout different from Alteryx layout

Hello all,

I am a newbie with Alteryx so, forgive the basic question. I have structured the layout in one way and it is fine when I export it in PDF format. However, when I export it in Excel, the layout is drastically different. Any ideas?

Thank you

Stefano

2.pdf

1.pdf

Reporting

Settings

Output

Common Use Cases

Accepted answers

atcodedog05

Hi @sdemichelis

2.pdf is your excel output. You might want to check the print options why you are getting in a page. Usually there is options in print options to use page layout and fit. Page Layout & fit to page is default approach Alteryx takes.

Hope this helps 🙂

All comments

bharatandalam

Hi @sdemichelis

I find the attachments have no difference in the data except for the spacing... are you pointing out to spacing?

Thanks

Bharat

atcodedog05

Hi @sdemichelis

The difference i see is

1. Table borders: this can be removed in table tool default settings.

2. Column width: this can set to fixed in table tool column settings.

3. Layout width: possibility the page layout is not wide enough. You can set this is render tool below options. You can also set the page layout to horizontal.

Hope this helps 🙂

sdemichelis

Hi Bharat,

the formatting (i.e. lines and columns delimiters) is different between the layout within Alteryx and the Excel file

Hope this helps.

Best,

Stefano

sdemichelis

Hi atcodedog05

I am just baffled by the difference between the table formatting (lines and dividers/borders) in Layout vs Excel.

Not sure why

sdemichelis

the problem is the other way around. The layout in Alteryx is way better than the output in Excel and I wonder why the formatting disappears when I export in Excel (PDF export is perfect)

atcodedog05

Hi @sdemichelis

Hope this helps 🙂

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703