CSV Validation Rules Schema

type

optional

TSI_CSV

Generated document type.

structure

1

unbounded

Csv structure.

customizeMessages

1

unbounded

Global error messages overrides.

hasHeader

required

Determines if csv file should have header.

encoding

optional

auto

Determines csv encoding which will be used for reading source file.
Values:

• auto - attempt to autodetect encoding. Will try to detect encoding using byte order mask at the beginning of the file (Unicode or UTC-8). If no byte order mask found in file, ASCII will be used
• Encodings supported by .NET Framework, see http://msdn.microsoft.com/en-us/library/system.text.encoding(v=vs.110).aspx

delimiter

optional

,

Regular expression for column delimiter.

culture

optional

invariant

Culture for validating dates and numbers.
Values:

• af-ZA Afrikaans - South Africa
• sq-AL Albanian - Albania
• ar-DZ Arabic - Algeria
• ar-BH Arabic - Bahrain
• ar-EG Arabic - Egypt
• ar-IQ Arabic - Iraq
• ar-JO Arabic - Jordan
• ar-KW Arabic - Kuwait
• ar-LB Arabic - Lebanon
• ar-LY Arabic - Libya
• ar-MA Arabic - Morocco
• ar-OM Arabic - Oman
• ar-QA Arabic - Qatar
• ar-SA Arabic - Saudi Arabia
• ar-SY Arabic - Syria
• ar-TN Arabic - Tunisia
• ar-AE Arabic - United Arab Emirates
• ar-YE Arabic - Yemen
• hy-AM Armenian - Armenia
• Cy-az-AZ Azeri (Cyrillic) - Azerbaijan
• Lt-az-AZ Azeri (Latin) - Azerbaijan
• eu-ES Basque - Basque
• be-BY Belarusian - Belarus
• bg-BG Bulgarian - Bulgaria
• ca-ES Catalan - Catalan
• zh-CN Chinese - China
• zh-HK Chinese - Hong Kong SAR
• zh-MO Chinese - Macau SAR
• zh-SG Chinese - Singapore
• zh-TW Chinese - Taiwan
• zh-CHS Chinese (Simplified)
• zh-CHT Chinese (Traditional)
• hr-HR Croatian - Croatia
• cs-CZ Czech - Czech Republic
• da-DK Danish - Denmark
• div-MV Dhivehi - Maldives
• nl-BE Dutch - Belgium
• nl-NL Dutch - The Netherlands
• en-AU English - Australia
• en-BZ English - Belize
• en-CA English - Canada
• en-CB English - Caribbean
• en-IE English - Ireland
• en-JM English - Jamaica
• en-NZ English - New Zealand
• en-PH English - Philippines
• en-ZA English - South Africa
• en-TT English - Trinidad and Tobago
• en-GB English - United Kingdom
• en-US English - United States
• en-ZW English - Zimbabwe
• et-EE Estonian - Estonia
• fo-FO Faroese - Faroe Islands
• fa-IR Farsi - Iran
• fi-FI Finnish - Finland
• fr-BE French - Belgium
• fr-CA French - Canada
• fr-FR French - France
• fr-LU French - Luxembourg
• fr-MC French - Monaco
• fr-CH French - Switzerland
• gl-ES Galician - Galician
• ka-GE Georgian - Georgia
• de-AT German - Austria
• de-DE German - Germany
• de-LI German - Liechtenstein
• de-LU German - Luxembourg
• de-CH German - Switzerland
• el-GR Greek - Greece
• gu-IN Gujarati - India
• he-IL Hebrew - Israel
• hi-IN Hindi - India
• hu-HU Hungarian - Hungary
• is-IS Icelandic - Iceland
• id-ID Indonesian - Indonesia
• it-IT Italian - Italy
• it-CH Italian - Switzerland
• ja-JP Japanese - Japan
• kn-IN Kannada - India
• kk-KZ Kazakh - Kazakhstan
• kok-IN Konkani - India
• ko-KR Korean - Korea
• ky-KZ Kyrgyz - Kazakhstan
• lv-LV Latvian - Latvia
• lt-LT Lithuanian - Lithuania
• mk-MK Macedonian (FYROM)
• ms-BN Malay - Brunei
• ms-MY Malay - Malaysia
• mr-IN Marathi - India
• mn-MN Mongolian - Mongolia
• nb-NO Norwegian (Bokmål) - Norway
• nn-NO Norwegian (Nynorsk) - Norway
• pl-PL Polish - Poland
• pt-BR Portuguese - Brazil
• pt-PT Portuguese - Portugal
• pa-IN Punjabi - India
• ro-RO Romanian - Romania
• ru-RU Russian - Russia
• sa-IN Sanskrit - India
• Cy-sr-SP Serbian (Cyrillic) - Serbia
• Lt-sr-SP Serbian (Latin) - Serbia
• sk-SK Slovak - Slovakia
• sl-SI Slovenian - Slovenia
• es-AR Spanish - Argentina
• es-BO Spanish - Bolivia
• es-CL Spanish - Chile
• es-CO Spanish - Colombia
• es-CR Spanish - Costa Rica
• es-DO Spanish - Dominican Republic
• es-EC Spanish - Ecuador
• es-SV Spanish - El Salvador
• es-GT Spanish - Guatemala
• es-HN Spanish - Honduras
• es-MX Spanish - Mexico
• es-NI Spanish - Nicaragua
• es-PA Spanish - Panama
• es-PY Spanish - Paraguay
• es-PE Spanish - Peru
• es-PR Spanish - Puerto Rico
• es-ES Spanish - Spain
• es-UY Spanish - Uruguay
• es-VE Spanish - Venezuela
• sw-KE Swahili - Kenya
• sv-FI Swedish - Finland
• sv-SE Swedish - Sweden
• syr-SY Syriac - Syria
• ta-IN Tamil - India
• tt-RU Tatar - Russia
• te-IN Telugu - India
• th-TH Thai - Thailand
• tr-TR Turkish - Turkey
• uk-UA Ukrainian - Ukraine
• ur-PK Urdu - Pakistan
• Cy-uz-UZ Uzbek (Cyrillic) - Uzbekistan
• Lt-uz-UZ Uzbek (Latin) - Uzbekistan
• vi-VN Vietnamese - Vietnam

