Skip to Content
-1
Oct 01, 2019 at 11:49 AM

Excel cells edit/non-edit option when we download it from SAPUI5

155 Views

Hi Experts,

When we download the table data to excel sheet make the cells edit/non-edit in downloaded sheet based on condition.How to achieve this functionality.

code: in my controller

var oExport = new sap.ui.core.util.Export({

exportType: new sap.ui.core.util.ExportTypeCSV({

separatorChar: "," }),

models: Budgetmodel,

rows: { path: path },

columns: aColumns });

oExport.saveFile().catch(function(oError) {

sap.m.MessageBox.error("Error when downloading data\n\n" + oError);

}).then(function() {

oExport.destroy();

});

Thanks,

Ashok.