将list<T>结果导出到Excle文件

最新推荐文章于 2023-05-16 10:49:31 发布

原创最新推荐文章于 2023-05-16 10:49:31 发布 · 502 阅读

0 ·

CC 4.0 BY-SA版权

代码备份专栏收录该内容

1 篇文章

订阅专栏

本文介绍了如何在C#中通过Microsoft.Office.Interop.Excel库将List<XXXXXXXX>类型的数据显示到Excel文件中。首先添加必要的引用，然后创建一个方法，该方法接受List<XXXXXXXX>参数，遍历数据并填充到Excel工作表的相应单元格中，最后保存并关闭工作簿。

1. 添加引用 using Microsoft.Office.Interop.Excel;

public class SaveExcle
{
/// <summary>
/// 保存到Excle
/// </summary>
/// <param name="lists">传入List</param>
public void SaveDataToExcelFile(List<XXXXXXXX> lists)
{
string filePath = "D:\\name.xls"; //保存路径
object misValue = Missing.Value;
Application xlApp = new Application();
Workbook xlWorkBook = xlApp.Workbooks.Add(misValue);
Worksheet xlWorkSheet = (Worksheet)xlWorkBook.Worksheets.Item[1];

PropertyInfo[] props = GetPropertyInfoArray();
for (int i = 0; i < props.Length; i++)
{
xlWorkSheet.Cells[1, i + 1] = props[i].Name;
}
for (int i = 0; i < lists.Count; i++)
{
xlWorkSheet.Cells[i + 2, 1] = lists[i].Id;
xlWorkSheet.Cells[i + 2, 2] = lists[i].Name;
xlWorkSheet.Cells[i + 2, 3] = lists[i].Age;
}
xlWorkBook.SaveAs(filePath, XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue,
XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
}
/// <summary>
/// 反射字段类型
/// </summary>
/// <returns></returns>
public PropertyInfo[] GetPropertyInfoArray()
{
Activator.CreateInstance(typeof(XXXXXXXX));
return typeof(XXXXXXXX).GetProperties(BindingFlags.Public | BindingFlags.Instance);
}
}