terminator

optional

\r?\n

Regular expression for line terminator

ignoreLastBlankRow

optional

false

Specifies if last blank row of CSV file should be ignored. Default is false. This parameter is used in cas CSV file ends with line terminator, which means that last CSV line exists and has no columns.

column

1

unbounded

Column definition

name

required

Column name

required

0

1

Validates that value in column is not empty.

decimal

0

1

Validates that value in column is decimal.

dateTime

0

1

Validates that value in column is datetime.

integer

0

1

Validates that value in column is integer.

byte

0

1

Validates that value in column is byte.

double

0

1

Validates that value in column is double.

float

0

1

Validates that value in column is float.

long

0

1

Validates that value in column is long.

positive

0

1

Validates that value in column is positive.

positiveOrZero

0

1

Validates that value in column is positive or zero.

negative

0

1

Validates that value in column is negative.

negativeOrZero

0

1

Validates that value in column is negativ or zero.

regexp

0

unbounded

Validates value in column against regular expression pattern.

greater

0

1

Validates that value in column is greater than other value.

greaterOrEqual

0

1

Validates that value in column is greater than or equal to other value.

less

0

1

Validates that value in column is less than other value.

lessOrEqual

0

1

Validates that value in column is less than or equal tov other value.

message

optional

Error message override.

message

optional

Error message override.

numberStyles

optional

Comma-separated list of number parsing rules.
Values:

