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.
SAP Knowledge Base Article - Preview