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); }