• AllowCurrencySymbol Indicates that the numeric string can contain a currency symbol. Valid currency symbols are determined by the NumberFormatInfo.CurrencySymbolproperty.
• AllowDecimalPoint Indicates that the numeric string can have a decimal point. If the NumberStyles value includes the AllowCurrencySymbol flag and the parsed string includes a currency symbol, the decimal separator character is determined by the NumberFormatInfo.CurrencyDecimalSeparator property. Otherwise, the decimal separator character is determined by the NumberFormatInfo.NumberDecimalSeparator property.
• AllowExponent Indicates that the numeric string can be in exponential notation. The AllowExponent flag allows the parsed string to contain an exponent that begins with the "E" or "e" character and that is followed by an optional positive or negative sign and an integer. In other words, it successfully parses strings in the formnnnExx, nnnE+xx, and nnnE-xx. It does not allow a decimal separator or sign in the significand or mantissa; to allow these elements in the string to be parsed, use the AllowDecimalPoint and AllowLeadingSign flags, or use a composite style that includes these individual flags.
• AllowHexSpecifier Indicates that the numeric string represents a hexadecimal value. Valid hexadecimal values include the numeric digits 0-9 and the hexadecimal digits A-F and a-f. Strings that are parsed using this style cannot be prefixed with "0x" or "&h". A string that is parsed with the AllowHexSpecifier style will always be interpreted as a hexadecimal value. The only flags that can be combined with AllowHexSpecifier are AllowLeadingWhite and AllowTrailingWhite. TheNumberStyles enumeration includes a composite style, HexNumber, that consists of these three flags.
• AllowLeadingSign Indicates that the numeric string can have a leading sign. Valid leading sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
• AllowLeadingWhite Indicates that leading white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
• AllowParentheses Indicates that the numeric string can have one pair of parentheses enclosing the number. The parentheses indicate that the string to be parsed represents a negative number.
• AllowThousands Indicates that the numeric string can have group separators, such as symbols that separate hundreds from thousands. If the NumberStyles value includes the AllowCurrencySymbol flag and the string to be parsed includes a currency symbol, the valid group separator character is determined by theNumberFormatInfo.CurrencyGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.CurrencyGroupSizes property. Otherwise, the valid group separator character is determined by theNumberFormatInfo.NumberGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.NumberGroupSizes property.
• AllowTrailingSign Indicates that the numeric string can have a trailing sign. Valid trailing sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
• AllowTrailingWhite Indicates that trailing white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
• Any Indicates that all styles except AllowHexSpecifier are used. This is a composite number style.
• Currency Indicates that all styles except AllowExponent and AllowHexSpecifier are used. This is a composite number style.
• Float Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowDecimalPoint, and AllowExponent styles are used. This is a composite number style.
• HexNumber Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowHexSpecifier styles are used. This is a composite number style.
• Integer Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowLeadingSign styles are used. This is a composite number style.
• None Indicates that no style elements, such as leading or trailing white space, thousands separators, or a decimal separator, can be present in the parsed string. The string to be parsed must consist of integral decimal digits only.
• Number Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowTrailingSign, AllowDecimalPoint, and AllowThousands styles are used. This is a composite number style.

message

optional

Error message override.

dateTimeStyles

optional

Comma-separated list of datetime parsing rules.
Values:

• AdjustToUniversal Date and time are returned as a Coordinated Universal Time (UTC). If the input string denotes a local time, through a time zone specifier orAssumeLocal, the date and time are converted from the local time to UTC. If the input string denotes a UTC time, through a time zone specifier orAssumeUniversal, no conversion occurs. If the input string does not denote a local or UTC time, no conversion occurs and the resulting Kind property isUnspecified.
• AllowInnerWhite Extra white-space characters in the middle of the string must be ignored during parsing, except if they occur in the DateTimeFormatInfo format patterns.
• AllowLeadingWhite Leading white-space characters must be ignored during parsing, except if they occur in the DateTimeFormatInfo format patterns.
• AllowTrailingWhite Trailing white-space characters must be ignored during parsing, except if they occur in the DateTimeFormatInfo format patterns.
• AllowWhiteSpaces Extra white-space characters anywhere in the string must be ignored during parsing, except if they occur in the DateTimeFormatInfo format patterns. This value is a combination of the AllowLeadingWhite, AllowTrailingWhite, and AllowInnerWhite values.
• AssumeLocal If no time zone is specified in the parsed string, the string is assumed to denote a local time.
• AssumeUniversal If no time zone is specified in the parsed string, the string is assumed to denote a UTC.
• NoCurrentDateDefault If the parsed string contains only the time and not the date, the parsing methods assume the Gregorian date with year = 1, month = 1, and day = 1. If this value is not used, the current date is assumed.
• None Default formatting options must be used. This value represents the default style for the DateTime.Parse, DateTime.ParseExact, and DateTime.TryParsemethods.
• RoundtripKind The DateTimeKind field of a date is preserved when a DateTime object is converted to a string using the "o" or "r" standard format specifier, and the string is then converted back to a DateTime object.

message

optional

Error message override.

numberStyles

optional

Comma-separated list of number parsing rules.
Values:

