Export Data to Excel with Custom Header and Footer

Environment

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.