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.v20.1.Core.dll

Declaration

public event SkipFooterRowEventHandler SkipFooterRow
Public Event SkipFooterRow As SkipFooterRowEventHandler

Remarks

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.

Example

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;
}

Implements

DevExpress.Export.IDataAwareExportOptions.SkipFooterRow
See Also