Export media as response for Query(GetEntitySet)

[vishnu_gk]

Hi All,

I have requirement where the UI5 screen will be performing a query operation whose response should be passed as an excel export.

I have following questions on this.

1. If I have generated an Xstring at OData with required output and passed as a property, Will it be possible to parse that Xstring at the UI5.

2. since I have too many fields as output, Don't want to add all the fields as property instead want to pass all the data as Xstring.

FYI: I cant use Get Stream method as it wont allow various filters to pass

Please suggest if there is possibility or any alternative for this.

Thanks

Vishnu

[former_member184867]

You can use UI5 smarttable control , that has built in feature to export to excel

https://sapui5.hana.ondemand.com/docs/api/symbols/sap.ui.comp.smarttable.SmartTable.html