Online Excel display & edit within UI5 application

[former_member245490]

Hi Experts,

I want to know how to display/edit excel within a UI5 application.I have a oData service returning excel (path).

Have used the below code to open the excel.I want this excel within my UI5 application, however its opening as seperate excel file.

   var Excel = null;

  var filePath = "http://localhost:54236/OnlineExcelPOC/excel/myexcel.xlsx";

  Excel = new ActiveXObject("Excel.Application");

  Excel.Visible = true;

  var excelBook = Excel.Workbooks;

  excelBook .open();

Could anyone please let me know how to achieve this.

[former_member207744]

Hi,

To open your excel file in editable mode. Try highlighted code

var strLocation = "http://localhost:54236/OnlineExcelPOC/excel/myexcel.xlsx";

var objExcel = new ActiveXObject("Excel.Application");

objExcel.Visible = true;

//objExcel.Workbooks.Open(location, isExtrernalReferenceRequired, openInReadOnly);

objExcel.Workbooks.Open(strLocation, false, false);