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));
}
