public void TestMatrixString() { //Test1 var bag1 = new object[, ] { { null, null, null }, { "", "myparam ", "hello" }, { null, "val11", "val12" }, { null, "val21", "val22" }, { null, "val31", "val32" } }; var myParamArray1 = bag1.ProcessMatrixString("MyParam"); UnitTestUtils.EqualMatrix(myParamArray1, new[, ] { { "val11", "val12" }, { "val21", "val22" }, { "val31", "val32" } }); //Test2 var bag2 = new object[, ] { { null, null, null, null }, { "", "myparam ", "hello", "" }, { null, "val11", "val12", "" }, { null, "val21", "val22", "" }, { null, null, "", "" } }; var myParamArray2 = bag2.ProcessMatrixString("MyParam"); UnitTestUtils.EqualMatrix(myParamArray2, new[, ] { { "val11", "val12" }, { "val21", "val22" } }); }
public void TestTimeMatrixDouble() { //Test1 var bag1 = new object[, ] { { null, null, null, null }, { "", "myparam ", "hello", "toto" }, { null, "1y", "1.0", 5.0 }, { null, "02/22/1978", "2.0", "4.0" }, { null, "10y", "3.0", 1.0 } }; TimeMatrixDatas timeDatas = bag1.ProcessTimeMatrixDatas("MyParam"); var helloDatas = timeDatas.GetColFromLabel("hello"); var totoDatas = timeDatas.GetColFromLabel("toto"); UnitTestUtils.EqualDoubleArray(helloDatas, new[] { 1.0, 2.0, 3.0 }, DoubleUtils.MachineEpsilon); UnitTestUtils.EqualDoubleArray(totoDatas, new[] { 5.0, 4.0, 1.0 }, DoubleUtils.MachineEpsilon); }
public void TestVectorString() { //Test1 var bag1 = new object[, ] { { null, null, null }, { "", "myparam ", "hello" }, { null, "val1", "" }, { null, "val2", "" }, { null, "val3", "" } }; var myParamArray1 = bag1.ProcessVectorString("MyParam"); UnitTestUtils.EqualArrays(myParamArray1, new[] { "val1", "val2", "val3" }); //Test2 var bag2 = new object[, ] { { null, null, null }, { "", "myparam ", "hello" }, { null, "val1", "" }, { null, "val2", "" }, { null, null, "" } }; var myParamArray2 = bag2.ProcessVectorString("MyParam"); UnitTestUtils.EqualArrays(myParamArray2, new[] { "val1", "val2" }); //Test3 var bag3 = new object[, ] { { null, null, null }, { "", "myparam ", "hello" }, { null, "val1", "" }, { null, "val2", "" }, { null, null, "" } //{null, ExcelDna.Integration.ExcelEmpty.Value, ""} }; var myParamArray3 = bag3.ProcessVectorString("MyParam"); UnitTestUtils.EqualArrays(myParamArray3, new[] { "val1", "val2" }); //Test4 var bag4 = new object[, ] { { null, null, null }, { "", "myparam ", "hello" }, { null, "val1", "" }, { null, "val2", "" }, { null, "", "" } }; var myParamArray4 = bag4.ProcessVectorString("MyParam"); UnitTestUtils.EqualArrays(myParamArray4, new[] { "val1", "val2" }); //Test5 var bag5 = new object[, ] { { null, null, null }, { "", "myparam ", "hello" }, { null, "val1", "" }, { null, "val2", "" }, { null, " ", "" } }; var myParamArray5 = bag5.ProcessVectorString("MyParam"); UnitTestUtils.EqualArrays(myParamArray5, new[] { "val1", "val2" }); }