Last Updated: 03 May 2023 11:58 by ADMIN
Created by: Huw
Comments: 1
Category: Excel Export
Type: Feature Request

Excel export a grid that is grouped and also set the state of whether the groups should be collapsed or not 

Is it possible to set the state of whether the groups are collapsed or not by default once you open the excel file, or is that not an option?

Last Updated: 26 Jan 2023 13:02 by ADMIN


We would like to export a repeatable header and footer with information when exporting the data of a KendoReact Grid to Excel. In the Excel Export API only information about footer, group footer and group header can be found, but they don't do what we want them to do. The only thing I could find here was this URL, but it also doesn't have a solution for our requirement: https://www.telerik.com/kendo-react-ui/components/knowledge-base/excel-export-with-custom-header-footer/

What we want can be inserted into Excel using Insert and then the Header and Footer button and will render a repeating header and footer for an entire page. You can see that in the attached screenshots. 

Is there a way to insert such a repeating header and footer? If not, are there any plans for the future or can you add this as a feature request?