Using File Browse on Excel files first of all is inconsistent between running the Analytical App in the Designer and in the Gallery:
- In the Designer, the user is not being asked which Excel workflow shall be selected.
- In the Gallery, the user is always asked which Excel workflow shall be selected.
Depending on the use case, both behaviours can be the right one:
- To load a specific Excel file worksheet, the dialog for workflow selection is appropriate.
- When working with the entire Excel file (copying, getting the list of worksheets, etc.), the dialog is not helpful.
Thus, my idea is as follows:
- Add a checkbox to the File Browse tool which determines whether the worksheet selection dialog shall be opened (and the output will be <filename>.<ext>|<worksheet>) or not (and the output will be <filename>.<ext>) in case of Excel file selected.
- Make behaviour consistent in Alteryx Designer and Gallery.
![haraldharders_1-1686056127055.png haraldharders_1-1686056127055.png](https://community.alteryx.com/t5/image/serverpage/image-id/308446i67C4393682634ABA/image-dimensions/660x292?v=v2)