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) { this._cell = (XSSFCell)cell; this._evalSheet = (IEvaluationSheet)EvaluationSheet; }