僅當測試計劃運行時，才在Nunit測試播放列表中顯示測試

我探索了一下，實現了我想要的。令人驚訝的是，查理也提出了同樣的建議，所以我很有信心。可以有更多的方法或代碼可以進一步優化，我正在添加我迄今為止嘗試的內容。注意：列表中只有一個方法不會被執行/跳過。您無法避免這種情況，因為相同的方法會為列表生成實際的測試方法。

namespace AutoRunNunit
{
    internal class TestClass
    {
        [TestCaseSource(typeof(TestDataDummy), "DataProvider")]
        public void RunTest(string methodName, string data)
        {
            typeof(TestClass).GetMethod(methodName).Invoke(null, new[] { data });
        }

        public static void TestMethod1(string data)
        {
            Assert.AreEqual(data, "12");
        }
        
        public static void TestMethod2(string data)
        {
            Assert.AreEqual(data, "13");
        }

       
        public class TestDataDummy
        {
            private static IEnumerable<TestCaseData> DataProvider()
            {
                var testCases = new List<TestCaseData>();

                ArrayList data = GetDataFromExcelDummy();

                foreach (string[] str in data)
                { 
                    testCases.Add(new TestCaseData(str[1], str[2]).SetName(str[1]));

                }

                return testCases;  
            }
        }

        
        public static ArrayList GetDataFromExcelDummy()
        {
            string connectionString = "";

            string path = @"C:\Test\";
            string filename = "TestData.xls";

            if (filename.Contains(".xls"))
            {
                connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + filename + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
            }
            else if (filename.Contains(".xlsx"))
            {
                connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + filename + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
            }

            string query = "SELECT * FROM [Data01$]";
            using (OleDbConnection connection = new OleDbConnection(connectionString))
            {
                OleDbCommand command = new OleDbCommand(query, connection);

                connection.Open();
                OleDbDataReader reader = command.ExecuteReader();

                var lines = new List<string>();
                while (reader.Read())
                {
                    var fieldCount = reader.FieldCount;

                    var fieldIncrementor = 1;
                    var fields = new List<string>();
                    while (fieldCount >= fieldIncrementor)
                    {
                        fields.Add(reader[fieldIncrementor - 1].ToString());
                        fieldIncrementor++;
                    }

                    lines.Add(string.Join("\t", fields));
                }
                reader.Close();


                ArrayList list = new ArrayList();

                foreach (string str in lines)
                {
                    string[] words = str.Split();

                    if (!words[4].Equals("0"))
                    {
                        list.Add(words);
                    }
                }

                return list;
            }
        }
    }
}