Defines resolution method that determines DataTable column type.

Namespace: GemBox.Spreadsheet
Assembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 35.0.30.1025

Syntax

C#
public enum ColumnTypeResolution

Visual Basic
Public Enumeration ColumnTypeResolution

Members

Member name	Value	Description
Object	0	All columns will be of type object.
StringInvariantCulture	1	All columns will be of type string. For conversion from some value to string invariant culture will be used.
StringCurrentCulture	2	All columns will be of type string. For conversion from some value to string current culture will be used.
Auto	3	If all values in some column have the same type then that type will be used for DataTable column type, otherwise column will be of type object.
AutoPreferStringInvariantCulture	4	If all values in some column have the same type then that type will be used for DataTable column type, otherwise column will be of type string. For conversion from some value to string invariant culture will be used.
AutoPreferStringCurrentCulture	5	If all values in some column have the same type then that type will be used for DataTable column type, otherwise column will be of type string. For conversion from some value to string current culture will be used.

DataTable column type is determined by the column type resolution and by exploring types of all values in some column. Column type can be bool, int, double, DateTime, string or object.