Top Description Methods
org.apache.poi.ss.formula

public Interface ThreeDEval

extends TwoDEval, SheetRange
Known Direct Subinterfaces
org.apache.poi.ss.formula.eval.AreaEval
Imports
org.apache.poi.ss.formula.eval.AreaEval, .ValueEval
Optional Extension to the likes of AreaEval and org.apache.poi.ss.formula.eval.AreaEvalBase, which allows for looking up 3D (sheet+row+column) evaluations

Method Summary

Modifier and TypeMethod and Description
public ValueEval

Returns:

element at the specified row and column position
getValue(int
sheet index (zero based)
sheetIndex, int
relative row index (zero based)
rowIndex, int
relative column index (zero based)
columnIndex)

Inherited from org.apache.poi.ss.formula.SheetRange:
getFirstSheetIndexgetLastSheetIndex
Inherited from org.apache.poi.ss.formula.TwoDEval:
getColumngetHeightgetRowgetValuegetWidthisColumnisRowisRowHiddenisSubTotal

Method Detail

getValueback to summary
public ValueEval getValue(int sheetIndex, int rowIndex, int columnIndex)
Parameters
sheetIndex:int

sheet index (zero based)

rowIndex:int

relative row index (zero based)

columnIndex:int

relative column index (zero based)

Returns:ValueEval

element at the specified row and column position