C# (CSharp) OfficeOpenXml.FormulaParsing.Excel.Functions.RefAndLookup Index.Execute Examples

Example #1

File: IndexTests.cs Project: acinep/epplus

 public void Index_Should_Return_Value_By_Index()
 {
     var func = new Index();
     var result = func.Execute(
         FunctionsHelper.CreateArgs(
             FunctionsHelper.CreateArgs(1, 2, 5),
             3
             ),_parsingContext);
     Assert.AreEqual(5, result.Result);
 }

Example #2

        public void Index_Should_Return_Value_By_Index()
        {
            var func   = new OfficeOpenXml.FormulaParsing.Excel.Functions.RefAndLookup.Index();
            var result = func.Execute(
                FunctionsHelper.CreateArgs(
                    FunctionsHelper.CreateArgs(1, 2, 5),
                    3
                    ), _parsingContext);

            Assert.AreEqual(5, result.Result);
        }

Example #3

        public void Index_Should_Return_Value_By_Index()
        {
            var func   = new Index();
            var result = func.Execute(
                FunctionsHelper.CreateArgs(
                    FunctionsHelper.CreateArgs(1, 2, 5),
                    3
                    ), _parsingContext);

            Assert.AreEqual(5, result.Result);
        }