ExcelCellToDataTableCellConvertingEventArgs Class
Arguments for ExcelCellToDataTableCellConverting event.
public sealed class ExcelCellToDataTableCellConvertingEventArgs : EventArgs
Public NotInheritable Class ExcelCellToDataTableCellConvertingEventArgs
Inherits EventArgs
- Inheritance:
- ExcelCellToDataTableCellConvertingEventArgs
Properties
Action
Gets or sets the action which will be executed after event, see ExtractDataEventAction.
public ExtractDataEventAction Action { get; set; }
Public Property Action As ExtractDataEventAction
Property Value
DataTable
Gets the destination DataTable
Property Value
DataTableColumnIndex
Gets the destination column index in DataTable.
public int DataTableColumnIndex { get; }
Public ReadOnly Property DataTableColumnIndex As Integer
Property Value
- System.Int32
DataTableColumnType
Gets the destination column type in DataTable.
public Type DataTableColumnType { get; }
Public ReadOnly Property DataTableColumnType As Type
Property Value
DataTableValue
Gets or sets the value which will be inserted into destination DataTable cell.
Property Value
ExcelCell
Gets the source ExcelCell.
Property Value
IsDataTableValueValid
Gets a value indication whether current DataTableValue can be converted into DataTable cell.
public bool IsDataTableValueValid { get; }
Public ReadOnly Property IsDataTableValueValid As Boolean
Property Value
Remarks
If this value is false, you need to set an appropriate DataTableValue before exiting event handler or SpreadsheetException will be thrown.