Analytic app file browse ask user for sheet name

[YanishDewan]

Hi, 

I need to build an analytic app which asks the user for the sheet name when choosing a specific Excel file. I currently had a file browse tool connected to an action tool with configuration "update Input Data Tool". However this approach only works if the Excel file chosen contains only one worksheet. 

My current file browse configuration is set to "Arbitrary File Specification" and to only allow for .xlsx file. I understand if I were to change this to "Standard Database File Formats", the user would be prompted for worksheet name however I do not want to confuse the end user with all kind of database connections. 

How can I configure my file browse to ask user for the worksheet name using only .xlsx as accepted input? 

I have attached an example workflow to illustrate my situation. 

Any help will be much appreciated

[AlteryxUserFL]

Hello, 

The only way to force prompt for the sheet name is to change the configuration to "Standard Database File Formats. The downside is it allows users to select things besides an Excel file.  

[MikeLR]

Just to add to this, if the input Excel file always needs to contain a specific named worksheet you can choose the "Update Value" option in the Action tool and choose to update a specific string covering the filename and path. 

[dheissner]

@MikeLR  when you deploy this to Alteryx Server it always prompts the user for sheet name. Is there another setting you've tried that doesn't ask the user for the sheet name and just uses 'Sheet1' for example?

[mahmoodalqadi]

@dheissner have you found an answer to this?