Class ExcelErrorValue.Values
Handles the convertion between eErrorType and the string values used by Excel.
Inheritance
System.Object
ExcelErrorValue.Values
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
Assembly: EPPlus.dll
Syntax
public static class ValuesFields
Calc
A constant for the Calc error in Excel
Declaration
public const string Calc = "#CALC!"Field Value
| Type | Description |
|---|---|
| System.String |
Div0
A constant for Div/0 error in Excel
Declaration
public const string Div0 = "#DIV/0!"Field Value
| Type | Description |
|---|---|
| System.String |
NA
A constant for the N/A error in Excel
Declaration
public const string NA = "#N/A"Field Value
| Type | Description |
|---|---|
| System.String |
Name
A constant for the Name error in Excel
Declaration
public const string Name = "#NAME?"Field Value
| Type | Description |
|---|---|
| System.String |
Null
A constant for the Numm error in Excel
Declaration
public const string Null = "#NULL!"Field Value
| Type | Description |
|---|---|
| System.String |
Num
A constant for the Num error in Excel
Declaration
public const string Num = "#NUM!"Field Value
| Type | Description |
|---|---|
| System.String |
Ref
A constant for the Ref error in Excel
Declaration
public const string Ref = "#REF!"Field Value
| Type | Description |
|---|---|
| System.String |
Spill
A constant for the Spill error in Excel
Declaration
public const string Spill = "#SPILL!"Field Value
| Type | Description |
|---|---|
| System.String |
Value
A constant for the Value error in Excel
Declaration
public const string Value = "#VALUE!"Field Value
| Type | Description |
|---|---|
| System.String |
Methods
IsErrorValue(Object)
Returns true if the supplied candidate is an excel error.
Declaration
public static bool IsErrorValue(object candidate)Parameters
| Type | Name | Description |
|---|---|---|
| System.Object | candidate |
Returns
| Type | Description |
|---|---|
| System.Boolean |
StringIsErrorValue(String)
Returns true if the supplied candidate is an excel error.
Declaration
public static bool StringIsErrorValue(string candidate)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | candidate |
Returns
| Type | Description |
|---|---|
| System.Boolean |
ToErrorType(String)
Converts a string to an eErrorType
Declaration
public static eErrorType ToErrorType(string val)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | val |
Returns
| Type | Description |
|---|---|
| eErrorType |
Exceptions
| Type | Condition |
|---|---|
| System.ArgumentException | Thrown if the supplied value is not an Excel error |