Skip to Content

Hi All.

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.

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Mike Doyle

    Nice work for a first blog, Deepak. I didn’t know you could do this. OData was originally a Microsoft idea, so that would explain why they added this feature to Excel

    (1) 
  2. Martin Fischer

    Cool that you mentioned this option.

    There is actually a very cool tool developed by SAP for even better integration including the possibility to edit and save data, including conflict resolution for concurrent changes. It also offers value helpers for the end user.

    The bad news: SAP stopped selling it. The reason behind: wrong licensing model. SAP expected that customers pay additional licensing fees for each user.

    The name of the tool: SAP Gateway for Microsoft. It’s worth to take a look. Would still be a cool tool. SAP should just accept that customers will not pay extra money for it!

    (1) 

Leave a Reply