'Export to Excel for telerik radgrid
I want to export current date along with radgrid data to the excel sheet. How can I do this?
For exporting radgrid I am using following code:
public void ExportExcel(RadGrid radGrid)
{
if (radGrid == null)
throw new ArgumentNullException("radGrid");
Page.IsExporting = true;
//Export settings
radGrid.ExportSettings.HideStructureColumns = true;
radGrid.ExportSettings.SuppressColumnDataFormatStrings = false;
radGrid.ExportSettings.ExportOnlyData = true;
radGrid.ExportSettings.IgnorePaging = true;
//Excel Format
radGrid.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;
SetExportFileName(radGrid);
radGrid.MasterTableView.ExportToExcel();
}
First row of excel sheet should be- Date: Jan 30, 2014
then data of the radgrid should be displayed.
Solution 1:[1]
Just write
radGrid.MasterTableView.Caption = "Title";
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|---|
Solution 1 | Mohit Vashistha |