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