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

5. Exce