Make a plugin for multi-tab Excel output/recipe

[tomtom]

Hello,

I know it's possible to code a multi-tab output with a Python recipe thanks to panda "to_excel" function but a proper visual recipe or plugin would be more convenient.

Cheers.

[cperdigou]

I take note of this as a new plugin request, multiple datasets as input and one folder containing a single multi-sheet xlsx file as output.

Would those specs fit your need?

It's added to our list for future consideration.

[tomtom]

Yes it is the specs, thanks @cperdigou
It would be also cool to have the ability the specify the sheet name for each input.

[AshleyW · Accepted solution]

Hi @tomtom ,

To follow up on @cperdigou 's post, Dataiku released just such a plugin:  Multisheet Excel export . It lets you take several different datasets and export them onto different tabs of a single Excel file.

Cheers,

Ashley W.

[lohmee]

Hi @tomtom ,

Have you tried using other platforms like Alteryx? Tons of code-free examples there without the need to rely on open-source technologies like Python:

- https://benjnmoss.wordpress.com/2017/01/16/writing-to-the-same-excel-file-in-alteryx/

- https://intersectionsandoverlaps.wordpress.com/2019/09/02/guide-to-outputting-to-multiple-excel-file...

- https://www.theinformationlab.co.uk/2020/09/10/writing-multiple-tables-to-1-or-multiple-sheets-in-ex... 

Hope this helps!