Download data from an OData Service into Excel Directly
This is my first blog post on SCN. I don’t know if the members already know of this functionality but I was quite fascinated by this so I decided to share it anyway 🙂 .
I found this while playing around with MS Excel. It reads the data of an OData service directly into an Excel file (basically the Get_EntitySet data). Just follow the steps below:
==> Open MS Excel and create a blank workbook.
==> Click on the Data tab at the top and select From Other Sources->From OData Data Feed
==> Specify the link to the OData service in the next pop-up. In this case I am using the publically availaible Northwind OData Service. You can also take up your own OData service by providing necessary authentication details in the same popup. Then click Next
==> The wizard will fetch all the Entity Sets contained in the OData service. Select the one which you want to download to Excel. I selected PersonDetails here.
==> Click Finish and you will be asked for how you want the data to be displayed in Excel.
==> Select table and click OK. Wait for some time while your data is downloaded.
The data from the OData service is now availaible in Excel 🙂
This functionality also works fine for HANA Exposed OData services (xsodata).
Hope you all like this post.