Export To Excel with repeated RadGrid Headers

7 posts, 0 answers
  1. Kavita
    Kavita avatar
    39 posts
    Member since:
    Feb 2013

    Posted 24 Sep 2013 Link to this post

    I am using export to excel of RadGrid with html format.

    When I export the RadGird to Excel, I want Grid Header rows to repeat across pages when the content exceeds more than one page in exported file.
    Same is needed when I use Format= "ExcelML"

    Please help me.
     
  2. Kavita
    Kavita avatar
    39 posts
    Member since:
    Feb 2013

    Posted 25 Sep 2013 Link to this post

    Hello telerik team,
    Can you please help me solving this issue?
    Its little urgent.
  3. Kostadin
    Admin
    Kostadin avatar
    1733 posts

    Posted 27 Sep 2013 Link to this post

    Hello Kavita,

    I am afraid that repeating of header row on each page is not supported scenario. The only format which supports header and footer is HTML excel format, so you could manually implement a header row and disable the default one. This way you could achieve your requirement. Please check out the following help article for additional information.

    Regards,
    Kostadin
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
  4. Kavita
    Kavita avatar
    39 posts
    Member since:
    Feb 2013

    Posted 27 Sep 2013 Link to this post

    I tried that link..but still i can not see any header or footer in excel report
  5. Kostadin
    Admin
    Kostadin avatar
    1733 posts

    Posted 02 Oct 2013 Link to this post

    Hello Kavita,

    I prepared a small sample where I demonstrated how to add a header and footer when HTML or ExcelML format is used. Keep in mind that the header and footer are only visible when printing the grid.

    Regards,
    Kostadin
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
  6. Kavita
    Kavita avatar
    39 posts
    Member since:
    Feb 2013

    Posted 10 Oct 2013 Link to this post

    hi,
    I referred your code.
    I got footer as well as repeated header in print.
    But i have one problem.
    The header is not showing when we export to excel.
    It is only visible on print preview.
    So i gave caption like this

     gdCstRecovery.MasterTableView.Caption = "<h3>Jay's S/U Cst Recovery</h3>"

    but now when i print preview it, two two headers are showing.
    How can i make only one header shown in both.
    I want it to be shown on excel sheet also.
    And i have one more issue.
    I also want the radgrid column header to repeat in print per page.
    Is this possible?

  7. Kostadin
    Admin
    Kostadin avatar
    1733 posts

    Posted 14 Oct 2013 Link to this post

    Hello Kavita,

    I am afraid that this could not be achieved as you have to either hide the grid header and display only the page header or leave it visible and display the grid header and the page header. The only possible solution is to set a grid header to the page header as I already demonstrated in my previous reply.

    Regards,
    Kostadin
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
Back to Top