Access Domino OData in MS-Excel
The Domino REST API allows exporting of data from Notes databases to OData format, which can then be read by applications like Excel for Windows, Salesforce, SAP and Business Intelligence. This means that the data in a Notes database can be displayed in something as simple as Excel with just a few clicks.
OData for Excel is only available in the Windows version of Excel
- Open Microsoft Excel and create a Blank Workbook.
Select Data → Get Data → From Other Sources → From ODataFeed.
Point it to an application on the Domino server. In the example, it's pointed to a To-do application.
Select Load to display the Notes data in Excel. The structure of the Notes database is understood.
The Excel sheet is a live document. Any update to the Notes database is seen when you click Refresh.
At the moment, only basic authentication is supported.