EvaluationSheet (The Adobe Experience Manager SDK 2023.8.13323.20230831T134651Z-230800)

```
@Internal
public interface EvaluationSheet
```
Abstracts a sheet for the purpose of formula evaluation.

Method Summary

All Methods Instance Methods Abstract Methods
Modifier and Type	Method	Description
`void`	`clearAllCachedResultValues()`	Propagated from `EvaluationWorkbook.clearAllCachedResultValues()` to clear locally cached data.
`EvaluationCell`	`getCell(int rowIndex, int columnIndex)`
`int`	`getLastRowNum()`
`boolean`	`isRowHidden(int rowIndex)`	Used by SUBTOTAL and similar functions that have options to ignore hidden rows

- Method Detail
  - getCell
```
EvaluationCell getCell(int rowIndex,
                       int columnIndex)
```
    Returns:
    
    null if there is no cell at the specified coordinates
  - clearAllCachedResultValues
```
void clearAllCachedResultValues()
```
    Propagated from EvaluationWorkbook.clearAllCachedResultValues() to clear locally cached data.
    
    Since:
    
    POI 3.15 beta 3
    
    See Also:
    
    WorkbookEvaluator.clearAllCachedResultValues(), EvaluationWorkbook.clearAllCachedResultValues()
  - getLastRowNum
```
int getLastRowNum()
```
    Returns:
    
    last row index referenced on this sheet, for evaluation optimization
    
    Since:
    
    POI 4.0.0
  - isRowHidden
```
boolean isRowHidden(int rowIndex)
```
    Used by SUBTOTAL and similar functions that have options to ignore hidden rows
    
    Returns:
    
    true if the row is hidden, false if not
    
    Since:
    
    POI 4.1.0