Grid Export to Excel freeze row?

9 posts, 1 answers
  1. Paul J
    Paul J avatar
    101 posts
    Member since:
    Nov 2008

    Posted 14 May 2010 Link to this post

    When exporting a radGrid to excel, is there a way to pro grammatically freeze the first row of the excel document, just like as if I press the freeze pane option in excel?

    Thanks.
  2. Answer
    Radoslav
    Admin
    Radoslav avatar
    1564 posts

    Posted 17 May 2010 Link to this post

    Hello Paul,

    Currently the RadGrid does not support the desired functionality. However in the next major release - Q2 2010 the functionality for frozen panes in exported RadGrid to excel will be implemented.

    Best wishes,
    Radoslav
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Paul J
    Paul J avatar
    101 posts
    Member since:
    Nov 2008

    Posted 17 May 2010 Link to this post

    Thanks for letting me know. looking forward to Q2 then ;)
  5. GTL Dev
    GTL Dev avatar
    12 posts
    Member since:
    May 2011

    Posted 20 Jun 2011 Link to this post

    Has this ever been implemented yet?
  6. Daniel
    Admin
    Daniel avatar
    4945 posts

    Posted 20 Jun 2011 Link to this post

    Hello,

    Yes, I confirm this functionality is already implemented. Please try the following online demo:
    Regards
    Daniel
    the Telerik team

    Browse the vast support resources we have to jump start 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.

  7. Casto
    Casto avatar
    7 posts
    Member since:
    Nov 2014

    Posted 26 Jan Link to this post

    I want to do the exact same thing, but i don't find how in the documentation. Could you point me on the right direction?

     The online demo using ExcelML does not freeze the first row of the excel. It only adds filtering.

  8. Casto
    Casto avatar
    7 posts
    Member since:
    Nov 2014

    Posted 26 Jan Link to this post

    I found the solution in other people code, this is what i am using to freeze only the header row of the worksheet[0]

             protected void RadGridReport_ExcelMLGridExporting(object sender, GridExcelMLWorkBookCreatedEventArgs e)
            {
                e.WorkBook.Worksheets[0].WorksheetOptions.AllowFreezePanes = true;

                e.WorkBook.Worksheets[0].WorksheetOptions.TopRowBottomPaneNumber = 1;
                e.WorkBook.Worksheets[0].WorksheetOptions.SplitHorizontalOffset = 1;

                e.WorkBook.Worksheets[0].WorksheetOptions.ActivePane = 2;
            }

  9. Fernando
    Fernando avatar
    7 posts
    Member since:
    Apr 2015

    Posted 06 Apr Link to this post

    How to freeze with  Biff Format?
  10. Daniel
    Admin
    Daniel avatar
    4945 posts

    Posted 07 Apr Link to this post

    Hello Fernando,

    I'm afraid this functionality is not supported for the BIFF format.
    Please accept our apologies for any inconvenience caused.

    Regards,
    Daniel
    Telerik
    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017