ExcelCellToDataTableCellConvertingEventArgs Class

public sealed class ExcelCellToDataTableCellConvertingEventArgs : EventArgs

Public NotInheritable Class ExcelCellToDataTableCellConvertingEventArgs
    Inherits EventArgs

Inheritance:: System.Object
System.EventArgs
ExcelCellToDataTableCellConvertingEventArgs

Gets or sets the action which will be executed after event, see ExtractDataEventAction.

public ExtractDataEventAction Action { get; set; }

Public Property Action As ExtractDataEventAction

Gets the destination DataTable

public DataTable DataTable { get; }

Public ReadOnly Property DataTable As DataTable

Gets the destination column index in DataTable.

public int DataTableColumnIndex { get; }

Public ReadOnly Property DataTableColumnIndex As Integer

Gets the destination column type in DataTable.

public Type DataTableColumnType { get; }

Public ReadOnly Property DataTableColumnType As Type

Gets or sets the value which will be inserted into destination DataTable cell.

public object DataTableValue { get; set; }

Public Property DataTableValue As Object

Gets the source ExcelCell.

public ExcelCell ExcelCell { get; }

Public ReadOnly Property ExcelCell As ExcelCell

Gets a value indication whether current DataTableValue can be converted into DataTable cell.

public bool IsDataTableValueValid { get; }

Public ReadOnly Property IsDataTableValueValid As Boolean

If this value is false, you need to set an appropriate DataTableValue before exiting event handler or SpreadsheetException will be thrown.