public async Task ExcelExportTest()
{
string dir = Environment.CurrentDirectory;
string fileUrl = Path.Combine(dir, DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx");
var carDTO = new ExcelCarTemplateDTO()
{
Age = 10,
CarCode = "鄂A123456",
IdentityNumber = "test",
Mobile = "test",
Name = "test",
RegisterDate = DateTime.Now
};
var list = new List<ExcelCarTemplateDTO>();
for (int i = 0; i < 10; i++)
{
list.Add(carDTO);
}
EasyNPOI.Services.ExcelExportService srv = new EasyNPOI.Services.ExcelExportService();
var bytes = await srv.ExportAsync(new EasyNPOI.Models.Excel.ExportOption<ExcelCarTemplateDTO> { Data = list });
File.WriteAllBytes(fileUrl, bytes);
}
public void TestReplaceExcelStr()
{
var path = @"d:\123\111.xlsx";
var placeholderList = new List <EasyNPOI.Models.Excel.Replacement>
{
new EasyNPOI.Models.Excel.Replacement {
Placeholder = "{ss}", PictureUrl = @"d:\123\heihei.png"
},
new EasyNPOI.Models.Excel.Replacement {
Placeholder = "{tt}", PictureUrl = @"d:\123\heihei.png"
},
};
EasyNPOI.Services.ExcelExportService srv = new EasyNPOI.Services.ExcelExportService();
srv.ReplaceAsync(path, placeholderList);
}
