@(Html.Kendo().Grid() .Name("grid") .NoRecords("No user assignment found") .ToolBar(tools => tools.Excel()) .Excel(excel => excel .AllPages(true) .FileName("UserAssignments.xlsx")) .Columns(columns => { columns.Template(@).ClientTemplate("") .HeaderTemplate("").Width(8); columns.Bound(c => c.ID).Width(0).Title("ID").Visible(false); columns.Bound(c => c.EmployeeName).Width(20).Title("Employee Name").Visible(false); columns.Bound(c => c.StartDate).Width(14).Title("Start Date"); columns.Bound(c => c.CompletionDate).Width(16).Title("Completion Date"); columns.Bound(c => c.Status).Width(10).Title("Status").Visible(false); }) .HtmlAttributes(new { style = "height: 1500px; width:1080px;" }) .Scrollable() .Sortable() .Events(e => e.ExcelExport("exportToExcelSheetColumnWidthChange")) .Filterable(filterable => filterable .Extra(false) .Operators(operators => operators .ForString(str => str .Clear() .Contains("Contains") .IsEqualTo("Is equal to") ) ) ) .Pageable(pageable => pageable .Refresh(true) .PageSizes(true) .ButtonCount(5)) .DataSource(dataSource => dataSource .Ajax() .Read(read => read.Action("GetEmployeeDataListing", "Employee")) .PageSize(20) ) .Scrollable() .Events(events => events.DataBound("onGridDataFound").DataBound("onDataBound")) )