Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1. [HttpGet]
  2. public IActionResult Excel()
  3. {
  4. var excelResult = GenerateExcel();
  5.  
  6. return new FileStreamResult(excelResult, MediaTypeNames.Text.Plain);
  7. }
  8.  
  9. public MemoryStream GenerateExcel()
  10. {
  11. IWorkbook workbook = new XSSFWorkbook();
  12.  
  13. ISheet sheet1 = workbook.CreateSheet("Sheet1");
  14.  
  15. sheet1.AddMergedRegion(new CellRangeAddress(0, 0, 0, 10));
  16. var rowIndex = 0;
  17. IRow row = sheet1.CreateRow(rowIndex);
  18. row.Height = 30 * 80;
  19. row.CreateCell(0).SetCellValue("this is content");
  20. sheet1.AutoSizeColumn(0);
  21. rowIndex++;
  22.  
  23. var sheet2 = workbook.CreateSheet("Sheet2");
  24. var style1 = workbook.CreateCellStyle();
  25. style1.FillForegroundColor = HSSFColor.Blue.Index2;
  26. style1.FillPattern = FillPattern.SolidForeground;
  27.  
  28. var style2 = workbook.CreateCellStyle();
  29. style2.FillForegroundColor = HSSFColor.Yellow.Index2;
  30. style2.FillPattern = FillPattern.SolidForeground;
  31.  
  32. var cell2 = sheet2.CreateRow(0).CreateCell(0);
  33. cell2.CellStyle = style1;
  34. cell2.SetCellValue(0);
  35.  
  36. cell2 = sheet2.CreateRow(1).CreateCell(0);
  37. cell2.CellStyle = style2;
  38. cell2.SetCellValue(1);
  39.  
  40. var ms = new MemoryStream();
  41. workbook.Write(ms);
  42. return ms;
  43. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement