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.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Fields

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