XlsxExportOptionsEx.CustomizeSheetFooter Event

Allows you to customize the footer in the output document. Only available in data-aware export mode.

Namespace: DevExpress.XtraPrinting

Assembly: DevExpress.Printing.v24.2.Core.dll

Declaration

C#

public event CustomizeSheetFooterEventHandler CustomizeSheetFooter

VB.NET

Public Event CustomizeSheetFooter As CustomizeSheetFooterEventHandler

Remarks

To learn more about the functionality provided by this event, see XlsExportOptionsEx.CustomizeSheetHeader.

Example

This example uses the XlsxExportOptionsEx.CustomizeSheetFooter event to add a footer to an XLSX document (a result of data exporting from a Grid Control). In this event handler, two new rows are added to the output document by calling the AddRow event method, and their formatting is specified using objects of the XlFormattingObject class.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/winforms-grid-customize-data-aware-export-output

Form1.cs

void options_CustomizeSheetFooter(ContextEventArgs e){
    // Add an empty row to the document's footer.
    e.ExportContext.AddRow();

    // Create a new row.
    var firstRow = new CellObject();
    // Specify row values.
    firstRow.Value = @"The report is generated from the NorthWind database.";
    // Specify the cell content alignment and font settings.
    var rowFormatting = CreateXlFormattingObject(true, 18);
    rowFormatting.Alignment.HorizontalAlignment = XlHorizontalAlignment.Left;
    firstRow.Formatting = rowFormatting;
    // Add the created row to the output document. 
    e.ExportContext.AddRow(new[]{ firstRow });

    // Create one more row.
    var secondRow = new CellObject();
    // Specify the row value. 
    secondRow.Value = @"The addresses and phone numbers are fictitious.";
    // Change the row's font settings.
    rowFormatting.Font.Size = 14;
    rowFormatting.Font.Bold = false;
    rowFormatting.Font.Italic = true;  
    secondRow.Formatting = rowFormatting;
    // Add this row to the output document.
    e.ExportContext.AddRow(new[]{ secondRow });
}

Form1.vb

Private Sub options_CustomizeSheetFooter(ByVal e As ContextEventArgs)
    ' Add an empty row to the document's footer.
    e.ExportContext.AddRow()

    ' Create a new row.
    Dim firstRow = New CellObject()
    ' Specify row values.
    firstRow.Value = "The report is generated from the NorthWind database."
    ' Specify the cell content alignment and font settings.
    Dim rowFormatting = CreateXlFormattingObject(True, 18)
    rowFormatting.Alignment.HorizontalAlignment = XlHorizontalAlignment.Left
    firstRow.Formatting = rowFormatting
    ' Add the created row to the output document. 
    e.ExportContext.AddRow({ firstRow })

    ' Create one more row.
    Dim secondRow = New CellObject()
    ' Specify the row value. 
    secondRow.Value = "The addresses and phone numbers are fictitious."
    ' Change the row's font settings.
    rowFormatting.Font.Size = 14
    rowFormatting.Font.Bold = False
    rowFormatting.Font.Italic = True
    secondRow.Formatting = rowFormatting
    ' Add this row to the output document.
    e.ExportContext.AddRow({ secondRow })
End Sub

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the CustomizeSheetFooter event.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

winforms-grid-customize-data-aware-export-output/CS/GridDataAwareExportCustomization/Form1.cs#L50

options.CustomizeCell += options_CustomizeCell;
options.CustomizeSheetFooter += options_CustomizeSheetFooter;
options.AfterAddRow += options_AfterAddRow;

wpf-data-grid-add-page-headers-and-footers-to-exported-data/CS/GridPrint/Window1.xaml.cs#L44

options.CustomizeSheetHeader += options_CustomizeSheetHeader;
options.CustomizeSheetFooter += options_CustomizeSheetFooter;
view.ExportToXlsx("GridExportExcel.xlsx", options);

VB.NET

winforms-grid-customize-data-aware-export-output/VB/GridDataAwareExportCustomization/Form1.vb#L53

AddHandler options.CustomizeCell, AddressOf options_CustomizeCell
AddHandler options.CustomizeSheetFooter, AddressOf options_CustomizeSheetFooter
AddHandler options.AfterAddRow, AddressOf options_AfterAddRow

wpf-data-grid-add-page-headers-and-footers-to-exported-data/VB/GridPrint/Window1.xaml.vb#L52

AddHandler options.CustomizeSheetHeader, AddressOf options_CustomizeSheetHeader
AddHandler options.CustomizeSheetFooter, AddressOf options_CustomizeSheetFooter
Me.view.ExportToXlsx("GridExportExcel.xlsx", options)