Hi,
How can I export a hierarchical grid to Excel so that we don't get security warnings? From GridView documentation and this forum it looks like hierarchical grids can only be exported as HTML or CSV, which doesn't fit our requirements. Could you confirm that it is not possible to export nested grids as xslx? What is the best approach - make custom export all together, or use Telerik API?
Thanks
Alex
4 Answers, 1 is accepted
0
Hello Alex,
I am not entirely sure of the type of security warning that you are referring to. However you can check out the Warning message when opening the excel file article which describes a possible warning you can encounter and the steps to prevent it.
As for exporting a hierarchical RadGridView, I am attaching a sample project demonstrating how you can utilize the ElementExportedToDocument event to modify the exported workbook in order to achieve that requirement.
Regards,
Vladimir Stoyanov
Progress Telerik
I am not entirely sure of the type of security warning that you are referring to. However you can check out the Warning message when opening the excel file article which describes a possible warning you can encounter and the steps to prevent it.
As for exporting a hierarchical RadGridView, I am attaching a sample project demonstrating how you can utilize the ElementExportedToDocument event to modify the exported workbook in order to achieve that requirement.
Regards,
Vladimir Stoyanov
Progress Telerik
Want to extend the target reach of your WPF applications, leveraging iOS, Android, and UWP? Try UI for Xamarin, a suite of polished and feature-rich components for the Xamarin framework, which allow you to write beautiful native mobile apps using a single shared C# codebase.
0
Alex
Top achievements
Rank 1
Rank 1
answered on 06 Mar 2018, 11:00 AM
Hi Vladimir.
Thank you. I attempted your solution but we are stuck with previous version of WPF UI. Is there any solution for pre September 2017 API?
0
Hello Alex,
I tested the attached project with the R1 2017 version of the dlls and it is working as expected on my side. I am attaching the project back with all of the binaries from R1 2017 added in the libs folder for your reference. Please give the project a try and let me know if I can be of any further assistance.
Regards,
Vladimir Stoyanov
Progress Telerik
I tested the attached project with the R1 2017 version of the dlls and it is working as expected on my side. I am attaching the project back with all of the binaries from R1 2017 added in the libs folder for your reference. Please give the project a try and let me know if I can be of any further assistance.
Regards,
Vladimir Stoyanov
Progress Telerik
Want to extend the target reach of your WPF applications, leveraging iOS, Android, and UWP? Try UI for Xamarin, a suite of polished and feature-rich components for the Xamarin framework, which allow you to write beautiful native mobile apps using a single shared C# codebase.
0
Hello Alex,
You can find the project attached to this reply.
Regards,
Vladimir Stoyanov
Progress Telerik
You can find the project attached to this reply.
Regards,
Vladimir Stoyanov
Progress Telerik
Want to extend the target reach of your WPF applications, leveraging iOS, Android, and UWP? Try UI for Xamarin, a suite of polished and feature-rich components for the Xamarin framework, which allow you to write beautiful native mobile apps using a single shared C# codebase.