public NpoiExcelWorkbook(FileInfo pathToWorkbook, ReportOptions excelOptions)
{
pathToWorkbook.ThrowIfNull(nameof(pathToWorkbook));
_excelOptions = excelOptions.ThrowIfNull(nameof(excelOptions));
using (var file = new FileStream(pathToWorkbook.FullName, FileMode.Open, FileAccess.Read))
{
_workbook = new XSSFWorkbook(file);
}
_formulaProvider = ExcelWrapperFactory.CreateFormulaProvider(excelOptions);
}
public static IExcelWorkbook GetOrCreateWorkbook(FileInfo outputExcelFile)
{
outputExcelFile.ThrowIfNull(nameof(outputExcelFile));
// Use static File method because FileInfo can have out-of-date state.
if (File.Exists(outputExcelFile.FullName))
{
return(ExcelWrapperFactory.CreateWorkbook(outputExcelFile));
}
return(ExcelWrapperFactory.CreateWorkbook());
}
public EpplusExcelWorkbook(ReportOptions excelOptions)
{
InitPackageLicence();
_excelOptions = excelOptions.ThrowIfNull(nameof(excelOptions));
_package = new ExcelPackage();
_formulaProvider = ExcelWrapperFactory.CreateFormulaProvider(excelOptions);
_epplusLogger = new EpplusLogger(_package, ConfigOptions.Logger);
_epplusLogger.AttachLogger();
RegisterFunctionModules();
}
public NpoiExcelWorkbook(ReportOptions excelOptions)
{
_excelOptions = excelOptions.ThrowIfNull(nameof(excelOptions));
_workbook = new XSSFWorkbook();
_formulaProvider = ExcelWrapperFactory.CreateFormulaProvider(excelOptions);
}
