Use Column Templates when Exporting Grid to Excel

Environment

Product	Telerik UI for ASP.NET Core Grid
Product version	2025.1.227

Description

How can I use column templates when exporting Grid's data to Excel?

Solution

The example relies on the following key steps:

1. Add the column in the Grid that has a template:

   Razor

   columns.Bound(p => p.Freight).ClientTemplate("Freight: #: kendo.format('{0:c}', Freight) #");

   Razor

   <column field="Freight" template="Freight: #: kendo.format('{0:c}', Freight) #"/>

2. Handle the ExcelExport event of the Grid:

   Razor

   .Events(e => e.ExcelExport("excelExport"))

   Razor

   <kendo-grid name="grid" on-excel-export="excelExport">
   </kendo-grid>

3. Within the ExcelExport event handler, loop through the data items of the DataSource, select the row and cell in the sheet by index, and use the kendo.template() method to specify the column template as a value of the cell.

   JS

   function excelExport(e) {
       var sheet = e.workbook.sheets[0];
       var template = kendo.template(this.columns[1].template);
       var data = this.dataSource.view();
   
       for (var i = 0; i < data.length; i++) {
           sheet.rows[i + 1].cells[1].value = template(data[i]);
       }
   }

To review the complete example, refer to the ASP.NET MVC project on using column templates in the Grid Excel exports.You can use this as a starting point to configure the same behavior in an ASP.NET Core project.

More ASP.NET Core Grid Resources

• ASP.NET Core Grid Documentation

• ASP.NET Core Grid Demos

• ASP.NET Core DataGrid Product Page

• Telerik UI for ASP.NET Core Video Onboarding Course (Free for trial users and license holders)

• Telerik UI for ASP.NET Core Forums

See Also

• Client-Side API Reference of the Grid for ASP.NET Core

• Server-Side API Reference of the Grid for ASP.NET Core

• Server-Side TagHelper API Reference of the Grid for ASP.NET Core

• Telerik UI for ASP.NET Core Knowledge Base