Issue when using SAP UI5 library sap.ui.export.Spreadsheet

[RachitGupta]

Hello UI5 Community,

I am on UI5 library version 1.108.26 and I have an app which uses sap.m.table whose items are bound to an odata v4 entity, I have an export to spreadsheet function in the toolbar in which i am trying to export all the table values using SAP UI5 library sap.ui.export.Spreadsheet. Image 1 has the controller code, upon triggerring the event what i observe is there are multiple API calls which are getting executed on the build() function which results in duplicated values in the downloaded spreadsheet. How can i potentially avoid multiple calls to get the data, is there any missing configuration in the settings or a library issue? I would be grateful for any suggestions.

Thanks and Regards

Rachit

[RachitGupta · Accepted solution]

The issue was resolved by changing the implementation of spreadsheet export from server-side to client side. Rows of the table was used as data source instead of backend API.