Advertisement
Guest User

Untitled

a guest
Mar 18th, 2019
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.34 KB | None | 0 0
  1. [HttpPost("excelEbom")]
  2. public FileResult ExcelEbom([FromBody] Books[] books)
  3. {
  4. var comlumHeadrs = new string[]
  5. {
  6. "Book Id",
  7. "Name",
  8. };
  9.  
  10. byte[] result;
  11.  
  12. using (var package = new ExcelPackage())
  13. {
  14. var worksheet = package.Workbook.Worksheets.Add("Current Book"); //Worksheet name
  15. using (var cells = worksheet.Cells[1, 1, 1, 5])
  16. {
  17. cells.Style.Font.Bold = true;
  18. }
  19.  
  20. for (var i = 0; i < comlumHeadrs.Count(); i++)
  21. {
  22. worksheet.Cells[1, i + 1].Value = comlumHeadrs[i];
  23. }
  24.  
  25. //Add values
  26. var j = 2;
  27. foreach (var book in books)
  28. {
  29. worksheet.Cells["A" + j].Value = book.BookId;
  30. worksheet.Cells["B" + j].Value = book.name;
  31. j++;
  32. }
  33. result = package.GetAsByteArray();
  34.  
  35. var excelFile= new FileContentResult(result, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
  36. {
  37. FileDownloadName = "book-export.xlsx"
  38. };
  39.  
  40. return excelFile;
  41. }
  42.  
  43. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement