SAPUI5: Data is empty when Exporting Smart Table to Excel

[#1]

Hi Experts,

I am trying to export a smart table to excel but there is no data in .xls file

In the smart table, I have used tableBindingPath to a model : modelplanning

And my 2 models in manifest.json as below:

Here is my smart table before and after export:

Could you help me please?

Thank you in advance.

Best regards,

Dieu

[rajveer_1989]

Hello dieu,

Did you find the solution on this ?because i'm also facing the same issue for the same case.

Regards

Rajveer Rawat

[rajveer_1989]

I found the solution for this.

[former_member692760]

rajveer_1989 Can you share your solution for this ? Thank you

[rajveer_1989]

Hello Akma,

Please add the below event and code

onPressExportToExcel: function (event)

{

var tabData = view.getModel("table").getProperty("/data");

var mExcelSettings = event.getParameter("exportSettings");

//overwrite the odata with JSON data

mExcelSettings.dataSource = tabData;

}

note: table is my new model used:

entitySet="table>/data" tableBindingPath="table>/data"

BR

Rajveer

[rajveer_1989]

akma.saupe: answered