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

Export hidden columns with Grid Excel Export

2 Answers 1730 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
EGrop
Top achievements
Rank 1
EGrop asked on 28 Nov 2018, 11:57 AM

Hi!

I have a grid which contains a columnChooser component and I want to export all columns (both visible and not visible) into an Excel file. The problem is that I cannot figure it out how could I export all columns because as it seems, this visible/not visible column filtering is happening inside this Excel Export component. Is this possible without turning all columns into visible?

 

Thank you for your time!

2 Answers, 1 is accepted

Sort by
0
Accepted
Dimiter Topalov
Telerik team
answered on 29 Nov 2018, 08:32 AM
Hello,

You can configure which columns will be exported, regardless of which columns are currently visible in the Grid, as described in the following section of our documentation:

https://www.telerik.com/kendo-angular-ui/components/grid/export/excel-export/#toc-customizing-exported-columns

I adjusted the example to feature a column menu with a column chooser:

https://stackblitz.com/edit/angular-u9ryap?file=app%2Fapp.component.ts

I hope this helps.

Regards,
Dimiter Topalov
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
EGrop
Top achievements
Rank 1
answered on 29 Nov 2018, 10:14 AM
Yes, it helped a lot. Thanks!
Tags
General Discussions
Asked by
EGrop
Top achievements
Rank 1
Answers by
Dimiter Topalov
Telerik team
EGrop
Top achievements
Rank 1
Share this question
or