Excel DataSource Wizard

A wizard will guide you through the process of creating a new Excel DataSource as shown in Figure 5.1, “Excel DataSource Wizard”.

Figure 5.1. Excel DataSource Wizard

Excel DataSource Wizard

The Excel DataSource Wizard contains the Name, Description, URL and the Range fields.

Figure 5.2. Excel DataSource Wizard

Excel DataSource Wizard

Using the second page of the wizard, you can either enter the column names and types explicitly, or use the Infer Schema button. Infer Schema will review the selected range of cells and attempt to determine the column types based on the cell types. Where the types cannot be inferred they will default to String type. You can edit the names and types after inferring, if necessary.

Note

You should not add, remove or rearrange the columns after inferring the schema, unless you make the corresponding changes to the Excel file.