You are here: Defining Files and Fields > Defining Excel Spreadsheet Data > Select Worksheets or Named Ranges

Selecting Worksheets

Select the desired worksheet(s) or named range(s) from the selected spreadsheet. Click [Next].

Note: Excel worksheets are assumed to always contain a first row containing column headings. If your worksheet doesn’t contain a heading row, add a heading row before importing.

Click [Next]. The Wizard proceeds to the Final panel. See Final Panel.data.

Defining Multiple Tables

If more than one worksheet or named range is selected, each worksheet will be defined independantly.

If you wish to join worksheets or named ranges, then use the Excel (ODBC) option instead. For more infomation see Defining Excel Spreadsheet Data via ODBC.