Version

CellExporting Event

Occurs before a cell is exported to Excel.
Syntax
'Declaration
 
Public Event CellExporting As EventHandler(Of CellExportingEventArgs)
public event EventHandler<CellExportingEventArgs> CellExporting
Event Data

The event handler receives an argument of type CellExportingEventArgs containing data related to this event. The following CellExportingEventArgs properties provide information specific to this event.

PropertyDescription
Cancel (Inherited from System.ComponentModel.CancelEventArgs) 
CurrentColumnIndex (Inherited from Infragistics.Windows.DataPresenter.ExcelExporter.ExcelExportCancelEventArgs)Zero-based index of current exporting column in excel worksheet..
CurrentOutlineLevel (Inherited from Infragistics.Windows.DataPresenter.ExcelExporter.ExcelExportCancelEventArgs)Current outline level used for grouping.
CurrentRowIndex (Inherited from Infragistics.Windows.DataPresenter.ExcelExporter.ExcelExportCancelEventArgs)Zero-based index of current exporting row in excel worksheet.
CurrentWorksheet (Inherited from Infragistics.Windows.DataPresenter.ExcelExporter.ExcelExportCancelEventArgs)Current exporting worksheet.
Field Returns the field containing the cell.
FormatSettings (Inherited from Infragistics.Windows.DataPresenter.ExcelExporter.ExcelExportCancelEventArgs)Gets or sets the settings that should be applied to exported label. Settings specified on individual labels take precedence.
Record Returns the record containing the cell.
Value Gets or sets the value of the cell being exported.
Workbook (Inherited from Infragistics.Windows.DataPresenter.ExcelExporter.ExcelExportCancelEventArgs)Exporting workbook.
Remarks

The Field argument returns a reference to the associated field.

The Record argument returns a reference to the record containing the cell.

The Value argument returns the value of the cell.

Additionaly this event has Cancel, Workbook, CurrentWorksheet, CurrentRowIndex, CurrentColumnIndex, CurrentOutlineLevel arguments inherited from ExcelExportCancelEventArgs.

Use the Cancel argument to cancel cell exporting.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also