> #### How to specify what data to retrieve from an Excel workbook

> 1 | In Data Explorer, right-click Data Sets, then choose New Data Set.

> 2 | In New Data Set, specify the following information:

> 1 | In Data Source Selection, select the Excel workbook. Data Set Type displays Excel Data Set.

> 2 | In Data Set Name, type a name for the data set.

> 3 | Choose Next.

> 3 | In New Excel Data Set, specify the data to retrieve:

> 1 | In Select worksheet, select the worksheet from which to retrieve data.

> 2 | In the left pane, select the columns to include in the report design, then choose the right arrow. The columns appear in the right pane, as shown in Figure 2-8.

> Figure 2-8 Specifying data to retrieve from an Excel data source

> 3 | To rearrange the columns, select a column in the right pane, and choose the up or down arrow to move the column in the list, as shown in Figure 2-9.

> Figure 2-9 Rearranging columns in the Excel data set

> 4 | To select columns from another worksheet, repeat substeps 1–3.

> 4 | Choose Finish to save the data set. Edit Data Set displays the columns, and provides options for editing the data set, as shown in Figure 2-10.

> Figure 2-10 Viewing output columns for an Excel data set

> 5 | Choose Preview Results to view the data rows returned by the data set.

(c) Copyright Actuate Corporation 2013