I have a jquery function that exports the kendo grid data in a excel. I am able to export the data but I want a OPEN option along with SAVE and CANCEL once the excel is exported. Check the attached image for reference.
Here is my Jquery code to export data:
exportResultToExcel: function (data) {
if (data.length > 0) {
var rows = [{
cells: [
{ value: "Payer", background: "#1F497D", color: "#fff" },
{ value: "Acc No.", background: "#1F497D", color: "#fff" },
{ value: "Draft No.", background: "#1F497D", color: "#fff" },
]
}];
for (var i = 0; i < data.length; i++) {
var dataItem = data[i];
rows.push({
cells: [
{ value: dataItem.Customer },
{ value: dataItem.AcNo) },
{ value: dataItem.DtNo },
]
})
}
var workbook = new kendo.ooxml.Workbook({
sheets: [
{
columns: [
{ autoWidth: false },
{ autoWidth: false },
{ autoWidth: false },
],
rows: rows
}
]
});
var sheet = workbook.options.sheets[0];
kendo.saveAs({ dataURI: workbook.toDataURL(), fileName: "Export Result.xlsx" });
}
})
},
question from:
https://stackoverflow.com/questions/65644180/open-option-is-not-coming-in-kendo-export-to-excel-using-jquery 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…