protected ActionResult QueryAndExcel(JQGrid grid, IQueryable query, string excelFileName) { switch (grid.AjaxCallBackMode) { case AjaxCallBackMode.RequestData: case AjaxCallBackMode.Search: return(grid.DataBind(query)); case AjaxCallBackMode.Excel: grid.ExportSettings.ExportDataRange = ExportDataRange.Filtered; grid.ExportToExcel(query, excelFileName, grid.GetState()); break; } return(new EmptyResult()); }