# Export Data to Excel with Custom Header and Footer

## Environment

<table>
	<tbody>
		<tr>
			<td>Product Version</td>
			<td>3.15.0</td>
		</tr>
		<tr>
			<td>Product</td>
			<td>Progress® KendoReact Grid</td>
		</tr>
	</tbody>
</table>

## 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](https://www.telerik.com/kendo-react-ui/components/excelexport/customization/) 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](https://www.telerik.com/kendo-react-ui/components/excelexport/api/KendoOoxml/) to the cells.
3. Freeze the first two rows in order to have the header and the column titles to be visible when scrolling.

[Demo Source](https://demos.telerik.com/kendo-react-ui/knowledge-base/grid/excel-export-header-footer/source.txt)