SAP Knowledge Base Article - Preview

3073220 - Standard SAPUI5 control/class “sap.ui.export.Spreadsheet” or Export to Excel does not work

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

SAPUI5 1.0

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.