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