i have an requirement that i am exporting the data from SAP in the form of excel through odata service .I need to create 3 tabs in the excel where i have to export the data in those 3 tabs.Can you please suggest how to create those?
I have some data in an internal table , that data I have to display to the user in the form of excel.To be more specifc when user clicks on download button in frontend this data will be downloaded as an excel in which I have create 3 sheets in it.
First of all OData is not a mechanism to transfer data in form of Excel rather it is just a mechanism to transfer data. By nature OData does not come with any excel manipulation mechanism.
However Gateway Server adds a 'LITTLE' excel capability to the OData Response. Gateway can send the response Entity Set in Excel attachment if you pass '$format=xlsx' in the URL. But this is out of the box from Gateway.
But this allows you to download the content of one table in one excel tab.
These are the options available for you out of the box but they do not create 3 tabs for you, rather they download one excel for one one entityset/one table.
For your requirement you may go for custom control or using third party apis like
In this case you need to make OData calls to get the data from backed and collate them in json format in JavaScript, and then converting it to excel using the js libraries.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.