Currently, the Grid Excel export will not export columns that have a client template defined on them.
The answer from Telerik HERE, solves the issue in a static way. Meaning that for each column that has a client template definition, you will have to alter the script to add the other columns.
function excelExport(e) {
var sheet = e.workbook.sheets[0];
var employeeTemplate = kendo.template(this.columns[0].template);
var employerTemplate = kendo.template(this.columns[1].template);
//Add more template variables and set them to the column index in the grid.
var data = this.dataSource.view();
for (var i = 0; i < data.length; i++) {
sheet.rows[i + 1].cells[0].value = employeeTemplate(data[i]);
sheet.rows[i + 1].cells[1].value = employerTemplate (data[i]);
//Add the cell values by column index from the template v
}
}
Here is a script to dynamically get all of the columns with client templates :
Grid HTML Helper:
@(Html.Kendo().Grid<Employee>()
.Name("employeeGrid")
.ToolBar(t => { t.Create(); t.Save(); t.Excel(); })
.Events(e => e.ExcelExport("excelExportDynamic"))
.Columns(col =>
{
col.Bound(c => c.Employee).ClientTemplate("#: data.Employee#");
col.Bound(c => c.Employer).ClientTemplate("#: data.Employer#);
col.ForeignKey(c => c.Status, Model, "StatusID", "StatusCode").Title("Status");
col.Command(c => c.Destroy());
})
//Removed for brevity
Javascript function:
<script>
function excelExportDynamic(e) {
var sheet = e.workbook.sheets[0];
var colTemplates = []; //Initialize new array
var data = this.dataSource.view();
for (var i = 0; i < this.columns.length; i++) {
if (this.columns[i].template) {
colTemplates.push(kendo.template(this.columns[i].template)); //Add kendo template to colTemplate array if it exists for the given index's column
} else {
colTemplates.push(null); //Add null to given index if template does not exist for the column index. This ensures columns are mapped to the proper index.
}
}
//colTemplate array has been built now: Example of array at this point) colTemplate: { templateCol[0], null, templateCol[3], null, null }
for (var i = 0; i < colTemplates.length; i++) {
for (var j = 0; j < data.length; j++) {
if (colTemplates[i] != null) {
sheet.rows[j + 1].cells[i].value = colTemplates[i](data[j]); //Loop through all colTemplates and all data in the grid to build the excel sheet. Skip null colTemplates.
}
}
}
}
</script>
Hope this helps!!!!!