RadGrid Export to excel/pdf with page settings

[Vijayaraj]

I wish to export the content in a RadGrid to excel/pdf format by setting the header and footer for each and every page. Is there any ways to accomplish that.

- I know that there is a pageTitle property for pdf export, but Is there a way to include formatted headers than title for the grid data.
   (ie:- I would include date/time, pagenumber, company/author name, copyrights message.

Thanks,
Vijayaraj

[Daniel]

Hello Vijayaraj,

PageTitle property supports plain text only - it is not possible to insert anything but simple text.

I will take that you use the HTML Excel format. In this case you can add a custom header this way:

protected void RadGrid1_HTMLExporting(object sender, GridHTMLExportingEventArgs e)
{
    e.Styles.Append("table @page {" +
        @"mso-header-data:'&CSAMPLE HEADER\000APage &P'; " +
        @"mso-footer-data:'Date\: &D' }");
}

&L, &R, &C - Alignment (left, right, center)
&D, &T - Date/Time
&P, &N - Page number/Total pages
&B, &I - Bold/Italic

Best regards,
Daniel
the Telerik team

[Vijayaraj]

Hi,

Thank you very much, but that solution is not working for me.
Could you please suggest me whether it requires any specific parameter.

Thanks,
Vijay

[Vijayaraj]

I actually did a work around to get data as header using the ExcelMl Export.

if (e.Worksheet.Table.Rows.Count == 1)
 {
      RowElement row = new RowElement();
      CellElement cell = new CellElement();
      string cellText = "This is a Sample cell header";
      cell.Data.DataItem = cellText == " " ? "" : cellText;
      row.Cells.Add(cell);
      e.Worksheet.Table.Rows.Insert(0,row);
}

But now the problem is with the excel filter, which is visible at the first row were I have added the header. Is there a way to set the excel filter at the desired row.

Thanks in advance.

Cheers,
Vijay

[Daniel]

Hello Vijay,

You can change the location of the autofilter this way:

e.Worksheet.AutoFilter.Range="R2C1:R2C4";

R2C1:R2C4 = Row 2, Column 1 to Row 2, Column 4

Kind regards,
Daniel
the Telerik team

[Vijayaraj]

Thanks, It works for me.

[Vijayaraj]

While exporting in ExcelML format it doesnt export the computed column and the footer. But the same works fine when i export excel in Html format.

Is there a way to accomplish the computed column and computed footer in EXcelML exporting?

Regards,
Vijay

[Daniel]

Hello Vijayaraj,

Calculated values won't be exported out-of-the-box but you could add them on your own using a workaround similar to that demonstrated in the attached project.

Best regards,
Daniel
the Telerik team

[jagan]

Hi Daniel,

I would like to export radgrid with header logo image with text in the left and right of the page and also page number in the footer of each and every page. Please see the attached file which is the output I need. Here the image logo is dynamically given by the user. Is it possible to get the format which I have mentioned in the screen shot for all the formats(PDF/Word/Excel) for the hierarchy grid using inbuilt telerik export methods. Currently We are using telerik File version: 2012.3.1308.35.

Thanks,
R.Jaganathan

[Daniel]

Hello,

This is possible with the PDF format only. You can find information about the header/footer support in our online documentation:
PDF Export

Regards,
Daniel
Telerik

[bharath]

in radgrid export settings iam not getting <pdf>   </pdf> tags.
iam getting only pdf ,excel, csv options..
iwant to set page header and footer while export to pdf of radgrid data.

/Thanks

Bharath

[Princy]

Hi Bharath,

From Q2 2013 PDF export supports header and footer. PageHeader element holds the header cells while the PageFooter elements contains the footer cells and they are applicable to ExportSettings-Pdf tab.Please make sure that you are using the latest version.This is the code I tried and it works fine at my end using latest version.

ASPX:

<ExportSettings>
    <Pdf>
        <PageHeader>
            <LeftCell Text="Company Name" TextAlign="Left" />
        </PageHeader>
        <PageFooter>
            <MiddleCell Text="<?page-number?>" />
        </PageFooter>
    </Pdf>
</ExportSettings>

Thanks,
Princy

[Marie]

Could we put the page number and the page total?
page1 : 1/3
page2: 2/3
page3: 3/3
Thanks

[Daniel]

Hello Marie,

I'm afraid the total number of pages value is not available due to internal limitation.
Please excuse us for any inconvenience caused.

Regards,
Daniel
Telerik