Kendo Excel export format is based on ooxml standard.
$("#resultGrid").kendoGrid({
toolbar: ["excel"],
excel: {
fileName: "Facultative Application Received.xlsx",
allPages: true
},
excelExport : function (e) {
var sheet = e.workbook.sheets[0];
// set up column width
sheet.columns[1].width = 75;
for (var rowIndex = 0; rowIndex <= sheet.rows.length - 1; rowIndex++) {
var row = sheet.rows[rowIndex];
row.height = 50;
for (var cellIndex = 0; cellIndex < row.cells.length; cellIndex++) {
row.cells[cellIndex].background = "#010879";
row.cells[cellIndex].color = "#ffffff";
row.cells[cellIndex].bold = true;
row.cells[cellIndex].fontSize = 12;
row.cells[cellIndex].wrap = true;
row.cells[cellIndex].textAlign = "left";
row.cells[cellIndex].verticalAlign = "top";
row.cells[cellIndex].borderTop = { size: 1 };
row.cells[cellIndex].format = "$ #,##0;";
row.cells[cellIndex].colSpan = 3;
}
}
}