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.
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
0
Kavita
Top achievements
Rank 1
Rank 1
answered on 25 Sep 2013, 10:17 AM
Hello telerik team,
Can you please help me solving this issue?
Its little urgent.
Can you please help me solving this issue?
Its little urgent.
0
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
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
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
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
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
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?
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
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
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.