Export to Excel in Analytical Table

[sanjoy0308]

Hi Experts, jocelyn.dart, tejas.chouhan,

I referred https://blogs.sap.com/2017/08/27/fiori-elements-export-to-microsoft-excel-via-the-ui-adaptation-edit... and I have this settings in my manifest, but export to excel is not working.

Could you please help whether we can use export functionality in analytical smart table or we need to write custom action?

"component": {
   "name": "sap.suite.ui.generic.template.AnalyticalListPage",
   "list": true,
   "settings": {
      "condensedTableLayout": true,
      "showGoButtonOnFilterBar": true,
      "enableTableFilterInPageVariant": true,
      "tableType": "AnalyticalTable",
      "multiSelect": true,
      "autoHide": true,
      "smartVariantManagement": true,
      "useExportToExcel": true,
      "keyPerformanceIndicators": {}
}

[Jocelyn_Dart · Accepted solution]

Hi Sanjoy, Changing the manifest.json is not how that works and not what was explained in the referenced blog. Did you try the technique as explained?

[pmcfarling · Accepted solution]

Any idea how to do this on a consumption view marked @Analytics.query: true in a List Report using VSCode/BAS? manifest.json and application modeler settings do not seem to work.

[sanjoy0308]

Hi Jocelyn, I tried the UI Adaptation Editor and now its working. Thanks a lot.

[former_member658227]

Dear Sanjoy, you are using Analytical Table, does it export also all aggregated rows (group headers and sum rows) to excel?