Export to Excel - Footer as Number, Not String

[kencox]

Hey folks,

When I export my grid to Excel, the client footer value is formatted as a string (see the Excel image below).

Is it possible to tell Excel that this is a numeric value?

Thanks,

Ken

columns.Bound(e => e.Total).Title("Amount").Width(120).Format("{0:C}").ClientFooterTemplate("#= kendo.format('{0:c}', sum)#");

[Alex Hajigeorgieva]

Hello, Ken,

To get the Kendo UI Grid Excel Export footer to generate a cell like the rest of the numeric cells, you should add a handler to the excelExport event and parse the value of the cell to a float. You may use the kendo.parseFloat() method:

excelExport: function(e){
  var rows = e.workbook.sheets[0].rows;

  for (var ri = 0; ri < rows.length; ri++) {
    var row = rows[ri];

    if (row.type == "footer") {
      for (var ci = 0; ci < row.cells.length; ci++) {
        var cell = row.cells[ci];
        if (cell.value) {
          cell.value = kendo.parseFloat(cell.value);
        }
      }
    }
  }
},

 
Here is a runnable example for your convenience:

https://dojo.telerik.com/@bubblemaster/IsIRuHEL

Let me know if you need further assistance.

Kind Regards,
Alex Hajigeorgieva
Progress Telerik