Open all sheets from one file, with only one select file in Altery Gallery

[Sousou]

Does someone has a working solution to select one file in Alteryx Gallery and use and output all sheets form this file ?

I m not able to find a solution working in the Gallery, it's only working in local :/

Thank's in advance for your help

[MichaelSu]

Hi @Sousou ,

If you want to input multiple sheets from an Excel Tab, you have to use the input sheet names option and then use a dynamic input to read in multiple sheets at once. Similar to this article here https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Input-Multiple-Excel-sheets-with-a-...

When you then connect a File Browse interface tool to the Input tool and publish to Gallery, you will be prompted by Gallery to point to your file and then select <List of Sheet Names>. 

Furthermore, if you wanted to output to multiple tabs based on the data, please view this article https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Output-to-multiple-sheets-within-an...

Thanks,

Mike