Class LookupFunction

Namespace

OfficeOpenXml.FormulaParsing.Excel.Functions.RefAndLookup

Assembly

Magicodes.EPPlus.dll

public abstract class LookupFunction : ExcelFunction

Inheritance

object

ExcelFunction

LookupFunction

Derived

Column

Columns

HLookup

Lookup

Match

Offset

Row

Rows

VLookup

Inherited Members

ExcelFunction.Execute(IEnumerable<FunctionArgument>, ParsingContext)

ExcelFunction.BeforeInvoke(ParsingContext)

ExcelFunction.GetFirstValue(IEnumerable<FunctionArgument>)

ExcelFunction.ValidateArguments(IEnumerable<FunctionArgument>, int, eErrorType)

ExcelFunction.ValidateArguments(IEnumerable<FunctionArgument>, int)

ExcelFunction.ArgToAddress(IEnumerable<FunctionArgument>, int)

ExcelFunction.ArgToAddress(IEnumerable<FunctionArgument>, int, ParsingContext)

ExcelFunction.ArgToInt(IEnumerable<FunctionArgument>, int)

ExcelFunction.ArgToString(IEnumerable<FunctionArgument>, int)

ExcelFunction.ArgToDecimal(object)

ExcelFunction.ArgToDecimal(IEnumerable<FunctionArgument>, int)

ExcelFunction.Divide(double, double)

ExcelFunction.IsNumericString(object)

ExcelFunction.ArgToBool(IEnumerable<FunctionArgument>, int)

ExcelFunction.ThrowArgumentExceptionIf(Func<bool>, string)

ExcelFunction.ThrowArgumentExceptionIf(Func<bool>, string, params object[])

ExcelFunction.ThrowExcelErrorValueException(eErrorType)

ExcelFunction.ThrowExcelErrorValueExceptionIf(Func<bool>, eErrorType)

ExcelFunction.IsNumeric(object)

ExcelFunction.AreEqual(double, double)

ExcelFunction.ArgsToDoubleEnumerable(IEnumerable<FunctionArgument>, ParsingContext)

ExcelFunction.ArgsToDoubleEnumerable(bool, bool, IEnumerable<FunctionArgument>, ParsingContext)

ExcelFunction.ArgsToDoubleEnumerable(bool, IEnumerable<FunctionArgument>, ParsingContext)

ExcelFunction.ArgsToDoubleEnumerableZeroPadded(bool, ExcelDataProvider.IRangeInfo, ParsingContext)

ExcelFunction.ArgsToObjectEnumerable(bool, IEnumerable<FunctionArgument>, ParsingContext)

ExcelFunction.CreateResult(object, DataType)

ExcelFunction.CalculateCollection(IEnumerable<FunctionArgument>, double, Func<FunctionArgument, double, double>)

ExcelFunction.CheckForAndHandleExcelError(FunctionArgument)

ExcelFunction.CheckForAndHandleExcelError(ExcelDataProvider.ICellInfo)

ExcelFunction.GetResultByObject(object)

ExcelFunction.IsErrorHandlingFunction

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Extension Methods

ExtensionMethods.IsNumeric(object)

Constructors

LookupFunction()

public LookupFunction()

LookupFunction(ValueMatcher, CompileResultFactory)

public LookupFunction(ValueMatcher valueMatcher, CompileResultFactory compileResultFactory)

Parameters

valueMatcher ValueMatcher

compileResultFactory CompileResultFactory

Properties

IsLookupFuction

public override bool IsLookupFuction { get; }

Property Value

bool

Methods

GetLookupDirection(RangeAddress)

protected LookupDirection GetLookupDirection(RangeAddress rangeAddress)

Parameters

rangeAddress RangeAddress

Returns

LookupDirection

IsMatch(object, object)

protected int IsMatch(object o1, object o2)

Parameters

o1 object

o2 object

Returns

int

Lookup(LookupNavigator, LookupArguments)

protected CompileResult Lookup(LookupNavigator navigator, LookupArguments lookupArgs)

Parameters

navigator LookupNavigator

lookupArgs LookupArguments

Returns

CompileResult