public HttpResponseMessage ExportToExcel(int libraryId)
{
var repo = new BooksRepository();
var books = repo.BookExportObject(libraryId);
var booksTable = new DataTable();
booksTable.Columns.Add("Naslov");
booksTable.Columns.Add("Autor");
booksTable.Columns.Add("Broj posuđivanja");
booksTable.Columns.Add("Broj rezervacija");
foreach (var book in books)
{
booksTable.Rows.Add(
book.Name,
book.Author,
book.BorrowCount,
book.ReserveCount
);
}
using (var excel = new ExcelPackage())
{
var worksheet = excel.Workbook.Worksheets.Add("Knjige");
using (var rng = worksheet.Cells["A1:D1"])
{
rng.Style.Font.Bold = true;
rng.Style.Font.Size = 13;
rng.Style.Fill.PatternType = ExcelFillStyle.Solid;
rng.Style.Fill.BackgroundColor.SetColor(Color.YellowGreen);
rng.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
rng.Style.Font.Color.SetColor(Color.Black);
}
worksheet.Cells["A1"].LoadFromDataTable(booksTable, true);
worksheet.Column(1).AutoFit();
worksheet.Column(2).AutoFit();
worksheet.Column(3).AutoFit();
worksheet.Column(4).AutoFit();
using (var rng = worksheet.Cells["A2:D250"])
{
rng.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
rng.Style.Font.Color.SetColor(Color.Black);
}
var result = new HttpResponseMessage(HttpStatusCode.OK)
{
Content = new ByteArrayContent(excel.GetAsByteArray())
};
result.Content.Headers.ContentDisposition =
new System.Net.Http.Headers.ContentDispositionHeaderValue("inline")
{
FileName = "Knjige_Beeble_Export.xlsx"
};
result.Content.Headers.ContentType =
new MediaTypeHeaderValue("application/octet-stream");
return(result);
}
}
