Dataset tab

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

Configuration profile setup, Dataset tab
Figure 1. Configuration profile setup, Dataset tab

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.

Configuration profile setup, Excel example
Figure 2. Configuration profile setup, Excel example