Microsoft Excel and OData Services

Microsoft Excel has the ability to interact with data exposed by OData Services, including Harmony Core OData services. Here is a very basic example of doing so:

1. Start Microsoft Excel and create a new blank workbook.

2. On the ribbon, go to the Data tab.

3. Click the Get Data button then select From Other Sources and From OData Feed.

4. In the OData Feed dialog, enter the base URL of your service, which will generally end with /odata/v1, and click OK.

Excel will then download and parse the OData Metadata from your service and present you with a Navigator dialog. You can use this dialog to select the data that you want to reference. We'll keep it really simple in this example.

5. Select Customers and soon you will see a preview of the customer data that will be returned.

6. Click the Load button to load the data into the Excel sheet.