Dataset tab
You can define the location of the data within the Excel file using the Dataset tab of the configuration dialog.

Sheet
The number of the worksheet within the Excel spreadsheet.
Setting | Description | No. in example |
---|---|---|
Sheet number |
Numeric value of the worksheet |
1 |
Range
The area within the Excel worksheet from which the data is acquired.
Setting | Description | No. in example |
---|---|---|
First row |
The first row from which the data is acquired |
2 |
Last row |
The last row from which the data is acquired |
3 |
First column |
The first column from which the data is acquired |
4 |
Last column |
The last column from which the data is acquired |
5 |
Example
The following example shows the options within the Dataset tab in an Excel worksheet.