代码:

 1    public static void ThisTo<T>( List<T> source, string[] colums, Func<T, object[]> action, string savePath, string sheetName = "") 
 2         {
 3             XSSFWorkbook xssfworkbook = new XSSFWorkbook();
 4             ISheet sheet = xssfworkbook.CreateSheet(sheetName);
 5             IRow row = sheet.CreateRow(0);
 6             for (int i = 0; i < colums.Length; i  )
 7             {
 8                 ICell cell = row.CreateCell(i);
 9                 cell.SetCellValue(colums[i]);
10             }
11             for (int i = 0; i < source.Count; i  )
12             {
13                     IRow row1 = sheet.CreateRow(i   1);
14                      int colIndex = 0;
15                      row1.Cells.AddRange(action(source[i]).Select(p =>
16                      {
17                         var colCell = row1.CreateCell(colIndex,CellType.String);
18                         colCell.SetCellValue(p.ToString());
19                         colIndex  ;
20                         return colCell;
21                     }));
22             }
23             MemoryStream stream = new MemoryStream();
24             xssfworkbook.Write(stream);
25             var buf = stream.ToArray();
26             using (FileStream fs = new FileStream(savePath, FileMode.Create, FileAccess.Write))
27             {
28                 fs.Write(buf, 0, buf.Length);
29                 fs.Flush();
30             }
31         }

 

 

启用:

1  ThisTo<NAMES>(a, new string[] { "Name","Gender"}, p =>
2             {
3                 return new object[] {
4                   p.Name,
5                   p.Gender
6                 };
7             }, @"D:\ABCD.xlsx", "234");

 

 

表明:

       方式中第一个主要参数为需导出数据,第二个主要参数为Excel字段名,第三个为导出来时数据信息排列次序(与第二个主要参数相对性应),第四主要参数为储存详细地址,第五主要参数为sheet名,

      启用参考所述启用方式。