c# 任意对象生成excel

        public static void ExportExcel<T>(List<T> ts,string filename)
        {
            var model = ts.FirstOrDefault();
            List<PropertyInfo> titles = model.GetType().GetProperties().ToList();
            using (ExcelPackage package = new ExcelPackage())
            {
                // 添加一个工作表  
                ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Sheet1");
                // 获取第一行用于标题  
                int row = 1;
                // 对象的第一个元素的所有键，用作Excel的列标题  
                int col = 1;
                foreach (var title in titles)
                {
                    worksheet.Cells[row, col].Value = title.Name;
                    col++;
                }
                // 填充数据行，从第二行开始  
                row = 2;
                foreach (var item in ts)
                {
                    col = 1;
                    List<PropertyInfo> props = item.GetType().GetProperties().ToList();
                    foreach (var prop in props)
                    {
                        worksheet.Cells[row, col].Value = prop.GetValue(item);
                        col++;
                    }
                    row++;
                }
                // 保存Excel文件到磁盘  
                FileInfo excelFile = new FileInfo($"{model.GetType().Name}_{filename}_{DateTime.Now.ToString("yyyyMMddHHmmss")}.xlsx");
                package.SaveAs(excelFile);
            }
        }

 引用

<PackageReference Include="EPPlus.Core" Version="1.5.4" />