Netcool.Excel 0.1.0

Netcool.Excel

Excel import and export extensions base on ClosedXml.

Usage

Dynamic export

var wb = new ExcelExporter()
          .WithTitle("MyTitle")
          .WithSheetName("MySheet")
          .WithHeaders(new[] { "col1", "col2", "col3" })
          .WithRows(new List<List<object>>
          {
              new List<object>() { "r1c1", "1", DateTime.Now },
              new List<object>() { "r2c1", "2.2" },
              new List<object>() { "r3c1" }
          })
          .ExportAsWorkbook();
wb.SaveAs($"export_with_title.xlsx");

Set styles

var styles = new ExcelStyleOptions()
{
    HeaderFontSize = 9,
    HeaderBackgroundColor = XLColor.White,
    HeaderFontColor = XLColor.Red
};
using var wb = new ExcelExporter()
    .WithStyles(styles)
    ...
    .ExportAsWorkbook();

Response in controller

 public IActionResult Export()
 {
     var wb = new ExcelExporter()
              ...
              .ExportAsWorkbook(data);
     var memoryStream = new MemoryStream();
     wb.SaveAs(memoryStream);
     wb.Disponse();
     memoryStream.Seek(0, SeekOrigin.Begin);
     return new FileStreamResult(memoryStream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
     {
         FileDownloadName = "filename.xslx"
     };
 }

Object list export

TODO

Import

TODO