RadGrid Export to Excel and add extra information

[Justin Pretorius]

Good day,

I was wondering if it is possible to include text above the exported data in an Excel file using the normal Export to Excel method with a RadGrid?

For example I wish to include a description of the data as follows,  "Description: Data selected using dates between 1 Jan 2011 to 1 Sep 2011", above the actual data exported.

I shall be grateful for any information on this matter

Justin

[Shinu]

Hello Justin,

Try the following code snippet to achieve your scenario.
C#:

protected void Btn1_Click(object sender, EventArgs e)
  {
      RadGrid1.MasterTableView.Controls.Add(new LiteralControl("<span><br/>Description: Data selected using dates between 1 Jan 2011 to 1 Sep 2011</span>"));
      RadGrid1.MasterTableView.Caption = "<span><br/>Exported by: John Smith</span>";
      RadGrid1.ExportSettings.OpenInNewWindow = true;
      RadGrid1.ExportSettings.ExportOnlyData = false;
     RadGrid1.MasterTableView.ExportToExcel();
}

Thanks,
Shinu.

[Justin Pretorius]

Brilliant!! Thank you for the swift response!!

[Paul]

I'm having issue with version 2013.2.717.40 with adding the same controls for the export and it not showing up at all.

[Paul]

It's working now.