Radgrid doesnt export Grid-Footer to Excel (ExcelML)

8 posts, 1 answers
  1. Thomas
    Thomas avatar
    11 posts
    Member since:
    Sep 2010

    Posted 29 Nov 2010 Link to this post

    Hello,

    i want to export the content of my RadGrid to Excel (Format: ExcelML). I have a Grid-Footer with Aggregates (Aggregate="Sum"), but it will not be exported to EXCEL.

    Can anybody help me?

    Best Regards

    Thomas

  2. Answer
    Daniel
    Admin
    Daniel avatar
    4943 posts

    Posted 29 Nov 2010 Link to this post

    Hello Thomas,

    It is not possible to export the Footer item out-of-the-box when using the ExcelML format. You could, however add this row manually as demonstrated in the attached project.

    Kind regards,
    Daniel
    the Telerik team
    Browse the vast support resources we have to jumpstart your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Thomas
    Thomas avatar
    11 posts
    Member since:
    Sep 2010

    Posted 29 Nov 2010 Link to this post

    Thank you very much! It works!
  5. Shubham
    Shubham avatar
    32 posts
    Member since:
    May 2013

    Posted 02 Jan 2014 Link to this post

    xv

    Admin edit: Images deleted due to client request.
  6. Kostadin
    Admin
    Kostadin avatar
    1708 posts

    Posted 07 Jan 2014 Link to this post

    Hi Shubham,

    When you are having a hierarchical structure the child tables are exported with one column inward. I am afraid that this is expected behavior and could not be change.


    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.
  7. Shubham
    Shubham avatar
    32 posts
    Member since:
    May 2013

    Posted 07 Jan 2014 Link to this post

    Hi Kostadin

    Thanks for the Information
    Ya I got that but now one more thing is  that when am trying to export  the footer also then formatting (like column header should be bold and font ) get reformat(was not appropriate  like last when we were not fetching footer).  how  to manage these things 

    Thanks
  8. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 10 Jan 2014 Link to this post

    Hi Shubham,

    Could you please elaborate a bit more on the problematic behavior you are currently facing? Sending some screenshots that presents the normal and the problematic appearance will help us provide proper solution for your case.

    Regards,
    Maria Ilieva
    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.
  9. Shubham
    Shubham avatar
    32 posts
    Member since:
    May 2013

    Posted 21 Jan 2014 Link to this post

    Thanks   Telerik  team
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017