topic Re: creating multiple Excel spreadsheets in Alteryx Designer Desktop Discussions

creating multiple Excel spreadsheets

Timo97 — Tue, 21 Sep 2021 08:50:16 GMT

Hello everybody,

i have a small question i would like to create one excel file as an output, with multiple inputs and each input goes on an different sheet.

Sound not so hard but cant find the way to create it.

Would be nice if someone could help thx.

LG Timo

Re: creating multiple Excel spreadsheets

atcodedog05 — Tue, 21 Sep 2021 08:54:30 GMT

Hi @Timo97

The simplest way is to use 2 output tools and write to each sheets like below.

Workflow:

Hope this helps : )

Re: creating multiple Excel spreadsheets

Emil_Kos — Tue, 21 Sep 2021 08:55:36 GMT

Hi @Timo97,

I would strongly advise checking this article: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Output-to-multiple-sheets-within-an-Excel-file/ta-p/1241

It covers this topic really well and I am sure you will enjoy it!

Re: creating multiple Excel spreadsheets

AngelosPachis — Tue, 21 Sep 2021 08:56:25 GMT

@Timo97

To create multiple sheets in a single excel spreadsheet you first need to have a column with the different tab names. Then in the output tool, you can select to take the table name from that particular column

To find different ways of how to configure the tool, I suggest you have a look at the sample workflows (right-click on the Output tool, select Open example) or read through the help page here

Hope that helps,

Angelos

Re: creating multiple Excel spreadsheets

Timo97 — Tue, 21 Sep 2021 13:53:05 GMT

Thanks a lot guys 🙂

Re: creating multiple Excel spreadsheets

atcodedog05 — Tue, 21 Sep 2021 13:54:03 GMT

Happy to help : ) @Timo97

Cheers and have a nice day!

Re: creating multiple Excel spreadsheets

Timo97 — Thu, 23 Sep 2021 07:48:06 GMT

Hi @atcodedog05,

i did exacly what you advised, and it is working with 10 out of 11 outputs but the 11 output is saying ERROR:" Unable to open file for write: C:\Users\t......"

Do you have any idea why this is popping up?

Thanks already for your help 🙂