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(); } }
// ctor public WorksheetFactory(IExcelPackage package, ExcelWorksheet excelWorksheet) { _package = package ?? throw new ArgumentNullException(nameof(package)); ws = excelWorksheet ?? throw new ArgumentNullException(nameof(excelWorksheet)); }