Microsoft Excel

Microsoft Excel 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 then click the Load button.

Excel will access the "Get All Customers" endpoint of your service and you will see the results displayed in the dialog.