Apache POI - Common 5.3.0 · org.apache.poi.ss.formula.SheetRangeEvaluator

Field Summary

Modifier and Type	Field and Description
private final int	_firstSheetIndex
private final int	_lastSheetIndex
private final SheetRefEvaluator[]	_sheetEvaluators

Constructor Summary

Access	Constructor and Description
public	SheetRangeEvaluator(int firstSheetIndex, int lastSheetIndex, SheetRefEvaluator[] sheetEvaluators)
public	SheetRangeEvaluator(int onlySheetIndex, SheetRefEvaluator sheetEvaluator)

Method Summary

Modifier and Type	Method and Description
public int	Returns: If the given index lies withing the max row number across all sheets, it is returned. Otherwise, the highest used row number across all sheets is returned. adjustRowNumber(int The 0-based row-index to check rowIndex) This method returns a lower row-number if it would lie outside the row-boundaries of any sheet.
public ValueEval	getEvalForCell(int sheetIndex, int rowIndex, int columnIndex)
public int	getFirstSheetIndex() Implements org.apache.poi.ss.formula.SheetRange.getFirstSheetIndex.
public int	getLastSheetIndex() Implements org.apache.poi.ss.formula.SheetRange.getLastSheetIndex.
public SheetRefEvaluator	getSheetEvaluator(int sheetIndex)
public String	getSheetName(int sheetIndex)
public String	getSheetNameRange()

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

_firstSheetIndex	back to summary
private final int _firstSheetIndex

_lastSheetIndex	back to summary
private final int _lastSheetIndex

_sheetEvaluators	back to summary
private final SheetRefEvaluator[] _sheetEvaluators

Constructor Detail

SheetRangeEvaluator	back to summary
public SheetRangeEvaluator(int firstSheetIndex, int lastSheetIndex, SheetRefEvaluator[] sheetEvaluators)

SheetRangeEvaluator	back to summary
public SheetRangeEvaluator(int onlySheetIndex, SheetRefEvaluator sheetEvaluator)

Method Detail

adjustRowNumber	back to summary
public int adjustRowNumber(int rowIndex) This method returns a lower row-number if it would lie outside the row-boundaries of any sheet. This is used to optimize cases where very high number of rows would be checked otherwise without any benefit as no such row exists anyway. Parameters rowIndex:int The 0-based row-index to check Returns:int If the given index lies withing the max row number across all sheets, it is returned. Otherwise, the highest used row number across all sheets is returned.

adjustRowNumber

back to summary

public int adjustRowNumber(int rowIndex)

This method returns a lower row-number if it would lie outside the row-boundaries of any sheet. This is used to optimize cases where very high number of rows would be checked otherwise without any benefit as no such row exists anyway.

Parameters

rowIndex:int: The 0-based row-index to check

Returns:int

If the given index lies withing the max row number across all sheets, it is returned. Otherwise, the highest used row number across all sheets is returned.

getEvalForCell	back to summary
public ValueEval getEvalForCell(int sheetIndex, int rowIndex, int columnIndex)

getFirstSheetIndex	back to summary
public int getFirstSheetIndex() Implements org.apache.poi.ss.formula.SheetRange.getFirstSheetIndex.

getLastSheetIndex	back to summary
public int getLastSheetIndex() Implements org.apache.poi.ss.formula.SheetRange.getLastSheetIndex.

getSheetEvaluator	back to summary
public SheetRefEvaluator getSheetEvaluator(int sheetIndex)

getSheetName	back to summary
public String getSheetName(int sheetIndex)

getSheetNameRange	back to summary
public String getSheetNameRange()