public async Task <IActionResult> SearchExcel([FromBody] AuditRecSearch model) { var data = await _service.SearchExcel(model, "2"); var path = Path.Combine(_webHostEnvironment.ContentRootPath, "Resources\\Template\\WT_Summary.xlsx"); WorkbookDesigner designer = new WorkbookDesigner(); designer.Workbook = new Workbook(path); //lưu data với ASPO vào excel designer.SetDataSource("result", data); designer.Process(); Worksheet ws = designer.Workbook.Worksheets[0]; for (var i = 1; i <= data.Count; i++) { var filePathB4 = "wwwroot\\uploaded\\images\\" + data[i - 1].Before_Picture; var filePathAfter = "wwwroot\\uploaded\\images\\" + data[i - 1].After_Picture; if (System.IO.File.Exists(filePathB4)) { var pictureIndex = ws.Pictures.Add(i, 17, filePathB4); Aspose.Cells.Drawing.Picture picture = ws.Pictures[pictureIndex]; picture.Width = 100; picture.Height = 100; //margin picture.Top = 3; picture.Left = 3; //set lại Height cho dòng có image ws.Cells.Rows[i].Height = 80; } if (System.IO.File.Exists(filePathAfter)) { //Add picture và set Size cho image var pictureIndex = ws.Pictures.Add(i, 18, filePathAfter); Aspose.Cells.Drawing.Picture picture = ws.Pictures[pictureIndex]; picture.Width = 100; picture.Height = 100; //margin picture.Top = 3; picture.Left = 3; //set lại Height cho dòng có image ws.Cells.Rows[i].Height = 80; } } MemoryStream stream = new MemoryStream(); if (data.Count != 0) { designer.Workbook.Save(stream, SaveFormat.Xlsx); } // designer.Workbook.Save (path + "Test.xlsx", SaveFormat.Xlsx); byte[] result = stream.ToArray(); return(File(result, "application/xlsx", "WT_Summary" + DateTime.Now.ToString("dd_MM_yyyy_HH_mm_ss") + ".xlsx")); }
public async Task <IActionResult> GetSearchExcel([FromBody] AuditRecSearch model) { var auditRecs = await _service.SearchExcel(model); return(Ok(auditRecs)); }