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

Radgrid doesnt export Grid-Footer to Excel (ExcelML)

7 Answers 282 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Thomas
Top achievements
Rank 1
Thomas asked on 29 Nov 2010, 02:25 PM

Hello,

i want to export the content of my RadGrid to Excel (Format: ExcelML). I have a Grid-Footer with Aggregates (Aggregate="Sum"), but it will not be exported to EXCEL.

Can anybody help me?

Best Regards

Thomas

7 Answers, 1 is accepted

Sort by
0
Accepted
Daniel
Telerik team
answered on 29 Nov 2010, 03:40 PM
Hello Thomas,

It is not possible to export the Footer item out-of-the-box when using the ExcelML format. You could, however add this row manually as demonstrated in the attached project.

Kind regards,
Daniel
the Telerik team
Browse the vast support resources we have to jumpstart 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
Thomas
Top achievements
Rank 1
answered on 29 Nov 2010, 04:01 PM
Thank you very much! It works!
0
Shubham
Top achievements
Rank 1
answered on 02 Jan 2014, 05:03 PM
xv

Admin edit: Images deleted due to client request.
0
Kostadin
Telerik team
answered on 07 Jan 2014, 11:52 AM
Hi Shubham,

When you are having a hierarchical structure the child tables are exported with one column inward. I am afraid that this is expected behavior and could not be change.


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
Shubham
Top achievements
Rank 1
answered on 07 Jan 2014, 01:43 PM
Hi Kostadin

Thanks for the Information
Ya I got that but now one more thing is  that when am trying to export  the footer also then formatting (like column header should be bold and font ) get reformat(was not appropriate  like last when we were not fetching footer).  how  to manage these things 

Thanks
0
Maria Ilieva
Telerik team
answered on 10 Jan 2014, 10:03 AM
Hi Shubham,

Could you please elaborate a bit more on the problematic behavior you are currently facing? Sending some screenshots that presents the normal and the problematic appearance will help us provide proper solution for your case.

Regards,
Maria Ilieva
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
Shubham
Top achievements
Rank 1
answered on 21 Jan 2014, 01:37 PM
Thanks   Telerik  team
Tags
Grid
Asked by
Thomas
Top achievements
Rank 1
Answers by
Daniel
Telerik team
Thomas
Top achievements
Rank 1
Shubham
Top achievements
Rank 1
Kostadin
Telerik team
Maria Ilieva
Telerik team
Share this question
or