• AllowCurrencySymbol Indicates that the numeric string can contain a currency symbol. Valid currency symbols are determined by the NumberFormatInfo.CurrencySymbolproperty.
• AllowDecimalPoint Indicates that the numeric string can have a decimal point. If the NumberStyles value includes the AllowCurrencySymbol flag and the parsed string includes a currency symbol, the decimal separator character is determined by the NumberFormatInfo.CurrencyDecimalSeparator property. Otherwise, the decimal separator character is determined by the NumberFormatInfo.NumberDecimalSeparator property.
• AllowExponent Indicates that the numeric string can be in exponential notation. The AllowExponent flag allows the parsed string to contain an exponent that begins with the "E" or "e" character and that is followed by an optional positive or negative sign and an integer. In other words, it successfully parses strings in the formnnnExx, nnnE+xx, and nnnE-xx. It does not allow a decimal separator or sign in the significand or mantissa; to allow these elements in the string to be parsed, use the AllowDecimalPoint and AllowLeadingSign flags, or use a composite style that includes these individual flags.
• AllowHexSpecifier Indicates that the numeric string represents a hexadecimal value. Valid hexadecimal values include the numeric digits 0-9 and the hexadecimal digits A-F and a-f. Strings that are parsed using this style cannot be prefixed with "0x" or "&h". A string that is parsed with the AllowHexSpecifier style will always be interpreted as a hexadecimal value. The only flags that can be combined with AllowHexSpecifier are AllowLeadingWhite and AllowTrailingWhite. TheNumberStyles enumeration includes a composite style, HexNumber, that consists of these three flags.
• AllowLeadingSign Indicates that the numeric string can have a leading sign. Valid leading sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
• AllowLeadingWhite Indicates that leading white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
• AllowParentheses Indicates that the numeric string can have one pair of parentheses enclosing the number. The parentheses indicate that the string to be parsed represents a negative number.
• AllowThousands Indicates that the numeric string can have group separators, such as symbols that separate hundreds from thousands. If the NumberStyles value includes the AllowCurrencySymbol flag and the string to be parsed includes a currency symbol, the valid group separator character is determined by theNumberFormatInfo.CurrencyGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.CurrencyGroupSizes property. Otherwise, the valid group separator character is determined by theNumberFormatInfo.NumberGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.NumberGroupSizes property.
• AllowTrailingSign Indicates that the numeric string can have a trailing sign. Valid trailing sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
• AllowTrailingWhite Indicates that trailing white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
• Any Indicates that all styles except AllowHexSpecifier are used. This is a composite number style.
• Currency Indicates that all styles except AllowExponent and AllowHexSpecifier are used. This is a composite number style.
• Float Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowDecimalPoint, and AllowExponent styles are used. This is a composite number style.
• HexNumber Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowHexSpecifier styles are used. This is a composite number style.
• Integer Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowLeadingSign styles are used. This is a composite number style.
• None Indicates that no style elements, such as leading or trailing white space, thousands separators, or a decimal separator, can be present in the parsed string. The string to be parsed must consist of integral decimal digits only.
• Number Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowTrailingSign, AllowDecimalPoint, and AllowThousands styles are used. This is a composite number style.

message

optional

Error message override.

numberStyles

optional

Comma-separated list of number parsing rules.
Values:

