Skip to Content

Multiple Excel sheets in SAPUI5

Nov 15, 2017 at 10:59 AM


avatar image

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.


S. Jain

excel.png (19.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

S. Jain Nov 16, 2017 at 06:16 AM

Can anyone please suggest.

10 |10000 characters needed characters left characters exceeded