or


protected void RadGridInventory_ItemCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == RadGrid.ExportToExcelCommandName || e.CommandName == RadGrid.ExportToCsvCommandName) { RadGridInventory.PageSize = RadGridInventory.MasterTableView.VirtualItemCount; } if (e.CommandName == RadGrid.ExportToExcelCommandName) { var headerItem = (GridHeaderItem)RadGridInventory.MasterTableView.GetItems(GridItemType.Header)[0]; headerItem.Visible = true; isExport = true; } if (e.CommandName == RadGrid.ExportToCsvCommandName) { RadGridInventory.MasterTableView.GetColumn("CSVAcountId").Display = true; RadGridInventory.MasterTableView.GetColumn("AccountId").Display = false; RadGridInventory.MasterTableView.GetColumn("CSVStatus").Display = true; RadGridInventory.MasterTableView.GetColumn("Status").Display = false; } }protected void RadGridInventory_GridExporting(object source, GridExportingArgs e) { if (e.ExportType == ExportType.Excel) { string customText = "<h1 style='text-align:center;'>Inventory Report for " + _applicationUser.Customer.Name + "</h1>"; customText += "<p style='text-align:center;'><b>Current Date:</b> " + DateTime.Now + "<br />"; if(RadDatePickerStarting.SelectedDate != null && RadDatePickerEnding.SelectedDate != null){ customText += "<b>Date Range Covered:</b> " + RadDatePickerStarting.SelectedDate + " - " + RadDatePickerEnding.SelectedDate + "<br />"; } else { customText += "<b>Date Range Covered:</b> " + RadComboBoxChoices.SelectedItem.Text + "<br />"; } customText += "<b>Clients:</b>"; foreach (var client in ClientSelector1.SelectedClients) { customText += " " + client.Name + ","; } customText = customText.TrimEnd(','); customText += "</p>"; e.ExportOutput = e.ExportOutput.Replace("<body>", "<body>" + customText); } isExport = false; }<script type="text/javascript"> function onRequestStart(sender, args) { if (args.get_eventTarget().indexOf("ExportToExcelButton") >= 0 || args.get_eventTarget().indexOf("ExportToCsvButton") >= 0) { args.set_enableAjax(false); } } function onCommand(sender, args) { } </script>