Example #1
0
        public void RenderToFile(string fileName)
        {
            var newFile = _fileHelper.GetFileInfo(fileName);

            using (IExcelPackage xlPackage = _excelFileProcessor.CreatePackage(newFile))
            {
                string mainSheetName = "Main sheet";
                xlPackage.Workbook.Worksheets.Add(mainSheetName);

                FillCells(xlPackage.Workbook.Worksheets.GetWorksheet(mainSheetName));

                xlPackage.Save();
            }
        }
Example #2
0
 // ctor
 public WorksheetFactory(IExcelPackage package, ExcelWorksheet excelWorksheet)
 {
     _package = package ?? throw new ArgumentNullException(nameof(package));
     ws       = excelWorksheet ?? throw new ArgumentNullException(nameof(excelWorksheet));
 }