Reporting Tool: Multiple tabs in one excel file

Hi,

I have a workflow where the output should be one excel file with multiple tabs. Each tab represents different companies. All tabs should have the same formatting.

So far I have only managed to get either:

a) one big excel sheet with all the tables stacked ; or

b) output all tabs as separate excel files.

The only way I have been able to get multiple tabs in one excel file is through the output tool, but then I loose all the formatting I need that comes with the reporting tool.

Reporting

Output

Accepted answers

afv2688

Hello @mp2624 ,

Here I share you the way I do it:

You have to configure first each table. Then add a formula tool with the variable 'Name' (I like to use this to select them). Give there the name you would like for each tab to have.

After configure the layout as I show you here.

This is the way I do it and it works for me

Cheers

All comments

afv2688

Hello @mp2624 ,

Here I share you the way I do it:

You have to configure first each table. Then add a formula tool with the variable 'Name' (I like to use this to select them). Give there the name you would like for each tab to have.

After configure the layout as I show you here.

This is the way I do it and it works for me

Cheers

LordNeilLord

Hey @mp2624

Try this example:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Reporting-Tool-Multiple-tabs-in-one-excel-file/td-p/420777

Neil

LordNeilLord

@afv2688

You got there so quick that I actually linked back to this post!!

Well done you

MsBindy

This was very helpful. Is there a way for the width of the tabs to be different from each other? In my case I have 3 tabs that I'm outputting. 2 of them are very wide (about 22 inches); the 3rd tab is a summary report that only needs to be 11 inches wide.

It seems like no matter how much I fiddle with the report table settings, my 3rd tab is stretched out to meet the paper size that I set of 22 inches.

emilyforeman

@afv2688 this solution is awesome, thanks!

Is there anyway to name the sheet names with this method when outputting to excel?
For example, if I have 2 tables unioned and rendered to excel, right now the excel file shows 'sheet1', 'sheet2' whereas I would like to have those automatically be renamed

Link86

Following this overall works, but the output is corrupted on some of the tabs when being opened in excel. How could this be prevented?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703