cancel
Showing results for 
Search instead for 
Did you mean: 

How to enable EXCEL export button in FIORI List Report Application ?

rakesh_94
Participant
0 Kudos

HI all, How to enable excel export button in FIORI List Report Application using cds views or fiori Elements or annotations only not with UI5 function and I am using SAP WEB IDE personal Edition not cloud sap web ide.

Please give me some inputs.

Thank you.

Accepted Solutions (0)

Answers (2)

Answers (2)

hemil_1993
Explorer
0 Kudos

Hi rakesh_94

You can get the smartTable in onAfterRendering function and after that you have to set the property like.

oSmartTable.setUseExportToExcel(true);

Best regards
Hemil Prajapati

rakesh_94
Participant
0 Kudos

where can I find onAfterRendering function? in annotation file or manifest? because that function not exits in the both file

0 Kudos

Hi rakesh_94

It should be done in Adaptation project configuration and cannot configure with CDS View / Annotations.

https://blogs.sap.com/2019/10/11/sap-fiori-for-sap-s4hana-adding-export-to-excel-to-a-standard-sap-f...

Regarding Fiori elements, I remember that we have the Excel Export button in default on latest SAPUI5 bootstrap.

Best regards

rakesh_94
Participant
0 Kudos

I am unable to see the option of SAPUI5 visual Editor to add

0 Kudos

rakesh_94 SAPUI5 Visual Editor is not available on Web IDE personal edition.

https://answers.sap.com/questions/12655621/web-ide-trial-version-on-premise---fiori-elements-.html

Otherwise I suppose you are not able to add excel export button on Web IDE Personal Edition.

Instead, I recommend you to use Fiori Tools - a successor of Web IDE in terms of Fiori (elements) development. It is available on SAP Business Application Studio (on Cloud) or Visual Studio Code (on Laptop). You can add Excel Export function with "Guided Development" on Fiori tools.

Fiori tools also works on your laptop if you choose Visual Studio Code. Changing development tools may be an option.

For details, please refer to the Tutorial below.

https://developers.sap.com/tutorials/fiori-tools-vscode-setup.html