export to excel header

[Anjali]

Hello All,

  I exported the telerik grid to excel by using the command below

RadGrid_DetailsView.MasterTableView.ExportToExcel();

I want to set the header on each page that says
"This is the DRAFT Data".

How can I accomplish that.

Thanks.

[Princy]

Hello Anjali,

Try the following code snippet in ExcelMLExportRowCreated event to set header for exported excel.

 

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 = "This is the DRAFT Data";
        }
}

Thanks,
Princy.

[Anjali]

Thanks Princy!! Everything worked like magic. I am also exporting the radgrid to MS word. I need to put the headers saying "This is draft data" on each page of the MS word document. How can I accomplish that?

Please let me know.

Thanks again for all your help.

[Bruno]

Princy, this was a good one - thanks for that
I found that I can do the same in the ExcelMLWorkbookCreated event also but not sure if this is a better way

[Princy]

Hello Anjali,

Try the following code snippet to set header for exported Word.

C#:

protected void RadGrid1_PdfExporting(object sender, GridPdfExportingArgs e)
{
    e.RawHTML = "<div This is draft data</div>" + e.RawHTML;
}

Thanks,
Princy.

[Anjali]

Thanks Princy!! Worked again.

[Daniel]

Hello,

There are two minor issues in this code posted by Princy:
1) You have to use GridExporting event if you need to add code when exporting to Word
2) The starting tag of the DIV element is not closed properly.

Regards,
Daniel
the Telerik team

[Anjali]

The div tag issue is minor. When i wrote the code, i fixed that in my code, but I tried to use Gridexporting event for expoting to word and i got the error that e.RawHTMl does not exists in GridExporting event so I ended up using pdfExporting event.

[Daniel]

Hello Anjali,

PdfExporting event is meaningful only when exporting to PDF format. It is exposed to allow the user to access the HTML code before it is converted to binary.
GridExporting event will be triggered for all export formats, including PDF export. Here, you can access the final output code before it is streamed to the file.
You can access the output code using:
- e.ExportOutput for GridExporting
- e.RawHTML for PdfExporting

Regards,
Daniel
the Telerik team