devexpress-examples/winforms-pivotgrid--customize-cells-in-the-exported-excel-document

The following example shows how to customize cells appearance in the exported document when you export the Pivot Grid to XLSX (or XLS) format.

Pivot Grid for WinForms - Сustomize Сells in the Exported Excel Document

The following example shows how to customize cell appearance in the exported document when you export the Pivot Grid to XLSX (or XLS) format. In this example, custom appearance settings (the azure background and italic font) are applied to the cells that correspond to the Pivot Grid's data area.

Files to Review

Form1.cs (VB: Form1.vb)

Example Overview

Handle the PivotXlsxExportOptions.CustomizeCell or PivotXlsExportOptions.CustomizeCell event to customize cell appearance in the exported document.

Use the e.ExportArea property to identify the cell location in the exported Excel document. The e.Formatting property sets the cell format.

Documentation

• Exporting
• Data Area

More Examples

WinForms - How to Print a Document that Contains Pivot and Chart Controls