• AllowCurrencySymbol Indicates that the numeric string can contain a currency symbol. Valid currency symbols are determined by the NumberFormatInfo.CurrencySymbolproperty.
• AllowDecimalPoint Indicates that the numeric string can have a decimal point. If the NumberStyles value includes the AllowCurrencySymbol flag and the parsed string includes a currency symbol, the decimal separator character is determined by the NumberFormatInfo.CurrencyDecimalSeparator property. Otherwise, the decimal separator character is determined by the NumberFormatInfo.NumberDecimalSeparator property.
• AllowExponent Indicates that the numeric string can be in exponential notation. The AllowExponent flag allows the parsed string to contain an exponent that begins with the "E" or "e" character and that is followed by an optional positive or negative sign and an integer. In other words, it successfully parses strings in the formnnnExx, nnnE+xx, and nnnE-xx. It does not allow a decimal separator or sign in the significand or mantissa; to allow these elements in the string to be parsed, use the AllowDecimalPoint and AllowLeadingSign flags, or use a composite style that includes these individual flags.
• AllowHexSpecifier Indicates that the numeric string represents a hexadecimal value. Valid hexadecimal values include the numeric digits 0-9 and the hexadecimal digits A-F and a-f. Strings that are parsed using this style cannot be prefixed with "0x" or "&h". A string that is parsed with the AllowHexSpecifier style will always be interpreted as a hexadecimal value. The only flags that can be combined with AllowHexSpecifier are AllowLeadingWhite and AllowTrailingWhite. TheNumberStyles enumeration includes a composite style, HexNumber, that consists of these three flags.
• AllowLeadingSign Indicates that the numeric string can have a leading sign. Valid leading sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
• AllowLeadingWhite Indicates that leading white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
• AllowParentheses Indicates that the numeric string can have one pair of parentheses enclosing the number. The parentheses indicate that the string to be parsed represents a negative number.
• AllowThousands Indicates that the numeric string can have group separators, such as symbols that separate hundreds from thousands. If the NumberStyles value includes the AllowCurrencySymbol flag and the string to be parsed includes a currency symbol, the valid group separator character is determined by theNumberFormatInfo.CurrencyGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.CurrencyGroupSizes property. Otherwise, the valid group separator character is determined by theNumberFormatInfo.NumberGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.NumberGroupSizes property.
• AllowTrailingSign Indicates that the numeric string can have a trailing sign. Valid trailing sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
• AllowTrailingWhite Indicates that trailing white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
• Any Indicates that all styles except AllowHexSpecifier are used. This is a composite number style.
• Currency Indicates that all styles except AllowExponent and AllowHexSpecifier are used. This is a composite number style.
• Float Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowDecimalPoint, and AllowExponent styles are used. This is a composite number style.
• HexNumber Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowHexSpecifier styles are used. This is a composite number style.
• Integer Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowLeadingSign styles are used. This is a composite number style.
• None Indicates that no style elements, such as leading or trailing white space, thousands separators, or a decimal separator, can be present in the parsed string. The string to be parsed must consist of integral decimal digits only.
• Number Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowTrailingSign, AllowDecimalPoint, and AllowThousands styles are used. This is a composite number style.

message

optional

Error message override.

numberStyles

optional

Comma-separated list of number parsing rules.
Values:

• AllowCurrencySymbol Indicates that the numeric string can contain a currency symbol. Valid currency symbols are determined by the NumberFormatInfo.CurrencySymbolproperty.
• AllowDecimalPoint Indicates that the numeric string can have a decimal point. If the NumberStyles value includes the AllowCurrencySymbol flag and the parsed string includes a currency symbol, the decimal separator character is determined by the NumberFormatInfo.CurrencyDecimalSeparator property. Otherwise, the decimal separator character is determined by the NumberFormatInfo.NumberDecimalSeparator property.
• AllowExponent Indicates that the numeric string can be in exponential notation. The AllowExponent flag allows the parsed string to contain an exponent that begins with the "E" or "e" character and that is followed by an optional positive or negative sign and an integer. In other words, it successfully parses strings in the formnnnExx, nnnE+xx, and nnnE-xx. It does not allow a decimal separator or sign in the significand or mantissa; to allow these elements in the string to be parsed, use the AllowDecimalPoint and AllowLeadingSign flags, or use a composite style that includes these individual flags.
• AllowHexSpecifier Indicates that the numeric string represents a hexadecimal value. Valid hexadecimal values include the numeric digits 0-9 and the hexadecimal digits A-F and a-f. Strings that are parsed using this style cannot be prefixed with "0x" or "&h". A string that is parsed with the AllowHexSpecifier style will always be interpreted as a hexadecimal value. The only flags that can be combined with AllowHexSpecifier are AllowLeadingWhite and AllowTrailingWhite. TheNumberStyles enumeration includes a composite style, HexNumber, that consists of these three flags.
• AllowLeadingSign Indicates that the numeric string can have a leading sign. Valid leading sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
• AllowLeadingWhite Indicates that leading white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
• AllowParentheses Indicates that the numeric string can have one pair of parentheses enclosing the number. The parentheses indicate that the string to be parsed represents a negative number.
• AllowThousands Indicates that the numeric string can have group separators, such as symbols that separate hundreds from thousands. If the NumberStyles value includes the AllowCurrencySymbol flag and the string to be parsed includes a currency symbol, the valid group separator character is determined by theNumberFormatInfo.CurrencyGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.CurrencyGroupSizes property. Otherwise, the valid group separator character is determined by theNumberFormatInfo.NumberGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.NumberGroupSizes property.
• AllowTrailingSign Indicates that the numeric string can have a trailing sign. Valid trailing sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
• AllowTrailingWhite Indicates that trailing white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
• Any Indicates that all styles except AllowHexSpecifier are used. This is a composite number style.
• Currency Indicates that all styles except AllowExponent and AllowHexSpecifier are used. This is a composite number style.
• Float Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowDecimalPoint, and AllowExponent styles are used. This is a composite number style.
• HexNumber Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowHexSpecifier styles are used. This is a composite number style.
• Integer Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowLeadingSign styles are used. This is a composite number style.
• None Indicates that no style elements, such as leading or trailing white space, thousands separators, or a decimal separator, can be present in the parsed string. The string to be parsed must consist of integral decimal digits only.
• Number Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowTrailingSign, AllowDecimalPoint, and AllowThousands styles are used. This is a composite number style.

