Dataset tab
Define the location of the data within the Excel file.
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.