Class ExcelErrorValue.Values¶

Namespace: OfficeOpenXml
Assembly: EPPlus.dll

Handles the convertion between eErrorType and the string values used by Excel.

public static class ExcelErrorValue.Values

Inheritance¶

object ← ExcelErrorValue.Values

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Fields¶

Busy¶

A constant for the Spill error in Excel

public const string Busy = "#BUSY!"

Field Value¶

string

Calc¶

A constant for the Calc error in Excel

public const string Calc = "#CALC!"

Field Value¶

string

Div0¶

A constant for Div/0 error in Excel

public const string Div0 = "#DIV/0!"

Field Value¶

string

NA¶

A constant for the N/A error in Excel

public const string NA = "#N/A"

Field Value¶

string

Name¶

A constant for the Name error in Excel

public const string Name = "#NAME?"

Field Value¶

string

Null¶

A constant for the Numm error in Excel

public const string Null = "#NULL!"

Field Value¶

string

Num¶

A constant for the Num error in Excel

public const string Num = "#NUM!"

Field Value¶

string

Ref¶

A constant for the Ref error in Excel

public const string Ref = "#REF!"

Field Value¶

string

Spill¶

A constant for the Spill error in Excel

public const string Spill = "#SPILL!"

Field Value¶

string

Value¶

A constant for the Value error in Excel

public const string Value = "#VALUE!"

Field Value¶

string

Methods¶

IsErrorValue(object)¶

Returns true if the supplied candidate is an excel error.

public static bool IsErrorValue(object candidate)

Parameters¶

candidate object

Returns¶

bool

StringIsErrorValue(string)¶

Returns true if the supplied candidate is an excel error.

public static bool StringIsErrorValue(string candidate)

Parameters¶

candidate string

Returns¶

bool

ToErrorType(string)¶

Converts a string to an eErrorType

public static eErrorType ToErrorType(string val)

Parameters¶

val string

Returns¶

eErrorType

Exceptions¶

ArgumentException

Thrown if the supplied value is not an Excel error