The current option in the setup of Export query content to XLS only exports the data in its raw form
If I have a grid with grouping setup and total summaries etc it ignores all of that.
This kind of support will add MUCH more efficiency to Reporting
Kendo Grid Export does support this please see example
https://demos.telerik.com/kendo-ui/grid ... 1673835080
this was a response i got
It is possible to export a Kendo UI Grid with grouping to an Excel format while maintaining its layout formatting. The Kendo UI Grid provides a built-in Excel export feature that can export data to an Excel file, including group headers, footers, and aggregates. When exporting the Grid to Excel, the grouping information is retained, and the layout formatting of the Grid is preserved as much as possible. The exported data includes the group headers and footers, which can be used to maintain the grouping structure of the data in the exported Excel file. The Kendo UI Grid also provides options for customizing the Excel export, such as specifying which data should be exported, and controlling the formatting of the exported data.