XlsExportOptionsEx.SkipFooterRow Event

Allows you to hide certain summary footers (or certain multi-line summary footers’ lines) from the exported document.Only available in data-aware export mode.

Namespace: DevExpress.XtraPrinting

Assembly: DevExpress.Printing.v21.1.Core.dll


public event SkipFooterRowEventHandler SkipFooterRow


The SkipFooterRow event fires repeatedly when exporting each group summary footer and total summary footer. If a footer consists of multiple lines, the SkipFooterRow event fires for each of these lines.

The event’s parameters allow you to identify the currently processed footer (or a line within a footer). To hide a footer (its line) from the export output, set the SkipFooterRow property to true.


The following example exports a Data Grid to XLSX format while hiding group summary footers (if any) in the export output.

private void btnExport_Click(object sender, EventArgs e) {
    string path = "grid-export.xlsx";
    XlsxExportOptionsEx options = new XlsxExportOptionsEx();
    options.SkipFooterRow += Options_SkipFooterRow;
    gridView1.ExportToXlsx(path, options);

// Hide group summary footers 
private void Options_SkipFooterRow(DevExpress.Export.SkipFooterRowEventArgs e) {
    if (e.AreaType== DevExpress.Export.SheetSkipRowAreaType.GroupFooter)
        e.SkipFooterRow = true;
See Also