URL length/size constraint along with URI option $format=xlsx

[harishkollipara]

I wanted to utilize the $format=xlsx URI option to get the entity set gets downloaded in XLSX format.

I need to pass multiple parameters to the service.

In IE, I see the URL restriction as 2000 characters and in Chrome it is 2MB.

To make the application work in both browsers, the URL length is restricted to 2000 characters. But for my requirement, I need to pass more than 2000 characters as parameters to the service.

If I use the POST method for the OData service, I was unable to use the URI option $format=xlsx, so to get the XLSX download feature I have use the GET method only.

Is there any other way to get the data downloaded in XLSX format for huge number of parameters?

Or any other option for my requirement.

I am using UI5, Gateway and ECC systems.