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;                 
          }
      }
}

results matching ""

    No results matching ""