Skip to main content

CellValueToColumnTypeConverter Members

Default converter used by the DataTableExporter to convert cell values to any data type except String.

Constructors

Name Description
CellValueToColumnTypeConverter() Initializes a new instance of the CellValueToColumnTypeConverter class with the default settings.

Properties

Name Description
CheckNarrowingConversion Gets or sets whether the result of the conversion is within the range of the destination data type.
ConvertStringValues Gets or sets whether an attempt is made to convert the text displayed in a worksheet cell to a value of the type indicated by the type of the destination column in the DataTable.
EmptyCellValue Gets or sets a value used when exporting an empty cell.
PreferredCulture Gets or sets the information used to format culture-specific data, such as DateTime, DateTimeOffset, and the numeric types.
PreferredNumberStyles Gets or sets the styles permitted in strings when an attempt is made to convert a string to the integral or the floating point numeric types.
SkipErrorValues Gets or sets whether to skip cells with error values.
TreatStringAsZero Gets or sets whether a cell containing text should be converted to a 0 (zero) numeric value.

Methods

Name Description
Convert(Cell, CellValue, Type, out Object) Converts a worksheet cell value to a value that will be written in the DataTable.
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
GetCellDisplayText(Cell) Gets the string that specifies the formatted cell value as it is displayed in a spreadsheet.
GetHashCode() Serves as the default hash function. Inherited from Object.
GetType() Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
ToString() Returns a string that represents the current object. Inherited from Object.
See Also