CODEWITHSUNDEEP
javascriptjquerykendo-uikendo-gridkendo-asp.net-mvc
Ning
Ning

Reputation: 595

How to export hierarchy Kendo UI grid to excel including collapsed rows?

I have a 3-level hierarchy grid and need to export all the data including collapsed rows to excel. I am following this demo http://dojo.telerik.com/ApaqOJuv. But it only exports the expanded rows. How can I modify this solution so that it exports all the data?

Upvotes: 0

Views: 1819

Answers (1)

dev_in_progress
dev_in_progress

Reputation: 2494

If you want to export all data, with serverPaging set to true, then the only way to export it through kendo is to expand all data, when expanding you are populating grid with new data (sending a request to the server), after that, you can export. Keep in mind you will only export the first page if you want all data you will need to show all in one page. Otherwise, you will need to handle exporting on the server-side.

Why? As you can see in the console of posted example, data is loaded when you expand the grid, so if it's collapsed there is no data, therefore, you can't export something that does not exist's. Kendo export is client-side exporting which means export only what you see.

Upvotes: 0

Related Questions