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.