public async Task <ActionResult> ExportExcelScoreRecordDetail(string recordId) { var data = await _auditRateService.GetScoreRecordDetail(recordId); var path = Path.Combine(_webHostEnvironment.ContentRootPath, "Resources\\Template\\SME_Score_Record_Detail_Template.xlsx"); WorkbookDesigner designer = new WorkbookDesigner(); designer.Workbook = new Workbook(path); Worksheet ws = designer.Workbook.Worksheets[0]; // Gán giá trị tĩnh ws.Cells["B2"].PutValue(data.auditRateM.Record_Date); ws.Cells["D2"].PutValue(data.auditRateM.PDC); ws.Cells["F2"].PutValue(data.auditRateM.Building); ws.Cells["B3"].PutValue(data.auditRateM.Updated_By); ws.Cells["D3"].PutValue(data.auditRateM.Updated_Time); ws.Cells["F3"].PutValue(data.auditRateM.Line); ws.Cells["F4"].PutValue(data.auditRateM.Audit_Type2); designer.SetDataSource("result", data.listAuditRateD); designer.Process(); MemoryStream stream = new MemoryStream(); designer.Workbook.Save(stream, SaveFormat.Xlsx); byte[] result = stream.ToArray(); return(File(result, "application/xlsx", "SME_Score_Record_Detail" + DateTime.Now.ToString("dd_MM_yyyy_HH_mm_ss") + ".xlsx")); }
public async Task <ActionResult> GetScoreRecordDetail(string recordId) { var data = await _auditRateService.GetScoreRecordDetail(recordId); if (data != null) { return(Ok(data)); } return(NoContent()); }
public async Task <ActionResult> ExportExcelScoreRecordDetail(string recordId) { var data = await _auditRateService.GetScoreRecordDetail(recordId); var Building = await _auditPicDService.GetBuidingByID(data.auditRateM.Building); var path = Path.Combine(_webHostEnvironment.ContentRootPath, "Resources\\Template\\Sixs_Score_Record_Detail_Template.xlsx"); WorkbookDesigner designer = new WorkbookDesigner(); designer.Workbook = new Workbook(path); Worksheet ws = designer.Workbook.Worksheets[0]; // Gán giá trị tĩnh ws.Cells["B2"].PutValue(data.auditRateM.Record_Date); ws.Cells["D2"].PutValue(data.auditRateM.PDC_Name); ws.Cells["F2"].PutValue(Building); ws.Cells["B3"].PutValue(data.auditRateM.Updated_By); ws.Cells["D3"].PutValue(data.auditRateM.Updated_Time); ws.Cells["F3"].PutValue(data.auditRateM.Line_ID_2_Name); ws.Cells["F4"].PutValue(data.auditRateM.Audit_Type2); designer.SetDataSource("result", data.listAuditRateD); designer.Process(); for (var i = 6; i <= data.listAuditRateD.Count + 5; i++) { var filePathB4 = "wwwroot\\uploaded\\images\\" + data.listAuditRateD[i - 6].UplloadPicture; if (System.IO.File.Exists(filePathB4)) { var pictureIndex = ws.Pictures.Add(i, 6, 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; } } MemoryStream stream = new MemoryStream(); designer.Workbook.Save(stream, SaveFormat.Xlsx); byte[] result = stream.ToArray(); return(File(result, "application/xlsx", "Sixs_Score_Record_Detail" + DateTime.Now.ToString("dd_MM_yyyy_HH_mm_ss") + ".xlsx")); }