public IActionResult DownloadExcelNaoDevolvido()
{
var list = _EmprestRep.ListarEmprestimo().Where(x => x.Recebido == false).ToArray();
string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
string fileName = $"Relatorio Emprestimos nao devolvidos {DateTime.Now.ToString("dd-MM-yyyy")}.xlsx";
try
{
using (var workbook = new XLWorkbook())
{
IXLWorksheet worksheet =
workbook.Worksheets.Add("EMPRESTIMOS NÃO DEVOLVIDOS");
worksheet.Cell("B1").Value = "LISTA DE EMPRESTIMOS NÂO DEVOLVIDOS";
worksheet.Cell(2, 2).Value = "LIVRO";
worksheet.Cell(2, 3).Value = "ALUNO";
worksheet.Cell(2, 4).Value = "DATA EMPRESTIMO";
worksheet.Row(2).Style.Font.Bold = true;
worksheet.Row(2).Style.Font.FontColor = XLColor.White;
var rngHeaders = worksheet.Range("B2:D2");
rngHeaders.Style.Font.Bold = true;
rngHeaders.Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
rngHeaders.Style.Fill.BackgroundColor = XLColor.BluePigment;
worksheet.Columns(2, 4).AdjustToContents();
worksheet.Columns(2, 4).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Left;
for (int index = 1; index <= list.Count(); index++)
{
worksheet.Cell(index + 2, 2).Value = list[index - 1].Livro.Nome;
worksheet.Cell(index + 2, 3).Value = list[index - 1].Aluno;
worksheet.Cell(index + 2, 4).Value = list[index - 1].DataEmprestimo.ToString("dd/MM/yyyy");
}
using (var stream = new MemoryStream())
{
workbook.SaveAs(stream);
var content = stream.ToArray();
return(File(content, contentType, fileName));
}
}
}
catch (Exception ex)
{
return(View(ex));
}
}
