This is a migrated thread and some comments may be shown as answers.

Grid Export to Excel freeze row?

8 Answers 299 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Paul J
Top achievements
Rank 1
Paul J asked on 14 May 2010, 02:34 PM
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.

8 Answers, 1 is accepted

Sort by
0
Accepted
Radoslav
Telerik team
answered on 17 May 2010, 10:20 AM
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.
0
Paul J
Top achievements
Rank 1
answered on 17 May 2010, 04:22 PM
Thanks for letting me know. looking forward to Q2 then ;)
0
GTL Dev
Top achievements
Rank 2
answered on 20 Jun 2011, 04:46 PM
Has this ever been implemented yet?
0
Daniel
Telerik team
answered on 20 Jun 2011, 08:13 PM
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.

0
Casto
Top achievements
Rank 1
answered on 26 Jan 2016, 12:30 PM

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.

0
Casto
Top achievements
Rank 1
answered on 26 Jan 2016, 01:31 PM

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;
        }

0
Fernando
Top achievements
Rank 2
answered on 06 Apr 2016, 01:17 PM
How to freeze with  Biff Format?
0
Daniel
Telerik team
answered on 07 Apr 2016, 07:12 AM
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.
Tags
Grid
Asked by
Paul J
Top achievements
Rank 1
Answers by
Radoslav
Telerik team
Paul J
Top achievements
Rank 1
GTL Dev
Top achievements
Rank 2
Daniel
Telerik team
Casto
Top achievements
Rank 1
Fernando
Top achievements
Rank 2
Share this question
or