Showing results for 
Search instead for 
Did you mean: 

alteryx server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

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


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


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


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