WPF Data Grid - Add Page Headers and Footers to Exported Data

This example exports the contents of our WPF GridControl with specified page headers and footers.

WYSIWYG Technique

1. Create custom templates for headers and footers.
2. Create a new instance of the PrintableControlLink class.
3. Assign the templates to the PageHeaderTemplate and PageFooterTemplate properties.
4. Print or export the WPF GridControl in WYSIWYG mode.

Refer to the following help topic for more information: WYSIWYG Export.

Data-Aware Technique

1. Create a new instance of the XlsxExportOptionsEx class.
2. Handle both XlsxExportOptionsEx.CustomizeSheetHeader and XlsxExportOptionsEx.CustomizeSheetFooter events.
3. In the event handlers, specify custom page headers and footers.
4. Export the WPF GridControl in XLSX format.

Refer to the following help topic for more information: Data-Aware Export.

Files to look at

• Window1.xaml (VB: Window1.xaml)
• Window1.xaml.cs (VB: Window1.xaml.vb)

Documentation

• Printing and Exporting
• Generate a Grid-Based Report

More Examples

• WPF Data Grid - Customize the Print and Export Appearance
• WPF Data Grid - Export to a Native Excel Table

Does this example address your development requirements/objectives?

(you will be redirected to DevExpress.com to submit your response)