Hi I have been doing a lot of research to find out how to not have a user prompted to select a sheet name when uploading an excel file to server. It works as expected when using a desktop analytic app.
@miguelm's comment on a post here in 2017 stated that this had been identified as a new bug and had been added to the known issues list for server version 2019.2 shown here: Web Archived Page.
Once the next patch was released (2019.3) the bug is not listed as a fixed or known issue and based on the behavior of this feature on the current version of server 2023.1 it still has not been fixed and has now become a "feature" I guess?