Class VLookup

Namespace

OfficeOpenXml.FormulaParsing.Excel.Functions.RefAndLookup

Assembly

Magicodes.EPPlus.dll

public class VLookup : LookupFunction

Inheritance

object

ExcelFunction

LookupFunction

VLookup

Inherited Members

LookupFunction.IsMatch(object, object)

LookupFunction.GetLookupDirection(RangeAddress)

LookupFunction.Lookup(LookupNavigator, LookupArguments)

LookupFunction.IsLookupFuction

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

VLookup()

public VLookup()

Methods

Execute(IEnumerable<FunctionArgument>, ParsingContext)

public override CompileResult Execute(IEnumerable<FunctionArgument> arguments, ParsingContext context)

Parameters

arguments IEnumerable<FunctionArgument>

context ParsingContext

Returns

CompileResult