I have a model flow that allows a user to input an excel worksheet which then converts a sheet within the wksht to a table and joins that table to a feature class. Currently, the Excel to Table tool I am using will only convert the sheet within the worksheet that is either the first sheet in the list in the worksheet or will convert the particular sheet that is specified by a name in the tool. My issue is, there is no standard naming convention for the particular sheet that will need to be converted and one excel workbook can have multiple sheets within. I only want one particular sheet within the wkbk to be converted to a table and would Ideally like the user to be able to select that sheet. Is there any way to allow user input on this? Here is an image of my current model below:
Where the Sheet(optional) input is, I would like the user to be able to select the appropriate sheet but I cannot make this a model parameter.