Add title to excel of ExcelML type for radgid

[Ram]

Hi all,
I'm exporting the excel of radgrid.
My excel format is ExcelML.
I want to add title on head of the excel. In Html format Im getting title by setting the caption of mastertableview of grid
But I dont know why its not coming for ExcelML format and how to add.
Please help me in this.
My code..
Radgrid.ExportSettings.Excel.Format = Telerik.Web.UI.GridExcelExportFormat.ExcelML;

Please provide me the code.
I dont have download access.

[Shinu]

Hello Ram,

Try the following code snippet.
C#:

protected void RadGrid1_ExcelMLExportRowCreated(object sender, Telerik.Web.UI.GridExcelBuilder.GridExportExcelMLRowCreatedArgs e)
{
   if (e.RowType == Telerik.Web.UI.GridExcelBuilder.GridExportExcelMLRowType.HeaderRow)
   {
      e.Worksheet.WorksheetOptions.PageSetup.PageHeaderElement.Data = "Your Text";
  }
}

-Shinu.

[Ram]

Hi
Thanks for reply but It didn't work for me.

[Mira]

Hello Ram,

The code Shinu posted adds the specified text in the Page Header Element which can be seen when printing or when viewing the Page Layout in Excel.
If you want it to be visible on initial opening, you can add a dummy row with the desired text when exporting.

I hope this helps.

Kind regards,
Mira
the Telerik team

[Mohamed Salah Al-Din]

Dear Mira ,
How I can add this dummy row while exporting?

Best Regards,
Mohamed Salah Al-Din

[Shinu]

Hello Mohamed,

Try the following code.
C#:

protected void RadGrid1_GridExporting(object sender, GridExportingArgs e)
{
   e.ExportOutput = e.ExportOutput.Replace("</body>", "<div style=\"color:Red;\">Your text</div></body>");
}

-Shinu.