Export to Excel - SAP UI5 Smart Template- Not available

[selvakumar_mohan]

The export to excel functionality is not available by default in the smart template based list reports.

Below is the settings code i used to make it enabled:"useExportToExcel" was set to true.

"entitySet": "PO_DashboardSet",
"component": {
		"name": "sap.suite.ui.generic.template.ListReport",
		"list": true,
		"settings": {
			"gridTable": true,
			"multiSelect": true,
			"useExportToExcel": true
				}

Still the export to excel icon didnt appear. On further analysis found the note - 2434491

https://launchpad.support.sap.com/#/notes/0002434491

The resolution is :

Any application which needs this functionality has to set this button active by RunTimeAdaption (RTA).

How do i set the Export to Excel functionality to enable via RTA?

[selvakumar_mohan · Accepted solution]

In additional to the above setting in Manifest.JSON.

Please use "ADAPT UI Editor" follow blog below:

https://blogs.sap.com/2017/08/27/fiori-elements-export-to-microsoft-excel-via-the-ui-adaptation-edit...

Additional to the blog, the export type - UI5Client: