Uses of Class
org.apache.poi.ss.util.AreaReference
-
Packages that use AreaReference Package Description org.apache.poi.hssf.usermodel usermodel package maps HSSF low level strutures to familiar workbook/sheet modelorg.apache.poi.ss.formula This package contains common internal POI code for manipulating formulas.org.apache.poi.ss.formula.ptg formula package contains binary PTG structures used in Formulasorg.apache.poi.ss.usermodel org.apache.poi.ss.util org.apache.poi.xssf.streaming org.apache.poi.xssf.usermodel -
-
Uses of AreaReference in org.apache.poi.hssf.usermodel
Methods in org.apache.poi.hssf.usermodel that return AreaReference Modifier and Type Method Description AreaReferenceHSSFCreationHelper. createAreaReference(java.lang.String reference)Creates an AreaReference.AreaReferenceHSSFCreationHelper. createAreaReference(CellReference topLeft, CellReference bottomRight)Creates an area ref from a pair of Cell References..Methods in org.apache.poi.hssf.usermodel with parameters of type AreaReference Modifier and Type Method Description PtgHSSFEvaluationWorkbook. get3DReferencePtg(AreaReference areaRef, SheetIdentifier sheet) -
Uses of AreaReference in org.apache.poi.ss.formula
Methods in org.apache.poi.ss.formula with parameters of type AreaReference Modifier and Type Method Description PtgFormulaParsingWorkbook. get3DReferencePtg(AreaReference area, SheetIdentifier sheet)Produce the appropriate Ptg for a 3d area reference -
Uses of AreaReference in org.apache.poi.ss.formula.ptg
Constructors in org.apache.poi.ss.formula.ptg with parameters of type AreaReference Constructor Description Area2DPtgBase(AreaReference ar)Area3DPtg(AreaReference arearef, int externIdx)Area3DPxg(int externalWorkbookNumber, SheetIdentifier sheetName, AreaReference arearef)Area3DPxg(SheetIdentifier sheetName, AreaReference arearef)AreaPtg(AreaReference arearef)AreaPtgBase(AreaReference ar) -
Uses of AreaReference in org.apache.poi.ss.usermodel
Methods in org.apache.poi.ss.usermodel that return AreaReference Modifier and Type Method Description AreaReferenceCreationHelper. createAreaReference(java.lang.String reference)Creates an AreaReference.AreaReferenceCreationHelper. createAreaReference(CellReference topLeft, CellReference bottomRight)Creates an area ref from a pair of Cell References.. -
Uses of AreaReference in org.apache.poi.ss.util
Methods in org.apache.poi.ss.util that return AreaReference Modifier and Type Method Description static AreaReference[]AreaReference. generateContiguous(SpreadsheetVersion version, java.lang.String reference)Takes a non-contiguous area reference, and returns an array of contiguous area referencesstatic AreaReferenceAreaReference. getWholeColumn(SpreadsheetVersion version, java.lang.String start, java.lang.String end)static AreaReferenceAreaReference. getWholeRow(SpreadsheetVersion version, java.lang.String start, java.lang.String end) -
Uses of AreaReference in org.apache.poi.xssf.streaming
Methods in org.apache.poi.xssf.streaming that return AreaReference Modifier and Type Method Description AreaReferenceSXSSFCreationHelper. createAreaReference(java.lang.String reference)Creates an AreaReference.AreaReferenceSXSSFCreationHelper. createAreaReference(CellReference topLeft, CellReference bottomRight)Creates an area ref from a pair of Cell References.. -
Uses of AreaReference in org.apache.poi.xssf.usermodel
Methods in org.apache.poi.xssf.usermodel that return AreaReference Modifier and Type Method Description AreaReferenceXSSFCreationHelper. createAreaReference(java.lang.String reference)Creates an AreaReference.AreaReferenceXSSFCreationHelper. createAreaReference(CellReference topLeft, CellReference bottomRight)Creates an area ref from a pair of Cell References..AreaReferenceXSSFTable. getArea()Get the area that this table covers.AreaReferenceXSSFTable. getCellReferences()Get the area reference for the cells which this table covers.AreaReferenceXSSFPivotCacheDefinition. getPivotArea(Workbook wb)Find the 2D base data area for the pivot table, either from its direct reference or named table/range.protected AreaReferenceXSSFPivotTable. getPivotArea()Methods in org.apache.poi.xssf.usermodel with parameters of type AreaReference Modifier and Type Method Description XSSFPivotTableXSSFSheet. createPivotTable(AreaReference source, CellReference position)Create a pivot table using the AreaReference range, at the given position.XSSFPivotTableXSSFSheet. createPivotTable(AreaReference source, CellReference position, Sheet sourceSheet)Create a pivot table using the AreaReference range on sourceSheet, at the given position.XSSFTableXSSFSheet. createTable(AreaReference tableArea)Creates a new Table, and associates it with this Sheet.PtgBaseXSSFEvaluationWorkbook. get3DReferencePtg(AreaReference area, SheetIdentifier sheet)voidXSSFTable. setArea(AreaReference tableArea)Set the area reference for the cells which this table covers.protected voidXSSFTable. setCellRef(AreaReference refs)voidXSSFTable. setCellReferences(AreaReference refs)Set the area reference for the cells which this table covers.
-