代码:

    public static void ThisTo<T>( List<T> source, string[] colums, Func<T, object[]> action, string savePath, string sheetName = "")
{
XSSFWorkbook xssfworkbook = new XSSFWorkbook();
ISheet sheet = xssfworkbook.CreateSheet(sheetName);
IRow row = sheet.CreateRow();
for (int i = ; i < colums.Length; i++)
{
ICell cell = row.CreateCell(i);
cell.SetCellValue(colums[i]);
}
for (int i = ; i < source.Count; i++)
{
IRow row1 = sheet.CreateRow(i + );
int colIndex = ;
row1.Cells.AddRange(action(source[i]).Select(p =>
{
var colCell = row1.CreateCell(colIndex,CellType.String);
colCell.SetCellValue(p.ToString());
colIndex++;
return colCell;
}));
}
MemoryStream stream = new MemoryStream();
xssfworkbook.Write(stream);
var buf = stream.ToArray();
using (FileStream fs = new FileStream(savePath, FileMode.Create, FileAccess.Write))
{
fs.Write(buf, , buf.Length);
fs.Flush();
}
}

调用:

  ThisTo<NAMES>(a, new string[] { "Name","Gender"}, p =>
{
return new object[] {
p.Name,
p.Gender
};
}, @"D:\ABCD.xlsx", "");

说明:

方法中第一个参数为需导出数据,第二个参数为Excel列名,第三个为导出时数据排布顺序(与第二个参数相对应),第四参数为保存地址,第五参数为sheet名,

调用参照上述调用方法。

05-11 03:42
查看更多