internal NpoiExcelSheet( ISheet sheet, ReportOptions excelOptions, IExcelFormulaProvider formulaProvider) : base(excelOptions, formulaProvider) { _sheet = sheet.ThrowIfNull(nameof(sheet)); }
public static string ScottFormula(IExcelFormulaProvider formulaProvider, string normalizedValueRange, string experimentsNumber) { formulaProvider.ThrowIfNull(nameof(formulaProvider)); normalizedValueRange.ThrowIfNullOrWhiteSpace(nameof(normalizedValueRange)); experimentsNumber.ThrowIfNullOrWhiteSpace(nameof(experimentsNumber)); return($"(3.5 * {formulaProvider.StdDev(normalizedValueRange)}) / ({experimentsNumber}^(1/3))"); }
public static string Chi2(IExcelFormulaProvider formulaProvider, string chi2Range, string experimentsNumber) { formulaProvider.ThrowIfNull(nameof(formulaProvider)); chi2Range.ThrowIfNullOrWhiteSpace(nameof(chi2Range)); experimentsNumber.ThrowIfNullOrWhiteSpace(nameof(experimentsNumber)); return($"{formulaProvider.Sum(chi2Range)} * {experimentsNumber}"); }
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 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 static string GetFormulaForFunction(IExcelFormulaProvider formulaProvider, FunctionType functionType) { formulaProvider.ThrowIfNull(nameof(formulaProvider)); return(functionType switch { FunctionType.Exponential => formulaProvider.GetFormulaByName(nameof(IExcelFormulaProvider.Exp)), FunctionType.Line => string.Empty, FunctionType.Logarithm => formulaProvider.GetFormulaByName(nameof(IExcelFormulaProvider.Ln)), FunctionType.Polynomial => string.Empty, FunctionType.Power => string.Empty, _ => throw new ArgumentOutOfRangeException( nameof(functionType), functionType, $"Unknown function type: '{functionType.ToString()}'." ) });
public NpoiExcelWorkbook(ReportOptions excelOptions) { _excelOptions = excelOptions.ThrowIfNull(nameof(excelOptions)); _workbook = new XSSFWorkbook(); _formulaProvider = ExcelWrapperFactory.CreateFormulaProvider(excelOptions); }
protected BaseExcelSheet(ReportOptions excelOptions, IExcelFormulaProvider provider) { _excelOptions = excelOptions.ThrowIfNull(nameof(excelOptions)); FormulaProvider = provider.ThrowIfNull(nameof(provider)); }