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

Export To Excel with repeated RadGrid Headers

6 Answers 156 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Kavita
Top achievements
Rank 1
Kavita asked on 24 Sep 2013, 11:55 AM
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.
 

6 Answers, 1 is accepted

Sort by
0
Kavita
Top achievements
Rank 1
answered on 25 Sep 2013, 10:17 AM
Hello telerik team,
Can you please help me solving this issue?
Its little urgent.
0
Kostadin
Telerik team
answered on 27 Sep 2013, 07:50 AM
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.
0
Kavita
Top achievements
Rank 1
answered on 27 Sep 2013, 09:06 AM
I tried that link..but still i can not see any header or footer in excel report
0
Kostadin
Telerik team
answered on 02 Oct 2013, 06:33 AM
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.
0
Kavita
Top achievements
Rank 1
answered on 10 Oct 2013, 06:31 AM
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?

0
Kostadin
Telerik team
answered on 14 Oct 2013, 11:25 AM
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.
Tags
General Discussions
Asked by
Kavita
Top achievements
Rank 1
Answers by
Kavita
Top achievements
Rank 1
Kostadin
Telerik team
Share this question
or