This is an open source Excel Add-in for accessing OData V2 and V4 producers. MrBot OData Excel Add-in supports all CRUD operations if the producer supports them.
Other features are:
- Support basic authentication
- Download data in batches
- Different connections per sheet
- Data changes and connection settings are stored off-line in the Excel file
Use the MSI Installer to the install the Add-in.
You can modify the code using Visual Studio 2019 Community Edition