public Execute ( IEnumerable |
||
arguments | IEnumerable |
|
context | ParsingContext | |
Résultat |
public void VLookupShouldReturnResultFromMatchingRow() { var func = new VLookup(); var args = FunctionsHelper.CreateArgs(2, "A1:B2", 2); var parsingContext = ParsingContext.Create(); var provider = MockRepository.GenerateStub<ExcelDataProvider>(); provider.Stub(x => x.GetCellValue(0, 0)).Return(new ExcelCell(3, null, 0, 0)); provider.Stub(x => x.GetCellValue(0, 1)).Return(new ExcelCell(1, null, 0, 0)); provider.Stub(x => x.GetCellValue(1, 0)).Return(new ExcelCell(2, null, 0, 0)); provider.Stub(x => x.GetCellValue(1, 1)).Return(new ExcelCell(5, null, 0, 0)); parsingContext.ExcelDataProvider = provider; var result = func.Execute(args, parsingContext); Assert.AreEqual(5, result.Result); }
public void VLookupShouldReturnClosestValueBelowWhenRangeLookupIsTrue() { var func = new VLookup(); var args = FunctionsHelper.CreateArgs(4, "A1:B2", 2, true); var parsingContext = ParsingContext.Create(); var provider = MockRepository.GenerateStub<ExcelDataProvider>(); provider.Stub(x => x.GetCellValue(0, 0)).Return(new ExcelCell(3, null, 0, 0)); provider.Stub(x => x.GetCellValue(0, 1)).Return(new ExcelCell(1, null, 0, 0)); provider.Stub(x => x.GetCellValue(1, 0)).Return(new ExcelCell(5, null, 0, 0)); provider.Stub(x => x.GetCellValue(1, 1)).Return(new ExcelCell(4, null, 0, 0)); parsingContext.ExcelDataProvider = provider; var result = func.Execute(args, parsingContext); Assert.AreEqual(1, result.Result); }