Analytic App: Input excel file static sheet and range

[wonka1234]

Hi,

Is there a way to import a file and choose the range and sheet or statically store the range somewhere?

I have the browse file but I would like to have the sheet + range stay the same.

How can I do this?

Thanks

[DataNath · Accepted solution]

@wonka1234 if you define your sheet and range in your Input Data tool as follows:

And then in your Action tool between your File Browse and Input Data tool, make sure it's just updating the actual file path (tick Replace a Specific String and delete everything after .xlsx):

Should bring in the same range from other input files:

How do you get on with that?