C#.net core导出List＜T＞中的数据到Excel，以及获取实体类的描述[Description(“xx“)]，和参数名，生成表头list

直接上代码

第一个方法ToObjectListExcel，传入数据list和表头list<ExportField>，ExportField在后面，还有一个string类型的路径名，可以随意，用于生成文件夹

/// <summary>
        ///List object 转 Excel
        /// </summary>
        /// <param name="list"> 数据</param>
        /// <param name="exports"> 导出列</param>
        /// <param name="CompanyId"> 公司id</param>
        /// <param name="UserId"> 会员id</param>
        /// <param name="CompanyName"> 公司名</param>
        /// <param name="UserName"> 会员名</param>
        /// <returns> </returns>
        public static string ToObjectListExcel<T>(List<T> list, List<ExportField> exports, string CompanyId, string UserId = "Null", string CompanyName = "Null", string UserName = "Null")
        {
            string url = "";
            if (list.Count > 0)
            {
                HSSFWorkbook workbook = new HSSFWorkbook();

                #region 设置摘要
                DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation();
                dsi.Company = CompanyId;//公司
                dsi.Category = "公司名:" + CompanyName;//类别
                dsi.Manager = "会员id" + UserId + "  会员名:" + UserName;//管理者
                workbook.DocumentSummaryInformation = dsi;

                SummaryInformation si = PropertySetFactory.CreateSummaryInformation();
                si.Author = "会员id" + UserId + "  会员名:" + UserName;             //作者
                si.CreateDateTime = DateTime.Now;                           //创建时间
                si.Subject = CompanyId;   //主题
                workbook.SummaryInformation = si;
                #endregion 设置摘要

                ISheet sheet = workbook.CreateSheet(DateTime.Now.ToString("yyyyMMddHHmmss"));
                IRow row0 = sheet.CreateRow(0);
                int i = 1, j = 0;
                //添加序号
                row0.CreateCell(0).SetCellValue("序号");
                //添加表头
                foreach (ExportField ex in exports)
                {
                    row0.CreateCell(i).SetCellValue(ex.Value);
                    i++;
                }
                i = 1;
                foreach (object data in list)
                {
                    //创建第一列
                    IRow row = sheet.CreateRow(i);
                    j = 1;
                    //添加序号
                    row.CreateCell(0).SetCellValue(i);
                    foreach (ExportField ex in exports)
                    {
                        row.CreateCell(j).SetCellValue(data?.GetPropertyValue(ex.Key)?.ToString() ?? "");
                        j++;
                    }
                    i++;
                }

                string wwwpath = GlobalData.WebRootPathWwwroot;
                string datewwwpath = wwwpath + "\\Upload\\Export\\" + CompanyId + "\\" + DateTime.Now.ToString("yyyyMM");
                if (!Directory.Exists(datewwwpath))
                {
                    Directory.CreateDirectory(datewwwpath);
                }
                string filename = DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
                string exceptfilepath = datewwwpath + "\\" + filename;
                url = GlobalData.WebRootUrl + "/Upload/Export/" + CompanyId + "/" + DateTime.Now.ToString("yyyyMM") + "/" + filename;
                byte[] buffer = new byte[1024 * 1000];
                using (MemoryStream ms = new MemoryStream())
                {
                    workbook.Write(ms);
                    buffer = ms.GetBuffer();
                    ms.Close();
                }
                using FileStream fileStream = new FileStream(exceptfilepath, FileMode.Create);
                using MemoryStream m = new MemoryStream(buffer);
                m.WriteTo(fileStream);
            }
            else
            {
                throw new BusException("数据不能为空!");
            }
            return url;
        }

ExportField实体

 /// <summary>
    /// 可选导出字段
    /// </summary>
    public class ExportField
    {
        /// <summary>
        /// 是否必选
        /// </summary>
        public bool Required { get; set; }

        /// <summary>
        /// 字段
        /// </summary>
        public string Key { get; set; }

        /// <summary>
        /// 描述
        /// </summary>
        public string Value { get; set; }
    }

第二个方法，获取实体属性和描述

//获取实体类里面所有的名称、值、DESCRIPTION值
        public  static List<ExportField> GetProperties<T>(T t)
        {
            string tStr = string.Empty;
            List<ExportField> exportFieldList = new List<ExportField>();
            if (t == null)
            {
                return exportFieldList;
            }
            System.Reflection.PropertyInfo[] properties = t.GetType().GetProperties(System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.Public);

            if (properties.Length <= 0)
            {
                return exportFieldList;
            }
            foreach (System.Reflection.PropertyInfo item in properties)
            {
                string name = item.Name; //名称
                object value = item.GetValue(t, null);  //值
                string des = ((DescriptionAttribute)Attribute.GetCustomAttribute(item, typeof(DescriptionAttribute)))?.Description??null;// 属性描述
                if (des==null)//如果属性描述没有添加则不添加该字段
                {
                    continue;
                }

                if (item.PropertyType.IsValueType || item.PropertyType.Name.StartsWith("String"))
                {
                    exportFieldList.Add(
                    new ExportField()
                    {
                        Key = name,
                        Value = des,
                        Required = false
                    }
                    );
                }
                else
                {
                    GetProperties(value);
                }
            }
            return exportFieldList;
        }