Progress® KendoReact Feedback Portal
Back to Feed
Request a Feature Report a Bug
Unplanned
Last Updated: 26 Jan 2023 13:02 by ADMIN
Oliver
Created on: 19 Jan 2023 10:43
Category: Excel Export
Type: Feature Request
3
Repeatable header and footer for the Excel export of a KendoReact grid

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

Attached Files:
5 comments
ADMIN
Filip
Posted on: 26 Jan 2023 13:02

Hi, Oliver,

This will also be added to the request.

Regards,
Filip
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Oliver
Posted on: 20 Jan 2023 12:28

Please add the possibility to set oddHeader and oddFooter in the WorkbookOptions. In the XML structure of an xlsx document it looks like this:


ADMIN
Filip
Posted on: 20 Jan 2023 10:53

Hello, Oliver,

No plans have been made for implementing this feature so far. I have transferred this ticket to an official feature request.

I hope this helps.

Regards,
Filip
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Oliver
Posted on: 20 Jan 2023 10:12

Hi Filip,

are there any plans for the future to add this as a feature or can you open a feature request to this?

We get dynamic data to be displayed in a header or footer. It therefore makes no sense to edit the Excel document afterwards. So we would have to transfer the data directly into the Excel document via the API.

Regards,

Oliver

ADMIN
Filip
Posted on: 20 Jan 2023 09:49

Hi, Oliver,

Thank you for reaching out to us.

The ExcelExport component is designed to output the provided data and it is possible to render a footer and header as you have discovered, however, making them repeat is not supported at this point. 

This has to be done manually to the file from the Excel options:

https://www.extendoffice.com/documents/excel/2907-excel-insert-header-footer-on-all-sheets.html

I hope this helps.

Regards,
Filip
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Create an account Log In
View
Type
Status
Category