通用类 对象Excel互转

public class ExcelHelper
    {
    
        public void Demo(string filePath)
        {
            if (File.Exists(filePath)) File.Delete(filePath);
         var   RootElement = new XLWorkbook();
            var   workSheet = RootElement.AddWorksheet("Demo");
            RootElement.SaveAs(filePath);
        }
        public void CreatNewFile(string filePath,string workSheetName)
        {
            if (File.Exists(filePath)) File.Delete(filePath);
            var RootElement = new XLWorkbook();
            var workSheet = RootElement.AddWorksheet(workSheetName);
            RootElement.SaveAs(filePath); 
        }

        public List<T> ReadeExcel<T>(string filePath) where T:new()
        {
            if (!File.Exists(filePath)) throw new Exception("目标文件不存在");
            bool result = true;
            int index = 1;
            string Identity = "";
            XLWorkbook RootElement = new XLWorkbook(filePath);
            List<T> list = new List<T>();
            IXLWorksheet workSheet = RootElement.Worksheet(1);
            Dictionary<int, string> keys = new Dictionary<int, string>();
            while (result)
            {
                Identity = (workSheet.Cell(1, index).Value + "").Trim();
                if (string.IsNullOrEmpty(Identity))result = false;
                else keys.Add(index, Identity);index++;
            }
            result = true;
            index = 2;
            while (result)
            {
                Identity = workSheet.Cell(index, 1).Value + "";
                if (string.IsNullOrEmpty(Identity))
                {
                    result = false;
                }
                else
                {
                    var model = new T();
                    var t = model.GetType();
                    foreach (var item in t.GetProperties())
                    {
                        var proper = keys.FirstOrDefault(p => p.Value == item.Name);
                        if (proper.Value == null)
                        {
                            item.SetValue(model, "", null);
                        }
                        else
                        {
                            item.SetValue(model, workSheet.Cell(index, proper.Key).Value + "", null);
                        }
                    }
                    list.Add(model);
                    index++;
                }

            }


            return list;
        }

        public bool WriteExcel<T>(List<T> source,string filePath)
        {
            var type = typeof(T);
            CreatNewFile(filePath, type.Name);
            XLWorkbook RootElement = new XLWorkbook(filePath);
            List<T> list = new List<T>();
            IXLWorksheet workSheet = RootElement.Worksheet(type.Name);
            int i = 1;

            Dictionary<int, string> keys = new Dictionary<int, string>();
            foreach (var item in type.GetProperties())
                keys.Add(i++, item.Name);


            i = 1;
            foreach (var key in keys)
                workSheet.Cell(i, key.Key).Value = key.Value;

            foreach (var item in source)
            {
                i++;
                type = item.GetType();
                foreach (var key in keys)
                {
                    var vaue = type.GetProperty(key.Value);
                    if (vaue != null) 
                        workSheet.Cell(i, key.Key).Value = vaue.GetValue(item); 
                    else 
                        workSheet.Cell(i, key.Key).Value = ""; 
                } 
            } 
            RootElement.Save();

            return true;
        }


    }