Liquid XML Studio 2019
Select Range (Excel Reader Wizard)

The Wizard will analyse the spreadsheet and dispay all the Sheets which contain data along with globally and locally defined regions and tables.

You then have the choice to either select one of these predefined areas (which populates the Refers To field) or specify a data range yourself in the 'Refers To' field.

Additionally, you can specify if the First Line contains column names and optionally Ignore Last Line which, for example, may contain totals.