public override IEvaluationSheet GetSheet(int sheetIndex)
{
// Performance optimization: build sheet cache the first time this is called
// to avoid re-creating the XSSFEvaluationSheet each time a new cell is evaluated
// EvaluationWorkbooks make not guarantee to synchronize changes made to
// the underlying workbook after the EvaluationWorkbook is created.
if (_sheetCache == null)
{
int numberOfSheets = _uBook.NumberOfSheets;
_sheetCache = new XSSFEvaluationSheet[numberOfSheets];
for (int i = 0; i < numberOfSheets; i++)
{
_sheetCache[i] = new XSSFEvaluationSheet(_uBook.GetSheetAt(i));
}
}
if (sheetIndex < 0 || sheetIndex >= _sheetCache.Length)
{
// do this to reuse the out-of-bounds logic and message from XSSFWorkbook
_uBook.GetSheetAt(sheetIndex);
}
return(_sheetCache[sheetIndex]);
}
public XSSFEvaluationCell(ICell cell, XSSFEvaluationSheet EvaluationSheet)
{
_cell = (XSSFCell)cell;
_evalSheet = EvaluationSheet;
}
public XSSFEvaluationCell(ICell cell, XSSFEvaluationSheet EvaluationSheet)
{
_cell = (XSSFCell)cell;
_evalSheet = EvaluationSheet;
}
public XSSFEvaluationCell(ICell cell, XSSFEvaluationSheet EvaluationSheet)
{
this._cell = (XSSFCell)cell;
this._evalSheet = (IEvaluationSheet)EvaluationSheet;
}