Analytic app file browse ask user for sheet name

Question

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

test.yxzp

mahmoodalqadi · Answer

@dheissner have you found an answer to this?

dheissner · Answer

@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?

MikeLR · Answer

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.