Class ExcelErrorValue.Values

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

Inheritance

object

ExcelErrorValue.Values

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: OfficeOpenXml

Assembly: EPPlus.dll

Syntax

public static class ExcelErrorValue.Values

Fields

Busy

A constant for the Spill error in Excel

Declaration

public const string Busy = "#BUSY!"

Field Value

Type	Description
string

Calc

A constant for the Calc error in Excel

Declaration

public const string Calc = "#CALC!"

Field Value

Type	Description
string

Div0

A constant for Div/0 error in Excel

Declaration

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

Field Value

Type	Description
string

NA

A constant for the N/A error in Excel

Declaration

public const string NA = "#N/A"

Field Value

Type	Description
string

Name

A constant for the Name error in Excel

Declaration

public const string Name = "#NAME?"

Field Value

Type	Description
string

Null

A constant for the Numm error in Excel

Declaration

public const string Null = "#NULL!"

Field Value

Type	Description
string

Num

A constant for the Num error in Excel

Declaration

public const string Num = "#NUM!"

Field Value

Type	Description
string

Ref

A constant for the Ref error in Excel

Declaration

public const string Ref = "#REF!"

Field Value

Type	Description
string

Spill

A constant for the Spill error in Excel

Declaration

public const string Spill = "#SPILL!"

Field Value

Type	Description
string

Value

A constant for the Value error in Excel

Declaration

public const string Value = "#VALUE!"

Field Value

Type	Description
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
object	candidate

Returns

Type	Description
bool

StringIsErrorValue(string)

Returns true if the supplied candidate is an excel error.

Declaration

public static bool StringIsErrorValue(string candidate)

Parameters

Type	Name	Description
string	candidate

Returns

Type	Description
bool

ToErrorType(string)

Converts a string to an eErrorType

Declaration

public static eErrorType ToErrorType(string val)

Parameters

Type	Name	Description
string	val

Returns

Type	Description
eErrorType

Exceptions

Type	Condition
ArgumentException	Thrown if the supplied value is not an Excel error