承上次提問，是乎都沒回答

請問如何讓class類別的欄位動態建立?
https://ithelp.ithome.com.tw/questions/10215657

我自己再次Google找答案看看~有無讓class類別的欄位動態建立

經測試將Class屬性定義簡單化，在Excel依舊是一樣的欄位

所以找到這網址教學，再根據開發軟體的智能建議修正程式碼

C#匿名对象（转JSON）互转、动态添加属性
https://www.cnblogs.com/elves/p/6087186.html

成功設置動態class類別的欄位動態建立

但問題出現這個動態類別，不會增加寫第二列的資料

請問各位高手如何修改呢?!

原本寫入Excel問題如下

希望能變成以下結果的畫面

另外附上該頁的測試程式碼

using System.Web.Mvc;
using System.Diagnostics;
using System.Collections.Generic;
using Npoi.Mapper;
using System.IO;
using System.Reflection;
using System.CodeDom.Compiler;
using Microsoft.CSharp;

//測試區 2024-05-12 By Jerwei
namespace WebMvcEF.Controllers.RPT
{
    public class WHSalaryRPTforHRController : Controller
    {
        /// <summary>
        /// 頁面載入
        /// </summary>
        /// <returns></returns>
        public ActionResult Index()
        {
            return View();
        }

        /// <summary>
        /// 進入匯出Excel
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        public ActionResult ReportSet()
        {
            var Field = new List<string>
            {
                "學號"
                ,"學生姓名"
                ,"性別"
                ,"縣市"
                ,"手機"
            };

            //建置動態Class並建置動態屬性(Excel欄位名稱)
            var NewClassObj = DynamicClassHelper.NewClass(Field);

            var listclass = new List<dynamic>();
            dynamic NewClassModel = NewClassObj.CreateInstance("dynamicclass");

            if (NewClassModel != null)
            {
                //設定值1
                DynamicClassHelper.ReflectionSetProperty(NewClassModel, "學號", "Test1");
                DynamicClassHelper.ReflectionSetProperty(NewClassModel, "學生姓名", "Test2");
                DynamicClassHelper.ReflectionSetProperty(NewClassModel, "性別", "Test3");

                //設定值2
                DynamicClassHelper.ReflectionSetProperty(NewClassModel, "學號", "Test4");
                DynamicClassHelper.ReflectionSetProperty(NewClassModel, "學生姓名", "Test5");
                DynamicClassHelper.ReflectionSetProperty(NewClassModel, "性別", "Test6");
            }
            listclass.Add(NewClassModel);

            var mapper = new Mapper(); //建立Excel操作物件
            var stream = new MemoryStream(); //建立IO檔案資料流

            //將listclass陣列生成的Excel資料，直接放置到Stream資料流
            mapper.Save(stream, listclass, "sheet1", overwrite: true, xlsx: true);

            //下載Excel檔案
            return File(stream.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "Student.xlsx");
        }

    }

    //使用動態Class功能
    public class DynamicClassHelper
    {
        /// <summary>
        /// 建置動態Class並建置動態屬性
        /// </summary>
        /// <returns></returns>
        public static Assembly NewClass(List<string> AttributesStr)
        {
            //建置Class
            var Str = "public class dynamicclass\n";
            Str += "{\n";
            //建置屬性
            for (var i = 0; i < AttributesStr.Count; i++)
            {
                Str += "public string " + AttributesStr[i] + " { get; set; }\n";
            }
            Str += "}";

            //建立編譯器物件   
            var provider = new CSharpCodeProvider();
            //建立編譯參數   
            var paras = new CompilerParameters
            {
                GenerateExecutable = false,
                GenerateInMemory = true
            };

            //偵錯監控訊息
            Debug.WriteLine(Str);

            //開始編譯 動態Class
            var result = provider.CompileAssemblyFromSource(paras, Str);

            //取得編譯後的 動態Class
            return result.CompiledAssembly;
        }

        /// <summary>
        /// 設定屬性值
        /// </summary>
        /// <param name="objclass"></param>
        /// <param name="propertyname"></param>
        /// <param name="value"></param>
        public static void ReflectionSetProperty(object objclass, string propertyname, string value)
        {
            var infos = objclass.GetType().GetProperties();
            foreach (var info in infos)
            {
                if (info.Name == propertyname && info.CanWrite)
                {
                    info.SetValue(objclass, value, null);
                }
            }
        }
        /// <summary>
        /// 取得屬性值
        /// </summary>
        /// <param name="objclass"></param>
        /// <param name="propertyname"></param>
        public static void ReflectionGetProperty(object objclass, string propertyname)
        {
            var infos = objclass.GetType().GetProperties();
            foreach (var info in infos)
            {
                if (info.Name == propertyname && info.CanRead)
                {
                    System.Console.WriteLine(info.GetValue(objclass, null));
                }
            }
        }
    }
}