Default to Sheet1$ when using File Browse tool

Question

Hi everyone,

I'm building an Analytic App which seems to work fine. I'm trying to refine the UI some so it's easier for the user. I've asked the user to upload an excel file, based on a template that I've provided via a link. Rather than making the user select <List of Sheet Names> or 'Sheet1$', I'd rather it either just default to 'Sheet1$' or, ideally, default to 'Sheet1$' and not have this pop up at all. Is this possible?

This is what pops up when running the app in the Gallery:

Which is slightly different than what's displayed in Designer:

How the File Browse and Update Input Data Tool are configured:

Any help would be greatly appreciated.

Tyler

Maskell_Rascal · Accepted Answer

Hi @Whodathunkit,

So unfortunately there is no option to default to a specific sheet within an app published to the gallery when uploading an Excel file. If you'd prefer not to see a popup at all, you can set the upload requirements to be a CSV file. Since those file types do not have more than one sheet, the gallery would automatically read in the only sheet without a prompt.

If this solves the problem please mark answer as correct, if not let me know!

Cheers!

Phil