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