Skip to Content

Multiple Excel sheets in SAPUI5

Hello All,

My requirement is to create fancy excel file as shown below in sapui5.

So, I tried to use OLE objects but it is not working when Tcode for report is run on browser. Standalone report creates Excel file but

1. Tried to run on UI by calling tcode- doesn’t work

2. Submit report in OData - doesn’t work.

Maybe OLE object access local machine so we can’t use it in SAP OData.

Requirement from business is to-

1.Download Excel file on local desktop with pre-filled data from SAP.

2.This is just download functionality so can’t export sap.m.table.

3.Every sheets has filled information in different layout(how to achieve filling different sheets in same excel)

My app is SAPUI5 custom app. I have searched on SCN but found approch of table export into excel which is not my case. also in one execl i have to show data in different sheets.

Can anyone suggest me better approach in order to show SAP data in Excel.

Regards,

S. Jain

excel.png (19.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 16, 2017 at 06:16 AM

    Can anyone please suggest.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 14 at 06:54 AM

    Please try out abap2xlsx.

    Add comment
    10|10000 characters needed characters exceeded