Creating a Datasource and Data Table from Excel

1. Create a new datasource

1. Go to New Datasource.

2. Select ExcelProvider (v1.0 – Microsoft Excel 2007+).

3. Click Browse, select the Excel file you want to use, and upload it.

4. If the Excel file is password-protected, enter the password.

5. Save the datasource.

2. Create a new data table

1. Create a New Data Table.

2. Set Query Type to Procedure.

3. From the dropdown list, select the Excel sheet you want to use.

3. Configure cache (required)

1. Configure cache for the new data table.

Important:

Cache is required for the ExcelProvider.

Previewing the data table before cache is configured will not work.

Notes

• Each Excel sheet is exposed as a separate “procedure”.

• If the Excel file is updated, the cache must be refreshed for changes to appear.