New to KendoReact? Start a free 30-day trial

Export Data to Excel with Custom Header and Footer

Environment

Product Version3.15.0
ProductProgress® KendoReact

Description

How can I add a custom header and footer to the exported data to Excel?

Solution

This can be done by customizing the Workbook that will be exported. In this case, we have to add new rows to the current rows collection.

The following example shows how to:

  1. Add a new row at the beginning and at the end of the workbook.
  2. Apply additional settings to the cells.
  3. Freeze the first two rows in order to have the header and the column titles to be visible when scrolling.
Example
View Source
Edit In Stackblitz  
Change Theme:

In this article

Not finding the help you need?