public static HSSFEvaluationWorkbook Create(NPOI.SS.UserModel.Workbook book)
{
if (book == null)
{
return(null);
}
return(new HSSFEvaluationWorkbook((HSSFWorkbook)book));
}
public HSSFFormulaEvaluator(NPOI.SS.UserModel.Sheet sheet, NPOI.SS.UserModel.Workbook workbook)
: this(workbook)
{
this.sheet = sheet;
this.workbook = workbook;
}
/**
* @param udfFinder pass <code>null</code> for default (AnalysisToolPak only)
*/
private HSSFFormulaEvaluator(NPOI.SS.UserModel.Workbook workbook, IStabilityClassifier stabilityClassifier, UDFFinder udfFinder)
{
_bookEvaluator = new WorkbookEvaluator(HSSFEvaluationWorkbook.Create(workbook), stabilityClassifier, udfFinder);
}
/**
* @param stabilityClassifier used to optimise caching performance. Pass <code>null</code>
* for the (conservative) assumption that any cell may have its definition changed after
* evaluation begins.
*/
public HSSFFormulaEvaluator(NPOI.SS.UserModel.Workbook workbook, IStabilityClassifier stabilityClassifier)
: this(workbook, stabilityClassifier, null)
{
}
public HSSFFormulaEvaluator(NPOI.SS.UserModel.Workbook workbook)
: this(workbook, null)
{
}
public HSSFFormulaEvaluator(NPOI.SS.UserModel.Sheet sheet, NPOI.SS.UserModel.Workbook workbook)
: this(workbook)
{
this.sheet = sheet;
this.workbook = workbook;
}
/// <summary>
/// Gets the font for this style
/// </summary>
/// <param name="parentWorkbook">The parent workbook that this style belongs to.</param>
/// <returns></returns>
public NPOI.SS.UserModel.Font GetFont(NPOI.SS.UserModel.Workbook parentWorkbook)
{
return(((HSSFWorkbook)parentWorkbook).GetFontAt(FontIndex));
}