message

optional

Error message override.

numberStyles

optional

Comma-separated list of number parsing rules.
Values:

• AllowCurrencySymbol Indicates that the numeric string can contain a currency symbol. Valid currency symbols are determined by the NumberFormatInfo.CurrencySymbolproperty.
• AllowDecimalPoint Indicates that the numeric string can have a decimal point. If the NumberStyles value includes the AllowCurrencySymbol flag and the parsed string includes a currency symbol, the decimal separator character is determined by the NumberFormatInfo.CurrencyDecimalSeparator property. Otherwise, the decimal separator character is determined by the NumberFormatInfo.NumberDecimalSeparator property.
• AllowExponent Indicates that the numeric string can be in exponential notation. The AllowExponent flag allows the parsed string to contain an exponent that begins with the "E" or "e" character and that is followed by an optional positive or negative sign and an integer. In other words, it successfully parses strings in the formnnnExx, nnnE+xx, and nnnE-xx. It does not allow a decimal separator or sign in the significand or mantissa; to allow these elements in the string to be parsed, use the AllowDecimalPoint and AllowLeadingSign flags, or use a composite style that includes these individual flags.
• AllowHexSpecifier Indicates that the numeric string represents a hexadecimal value. Valid hexadecimal values include the numeric digits 0-9 and the hexadecimal digits A-F and a-f. Strings that are parsed using this style cannot be prefixed with "0x" or "&h". A string that is parsed with the AllowHexSpecifier style will always be interpreted as a hexadecimal value. The only flags that can be combined with AllowHexSpecifier are AllowLeadingWhite and AllowTrailingWhite. TheNumberStyles enumeration includes a composite style, HexNumber, that consists of these three flags.
• AllowLeadingSign Indicates that the numeric string can have a leading sign. Valid leading sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
• AllowLeadingWhite Indicates that leading white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
• AllowParentheses Indicates that the numeric string can have one pair of parentheses enclosing the number. The parentheses indicate that the string to be parsed represents a negative number.
• AllowThousands Indicates that the numeric string can have group separators, such as symbols that separate hundreds from thousands. If the NumberStyles value includes the AllowCurrencySymbol flag and the string to be parsed includes a currency symbol, the valid group separator character is determined by theNumberFormatInfo.CurrencyGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.CurrencyGroupSizes property. Otherwise, the valid group separator character is determined by theNumberFormatInfo.NumberGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.NumberGroupSizes property.
• AllowTrailingSign Indicates that the numeric string can have a trailing sign. Valid trailing sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
• AllowTrailingWhite Indicates that trailing white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
• Any Indicates that all styles except AllowHexSpecifier are used. This is a composite number style.
• Currency Indicates that all styles except AllowExponent and AllowHexSpecifier are used. This is a composite number style.
• Float Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowDecimalPoint, and AllowExponent styles are used. This is a composite number style.
• HexNumber Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowHexSpecifier styles are used. This is a composite number style.
• Integer Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowLeadingSign styles are used. This is a composite number style.
• None Indicates that no style elements, such as leading or trailing white space, thousands separators, or a decimal separator, can be present in the parsed string. The string to be parsed must consist of integral decimal digits only.
• Number Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowTrailingSign, AllowDecimalPoint, and AllowThousands styles are used. This is a composite number style.

message

optional

Error message override.

numberStyles

optional

