How to set what tab should be used for Excel file import in Analytical App?

[ClaytonA]

I currently have an Analytical App built that allows users to import data into the database from an Excel file in the Alteryx Gallery. However, when I click on browse in the screenshot attached Alteryx takes forever to load what tab I would like to import and I am guessing its because it is trying to read every table/tab in the Excel file.

Is there a way that I can hard code / manually set the exact tab (name = Input$ tab) that I always want to import no matter what the name of the Excel file the user is trying to import. All the Excel files the users will import will have the exact same layout just different data. 

Please let me know if anyone has any suggestions.

[danilang]

Hi @ClaytonA 

The process of retrieving the sheet names to display is usually pretty quick(<10 secs), even for a large file with 20+ tabs on a shared network drive.  If it's taking "forever", it's probably because the file is open so Alteryx can't get a lock on it to read the sheet list.

Unfortunately, the sheet name prompt is built into the UI so there's no way to bypass it.

Dan