Add new dataset dialog options for Excel

You can acquire data from one or multiple Microsoft Excel workbooks. You choose which rows and columns to acquire. You can also acquire data from cross tables.

Table 1: Add new dataset dialog options for Excel

Option

Description

Dataset Name

Enter a name for the new dataset.

File(s)

Select the Excel workbooks that will be the data source for the new dataset.

Sheet

When an Excel workbook contains multiple worksheets, select the worksheet to acquire for the dataset.

Append all sheets

Select this check box to add all worksheets in the workbook to the dataset. Common columns are appended, and different columns are added as new columns.

Set first row as column names

Select this check box to set the first row values in the worksheet as column names in the dataset.

Table Header Type

Select Standard Table (No Transformations) or Cross Table.

Select All

Select this check box to add all columns in the worksheet to the dataset.

Show record count

Select this check box to show the number of columns and the number of rows in the dataset.

Start of the navigation path Advanced Options Next navigation step Show hidden columns End of the navigation path

Select this check box to display hidden worksheet columns as column headers in the dataset.

Start of the navigation path Advanced Options Next navigation step Show hidden rows End of the navigation path

Select this check box to display hidden worksheet rows in the dataset.

Start of the navigation path Advanced Options Next navigation step Detect merged cells End of the navigation path

Select this check box to highlight merged worksheet cells in the dataset.

Start of the navigation path Advanced Options Next navigation step Range Selection End of the navigation path

When a worksheet contains one or more named ranges, select the range to apply to columns acquired for the dataset. A dataset is restricted to the columns defined in this range.

Start of the navigation path Advanced Options Next navigation step Column End of the navigation path

For cross tables, specify the number of columns to use for the left header.

Start of the navigation path Advanced Options Next navigation step Row End of the navigation path

Specify the number of rows to use for the top header.