OData support for Excel

[former_member298186]

Hello,

we are trying to implement the 'Export to Excel' function on our SmartTable in our app and have been told that we need to make some changes to our OData Service to make this possible. I've performed the usual searches in SCN etc but have not found any reference document describing what one needs implement in the service.

Could there be a set of annotations that we need to add to the Model Class perhaps?

We would be grateful for any help/tips/links.

Kind regards,

Keith Sanderson

[ChandrashekharMahajan]

Hello,

Will this help ?

Regards,

Chandra

[former_member298186]

Hi Chandra,

thanks, but I'd already looked at your blog and was looking for an annotation.

I finally found a sentence in the Netweaver Gateway documentation which reads as follows:

The entity container in the $metadata document of all services has a new annotation listing the supported formats:

sap:supported-formats="atom json xlsx"

but this is only supported from Netweaver Gateway 7.40.

Kind regards,

Keith

[ChandrashekharMahajan]

I guess you are referring to Excel Support - SAP NetWeaver Gateway Foundation (SAP_GWFND) - SAP Library

I am not on Gateway 7.4 and hence cannot test it but this seems excellent!

Regards,

Chandra

[EkanshCapgemini]

Hi Chandra,

I am on 7.4 but unable to find $format=xlsx in my GW client.

Although I tried this but its giving bad request. Not sure about would this need any other steps.

I am on NW7.4 SP 06 and SAP_GWFND SP08. Is this available on any higher SP version?

Regards,

Ekansh

[NagaPrakashT]

Hi Ekansh,

Please the check the SP level of Gateway system. I think SP level should be 09.

Thanks,

Naga

[ChandrashekharMahajan]

Hi Ekansh,

I checked new features of SP09 What's New in SAP NetWeaver Gateway 2.0 SPS 09 - SAP NetWeaver Gateway - SAP Library but Excel support was not mentioned.

I am not sure from what SP level it is available. I posted comment on Andre Fischer blog and waiting for his reply.

Regards,

Chandra

[Andre_Fischer]

Hi Chandra,

the feaure is only available on 7.40 not in all implementations of SAP Gateway on lower releases.

Excel Support - SAP NetWeaver Gateway Foundation (SAP_GWFND) - SAP Library

Best Regards,

Andre

[ChandrashekharMahajan]

Hi Andre,

As I understand correctly SCN Trial Edition of SAP Gateway is based on AS ABAP 7.40 but below query does not give any result.

https://sapes1.sapdevcenter.com/sap/opu/odata/sap/ZGWSAMPLE_SRV/ProductCollection?$format=xlsx

Is there any additional coding changes need to be done for OData service implementation to support excel format?

Regards,

Chandra

[Andre_Fischer]

Hi Chandra,

this system is unfortunately not based on 7.40 yet.

It is running on top of 7.02 and has SAP Gateway 2.0 SP6 deployed.

That's why Excel format is not working here .

Best Regards,

Andre

[EkanshCapgemini]

Hi Andre,

What is the minimum SP version required for this?

Regards,

Ekansh

[Andre_Fischer]

Hi Ekansh,

I forgot to mention in my responses above that it requires SP09 of SAP NW 7.40.

Regards, Andre

[EkanshCapgemini]

Thanks Andre.

Will explore this.

Regards,

Ekansh