Example #1
0
 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]);
 }
Example #2
0
 public XSSFEvaluationCell(ICell cell, XSSFEvaluationSheet EvaluationSheet)
 {
     _cell      = (XSSFCell)cell;
     _evalSheet = EvaluationSheet;
 }
Example #3
0
 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;
 }