public void ExportListTest()
{
var players = new List <Player>();
var img = Path.Combine(testFolder, "123.jpg");
for (int i = 0; i < 1000; i++)
{
players.Add(new Player
{
Id = 1,
Birthday = DateTime.Now,
Comments = "",
PlayerImg = File.ReadAllBytes(img)
});
}
ExcelTemplate template = new ExcelTemplate
{
Columns = new List <ExcelTemplateColumn>
{
new ExcelTemplateColumn {
ColumnName = "Id",
ColumnTitle = "Id",
},
new ExcelTemplateColumn {
ColumnName = "Birthday",
ColumnTitle = "生日",
Width = 20
},
new ExcelTemplateColumn {
ColumnName = "Comments",
ColumnTitle = "注释",
},
new ExcelTemplateColumn {
ColumnName = "PlayerImg",
ColumnTitle = "图片",
Format = PictureType.JPEG.ToString(),
//Height = 50,
Width = 10
},
},
TemplateID = "Player",
TemplateName = "M1"
};
string file = Path.Combine(testFolder, "123.xlsx");
IWorkbook workbook = new XSSFWorkbook(); //WorkbookFactory.Create();
ISheet sheet = workbook.CreateSheet("Test");
NpoiHelper.ExportList(players, sheet, template);
//保存为Excel文件
using (FileStream fs = new FileStream(file, FileMode.Create, FileAccess.Write))
{
workbook.Write(fs);
}
//Assert.Fail();
}
