Hi,
I have a table (grid like) in the detail section.
Is it possible to freeze the table header row when exporting to excel?
Now when exporting it just freezes the hole page header section but I want to include the table header row in the "freeze" and just scroll the data rows in excel.
/Mattias
I have a table (grid like) in the detail section.
Is it possible to freeze the table header row when exporting to excel?
Now when exporting it just freezes the hole page header section but I want to include the table header row in the "freeze" and just scroll the data rows in excel.
/Mattias
5 Answers, 1 is accepted
0
Hi Mattias,
Only the report page header section acts like native Excel page header section and this is by design. There is no easy way to do what you ask as the Table item can be placed in any data related section, while the native excel header can only be the first "section" in the document just like the report page header.
Best wishes,
Steve
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Only the report page header section acts like native Excel page header section and this is by design. There is no easy way to do what you ask as the Table item can be placed in any data related section, while the native excel header can only be the first "section" in the document just like the report page header.
Best wishes,
Steve
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
Mattias
Top achievements
Rank 1
Rank 1
answered on 21 Dec 2009, 07:29 AM
Ok, that is understandable!
In my page header I just have a logo and some heading text and this does not need to be freezed, as it is by default, how can I prevent this?
I tried to set the DefaultPageHeader to true but then the page header doesn't show up at all.
Is this the wrong property or am I missing something (I want to remove the freeze function completly)?
/Mattias
In my page header I just have a logo and some heading text and this does not need to be freezed, as it is by default, how can I prevent this?
I tried to set the DefaultPageHeader to true but then the page header doesn't show up at all.
Is this the wrong property or am I missing something (I want to remove the freeze function completly)?
/Mattias
0
Hello Mattias,
This is expected behavior of the native excel page sections - the headers/footers are only shown in the print dialog and not in the excel file itself.
Best wishes,
Steve
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
This is expected behavior of the native excel page sections - the headers/footers are only shown in the print dialog and not in the excel file itself.
Best wishes,
Steve
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
Farah
Top achievements
Rank 1
Rank 1
answered on 20 Jun 2014, 06:35 AM
I am trying to export report into excel but Page Footer is not showing, why this happened? although report export to other formats is working fine. Please Help!
0
Hello Farah,
Please check the Design Considerations for Excel Rendering article, and test the suggested setting for rendering the Page Header/Footer sections in Excel format, which is a logical page layout format.
Regards,
Stef
Telerik
Please check the Design Considerations for Excel Rendering article, and test the suggested setting for rendering the Page Header/Footer sections in Excel format, which is a logical page layout format.
Regards,
Stef
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.