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?
Hi,
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?
Regards,
Oliver