Hi Guys,
When exporting a groupped grid to excel the resulting excel file has data groupping acomplished by way of indenting of rows, but excel file format supports native groupping of data which enables much richer data analysis capability.
I would like to know if adding this capability to exported excel files is currently on the radar.
Cheers!
When exporting a groupped grid to excel the resulting excel file has data groupping acomplished by way of indenting of rows, but excel file format supports native groupping of data which enables much richer data analysis capability.
I would like to know if adding this capability to exported excel files is currently on the radar.
Cheers!
1 Answer, 1 is accepted
0
Hi,
We evaluated the built-in Excel grouping but we couldn't find a way to make it work as the Kendo UI Grid grouping does. For example we couldn't find a way to group by a column value - only by introducing sub totals which once collapsed didn't show the grouping value. Perhaps we just haven't found the right settings. If there is a way to do grouping in Excel in the exact same way the Kendo UI grid does it we would consider adding support for that in a future release.
Regards,
Atanas Korchev
Telerik
We evaluated the built-in Excel grouping but we couldn't find a way to make it work as the Kendo UI Grid grouping does. For example we couldn't find a way to group by a column value - only by introducing sub totals which once collapsed didn't show the grouping value. Perhaps we just haven't found the right settings. If there is a way to do grouping in Excel in the exact same way the Kendo UI grid does it we would consider adding support for that in a future release.
Regards,
Atanas Korchev
Telerik
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!