Export to Excel from sapui5 table

[former_member219975]

Hi All,

I have requirement to export the data to excel from sapui5 table element, Actually Below is the scenario,

I have JSON response data and I am filling up this data into sapui5 table element. Now I need this data as export to excel.

Is there any way to achieve this? I found so many blogs for export as CSV format, But I want it in Excel.

Please do the needful.

Regards,

Bhavin Anajwala

[andrzej_koeller]

You can use external 3rd party javascript libraries like js2excel or JHXLSX

[gregorw]

I would suggest abap2xlsx as the solution.

[Former Member]

Hi Bhavin,

You may refer the below discussions

Using Data Binding for Data Export

Cheers

Pandu

[former_member182374]

Hi,

If you want a 'real' excel (XLS, XLSX) you need to create it on server side (Gateway, ICF, Java servlet etc).

The following blog explains it:

http://scn.sap.com/community/developer-center/front-end/blog/2014/04/24/download-sapui5-table-as-exc...

Regards,

Omri