> #### How to create an Excel data source

> 1 | In Data Explorer, right-click Data Sources, then choose New Data Source.

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

> 1 | Select Excel Data Source from the list of data source types.

> 2 | In Data Source Name, type a name for the data source.

> 3 | Choose Next.

> 3 | In New Excel Data Source Profile, specify the workbook to use as the data source.

> 1 | Use the drop-down menu for Browse to select either Relative path or Absolute path, as shown in Figure 2-6.

> Figure 2-6 Selecting the type of path to specify

> 2 | In Select file, specify the Excel file to use as the data source.

> 3 | Select additional options, as necessary:

> | Use first line as column name indicator.

> | Use second line as data type indicator.

> Figure 2-7 shows an example of properties to connect to an Excel data source.

> Figure 2-7 Connection properties for an Excel data source

(c) Copyright Actuate Corporation 2013