getting error in spreadsheet download after deployment eventhough its working on webide

[former_member592880]

I'm trying to export my table from fiori into an excel file. the export was working perfectly when on webide but gives error after deployment.

code:

createColumnConfig: function() {
  return [{
   label: "PO Number",
   property: "EBELN"
  }, {
   label: "Created Date",
   property: "AEDAT",
   width: "25"
  }, {
   label: "1st Approver",
   property: "NAME1",
   width: "25"
  }, {
   label: "Approved On",
   property: "DATE1",
   width: "25"
  }, {
   label: "2nd Approver",
   property: "NAME2",
   width: "25"
  }, {
   label: "Approved On",
   property: "DATE2",
   width: "25"
  }, {
   label: "3rd Approver",
   property: "NAME3",
   width: "25"
  }, {
   label: "Approved On",
   property: "DATE3",
   width: "15"
  }, {
   label: "Net Aging Days",
   property: "NTDAYS",
   width: "15"
  }];
 },
 download: function() {
  var aCols, oSettings;
  aCols = this.createColumnConfig();
  var fromdate = this.getView().byId("fromDate")._lastValue;
  var todate = this.getView().byId("toDate")._lastValue;
  var arr1 = fromdate.split('/');
  var fromDateValue = arr1[0] + "/" + arr1[1] + "/" + "20" + arr1[2];
  var arr2 = todate.split('/');
  var toDateValue = arr2[0] + "/" + arr2[1] + "/" + "20" + arr2[2];
  var todt = new Date(toDateValue);
  var fromdt = new Date(fromDateValue);
  var year = todt.getFullYear();
  var month = todt.getMonth() + 1;
  var date1 = todt.getDate();
  var hour = "00";
  var min = "00";
  var to = "datetime" + "'" + year + "-" + month + "-" + date1 + "T" + hour + ":" + min + "'";
  var year1 = fromdt.getFullYear();
  var month1 = fromdt.getMonth() + 1;
  var date2 = fromdt.getDate();
  var hour1 = "00";
  var min1 = "00";
  var from = "datetime" + "'" + year1 + "-" + month1 + "-" + date2 + "T" + hour1 + ":" + min1 + "'";
  var sURI = "/sap/opu/odata/AAG362/MM_PO_ANALYSIS_01_SRV/";
  //var oDataModel = new sap.ui.model.odata.ODataModel(sURI, false, "x362ben001", "Onama@123");
  var oDataModel = new sap.ui.model.odata.ODataModel(sURI, false);
  var oHeaders = {
   'Accept': 'application/json',
   "X-Requested-With": "XMLHttpRequest",
   "Access-Control-Allow-Origin": "*"
  };
  var functionWithsFilter = "/AginglistSet?$filter=FROMDATE eq " + from + " and TODATE eq " + to;
  //          oDataModel.read("/AginglistSet?$filter=FROMDATE eq datetime'2018-09-01T00:00' and TODATE eq datetime'2018-10-10T00:00'", {
  oDataModel.read(functionWithsFilter, {
   header: oHeaders,
   async: false,
   //async: true,
   success: function(oData, response) {
    if (oData.results !== "undefined" || oData.results !== null) {
     var resultData = oData.results;
     oSettings = {
      workbook: {
       columns: aCols
      },
      dataSource: resultData
     };
     var oSpreadsheet = new sap.ui.export.Spreadsheet(oSettings);
     oSpreadsheet.build()
      // new Spreadsheet(oSettings)
      //          .build()
      .then(function() {
       MessageToast.show("Spreadsheet export has finished for Aging List Data");
      });
    }
   },
   error: function(error) {
    MessageBox.show("Backend connection service data issue while downoading", {
     icon: sap.m.MessageBox.Icon.ERROR,
     title: "Error",
     details: error
    });
   }
  });
 },

error:

[amirkehtarian]

I have answered the issue in the following:

https://community.sap.com/t5/technology-q-a/sapui5-sap-ui-export-spreadsheet-issue-on-fiori-launchpa...

I hope this works.