/// <summary>
/// 엑셀 파일 강제 다운로드 기능(/ExcelDown)
/// </summary>
public async Task <IActionResult> ExcelDown()
{
var results = await _repository.GetAllAsync(0, 100);
var models = results.Records.ToList();
if (models != null)
{
using (var package = new ExcelPackage())
{
var worksheet = package.Workbook.Worksheets.Add("Archives");
var tableBody = worksheet.Cells["B2:B2"].LoadFromCollection(
(from m in models select new { m.Id, Created = m.Created?.LocalDateTime.ToString(), m.Name, m.Title, m.DownCount, m.FileName })
, true);
var uploadCol = tableBody.Offset(1, 1, models.Count, 1);
// 그라데이션 효과 부여
var rule = uploadCol.ConditionalFormatting.AddThreeColorScale();
rule.LowValue.Color = Color.SkyBlue;
rule.MiddleValue.Color = Color.White;
rule.HighValue.Color = Color.Red;
var header = worksheet.Cells["B2:F2"];
worksheet.DefaultColWidth = 25;
worksheet.Cells[3, 2, models.Count + 2, 2].Style.Numberformat.Format = "yyyy MMM d DDD";
tableBody.Style.HorizontalAlignment = ExcelHorizontalAlignment.Left;
tableBody.Style.Fill.PatternType = ExcelFillStyle.Solid;
tableBody.Style.Fill.BackgroundColor.SetColor(Color.WhiteSmoke);
tableBody.Style.Border.BorderAround(ExcelBorderStyle.Medium);
header.Style.Font.Bold = true;
header.Style.Font.Color.SetColor(Color.White);
header.Style.Fill.BackgroundColor.SetColor(Color.DarkBlue);
return(File(package.GetAsByteArray(), "application/octet-stream", $"{DateTime.Now.ToString("yyyyMMddhhmmss")}_Archives.xlsx"));
}
}
return(Redirect("/"));
}
