Skip to Content
0
Dec 16, 2016 at 08:56 AM

Display Excel Sheet in UI5 Screen.

1155 Views

Hello Friends,

I need to display excel sheet in UI5 Screen also should be downloadable if user needs.

I followed below blog:-

https://blogs.sap.com/2014/04/24/download-sapui5-table-as-excel-generated-in-abap-backend-system/

My Code:-

var html = new sap.ui.core.HTML();
var oPanel = this.getView().byId("panel");
var sRead = "/ety_so_reportSet(IM_VBELN='" + doc_number + "')//$value";
oPanel.destroyContent();
oModel.read(sRead, null, null, true, function(oData, oResponse) {
var sURI = oResponse.requestUri;

html.setContent("<iframe src=" + sURI + " height='750' width='1600' type='text/html'></iframe>");
//html.setContent("<object data=" + sURI + " height='750' width='1600'></object>");
// html.setContent("<embed src=" + sURI + " height='750' width='1600'></embed>");

oPanel.addContent(html);

now file is downloading. its not open in UI5 screen. How to display excel sheet in UI5 Screen?

Regards

Vijay