Comma-separated list of number parsing rules.
Values:

• AllowCurrencySymbol Indicates that the numeric string can contain a currency symbol. Valid currency symbols are determined by the NumberFormatInfo.CurrencySymbolproperty.
• AllowDecimalPoint Indicates that the numeric string can have a decimal point. If the NumberStyles value includes the AllowCurrencySymbol flag and the parsed string includes a currency symbol, the decimal separator character is determined by the NumberFormatInfo.CurrencyDecimalSeparator property. Otherwise, the decimal separator character is determined by the NumberFormatInfo.NumberDecimalSeparator property.
• AllowExponent Indicates that the numeric string can be in exponential notation. The AllowExponent flag allows the parsed string to contain an exponent that begins with the "E" or "e" character and that is followed by an optional positive or negative sign and an integer. In other words, it successfully parses strings in the formnnnExx, nnnE+xx, and nnnE-xx. It does not allow a decimal separator or sign in the significand or mantissa; to allow these elements in the string to be parsed, use the AllowDecimalPoint and AllowLeadingSign flags, or use a composite style that includes these individual flags.
• AllowHexSpecifier Indicates that the numeric string represents a hexadecimal value. Valid hexadecimal values include the numeric digits 0-9 and the hexadecimal digits A-F and a-f. Strings that are parsed using this style cannot be prefixed with "0x" or "&h". A string that is parsed with the AllowHexSpecifier style will always be interpreted as a hexadecimal value. The only flags that can be combined with AllowHexSpecifier are AllowLeadingWhite and AllowTrailingWhite. TheNumberStyles enumeration includes a composite style, HexNumber, that consists of these three flags.
• AllowLeadingSign Indicates that the numeric string can have a leading sign. Valid leading sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
• AllowLeadingWhite Indicates that leading white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
• AllowParentheses Indicates that the numeric string can have one pair of parentheses enclosing the number. The parentheses indicate that the string to be parsed represents a negative number.
• AllowThousands Indicates that the numeric string can have group separators, such as symbols that separate hundreds from thousands. If the NumberStyles value includes the AllowCurrencySymbol flag and the string to be parsed includes a currency symbol, the valid group separator character is determined by theNumberFormatInfo.CurrencyGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.CurrencyGroupSizes property. Otherwise, the valid group separator character is determined by theNumberFormatInfo.NumberGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.NumberGroupSizes property.
• AllowTrailingSign Indicates that the numeric string can have a trailing sign. Valid trailing sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
• AllowTrailingWhite Indicates that trailing white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
• Any Indicates that all styles except AllowHexSpecifier are used. This is a composite number style.
• Currency Indicates that all styles except AllowExponent and AllowHexSpecifier are used. This is a composite number style.
• Float Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowDecimalPoint, and AllowExponent styles are used. This is a composite number style.
• HexNumber Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowHexSpecifier styles are used. This is a composite number style.
• Integer Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowLeadingSign styles are used. This is a composite number style.
• None Indicates that no style elements, such as leading or trailing white space, thousands separators, or a decimal separator, can be present in the parsed string. The string to be parsed must consist of integral decimal digits only.
• Number Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowTrailingSign, AllowDecimalPoint, and AllowThousands styles are used. This is a composite number style.

message

optional

Error message override.

message

optional

Error message override.

message

optional

Error message override.

message

optional

Error message override.

pattern

optional

Regular Expression pattern.

message

optional

Error message override.

compareTo

optional

Value to compare.

message

optional

Error message override.

compareTo

optional

Value to compare.

message

optional

Error message override.

compareTo

optional

Value to compare.

message

optional

Error message override.

compareTo

optional

Value to compare.

message

optional

Error message override.

required

0

1

Overrides error message

date

0

1

Overrides error message

regexp

0

1

Overrides error message

integer

0

1

Overrides error message

byte

0

1

Overrides error message

decimal

0

1

Overrides error message

double

0

1

Overrides error message

float

0

1

Overrides error message

long

0

1

Overrides error message

positive

0

1

Overrides error message

positiveOrZero

0

1

Overrides error message

negative

0

1

Overrides error message

negativeOrZero

0

1

Overrides error message

noRows

0

1

Overrides error message

wrongHeaderColumn

0

1

Overrides error message

unexpectedColumn

0

1

Overrides error message

missingColumn

0

1

Overrides error message