Class RegexConstants

Regex constants for formula parsing.

Inheritance

System.Object

RegexConstants

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: OfficeOpenXml.FormulaParsing.Utilities

Assembly: EPPlus.dll

Syntax

public static class RegexConstants

Fields

Boolean

Regex constant matching a boolean expression (true or false)

Declaration

public const string Boolean = "^(true|false)$"

Field Value

Type	Description
System.String

Decimal

Regex constant matching a decimal expression

Declaration

public const string Decimal = "^[0-9]+\\.[0-9]+$"

Field Value

Type	Description
System.String

ExcelAddress

Regex constant matching a full Excel address

Declaration

public const string ExcelAddress = "^(('[^/\\\\?*\\[\\]]{1,31}'|[A-Za-z_]{1,31})!)?[\\$]{0,1}([A-Z]|[A-Z]{1,3}[\\$]{0,1}[1-9]{1}[0-9]{0,7})(\\:({0,1}[A-Z]|[A-Z]{1,3}[\\$]{0,1}[1-9]{1}[0-9]{0,7})){0,1}$"

Field Value

Type	Description
System.String

Integer

Regex constant matching an integer expression

Declaration

public const string Integer = "^[0-9]+$"

Field Value

Type	Description
System.String

SingleCellAddress

Regex constant matching a single cell address.

Declaration

public const string SingleCellAddress = "^(('[^/\\\\?*\\[\\]]{1,31}'|[A-Za-z_]{1,31})!)?[A-Z]{1,3}[1-9]{1}[0-9]{0,7}$"

Field Value

Type	Description
System.String