Symptom
- There is an issue with the standard SAPUI5 control/class 'sap.ui.export.Spreadsheet'
- Using the SAPUI5 Spreadsheet control to export data to a XLSX file in a custom freestyle application
- In the development workspace (we are using VSCode as IDE with UI5 CLI) it works fine (Users can see the Excel sheet with the correct data)
======spreadsheet=========
Header 1 | 2 | 3 |4 | 5 |
--------------------------
Row 1 Data 1 Data 2..
Row 2 Data 1 Data 2..
..
..
========end=============== -
But, when we deploy it to the Abap repository of the customer and access the app via Fiori Launchpad, the export function does not work well. It brings only the headers:
======spreadsheet=========
Header 1 | 2 | 3 |4 | 5 |
--------------------------
..
..blank
..
=========end===============
Read more...
Environment
SAPUI5 1.71.25 to 1.71.38 or others
Product
Keywords
"Fiori Spreadsheet","Export to Excel Fiori","Export to Excel fails in SAPUI5","sap.ui.export.Spreadsheet","spreadsheet shows header","Spreadsheet is blank but works in development" , KBA , CA-UI5-COR , Core and Runtime , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.