Microsoft Excel Ranges

Home > Tutorials > Connector Tutorial > Connecting to a Data Source > Using a Microsoft Excel Workbook as a Data Source

Using a Microsoft Excel Workbook as a Data Source

In order to use an existing Excel Workbook as a data source for a report, the data needs to be organised into named ranges.

1. To do this, open the workbook in Microsoft Excel. The data should be stored with accurate headings so that when expressions are added, the data remains meaningful. Select the data required for report writing purposes by highlighting.

   

2. Go to Formulas Tab.

3. Click Define Name.

   

    

4. Add a suitable Name and click OK.

5. This range will now be available for selection when you add new data containers within the Connector module.

6. A new connection type has been added to the Connector for connecting to Microsoft Excel workbooks as source data via an ODBC connection. To add a new data connection to a Microsoft Excel workbook you will need to ensure that you have selected the applicable data in Microsoft Excel and have named the range prior to adding the connection within the Connector. Adding a named range to a Microsoft Excel workbook.

   

7. Click on the Add Icon which will display the Connection Info window.

   
8. Name the connection and specify the Microsoft Excel workbook that you will be accessing.
9. If the workbook has been protected you will need to add the relevant user id and correct password. Click Add.
10.  Test the connection by clicking the Check/Test button, , or by right-clicking the mouse and selecting Check/Test.

Next-->