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 AreaReference
HSSFCreationHelper. createAreaReference(java.lang.String reference)
Creates an AreaReference.AreaReference
HSSFCreationHelper. 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 Ptg
HSSFEvaluationWorkbook. 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 Ptg
FormulaParsingWorkbook. 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 AreaReference
CreationHelper. createAreaReference(java.lang.String reference)
Creates an AreaReference.AreaReference
CreationHelper. 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 AreaReference
AreaReference. getWholeColumn(SpreadsheetVersion version, java.lang.String start, java.lang.String end)
static AreaReference
AreaReference. 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 AreaReference
SXSSFCreationHelper. createAreaReference(java.lang.String reference)
Creates an AreaReference.AreaReference
SXSSFCreationHelper. 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 AreaReference
XSSFCreationHelper. createAreaReference(java.lang.String reference)
Creates an AreaReference.AreaReference
XSSFCreationHelper. createAreaReference(CellReference topLeft, CellReference bottomRight)
Creates an area ref from a pair of Cell References..AreaReference
XSSFTable. getArea()
Get the area that this table covers.AreaReference
XSSFTable. getCellReferences()
Get the area reference for the cells which this table covers.AreaReference
XSSFPivotCacheDefinition. getPivotArea(Workbook wb)
Find the 2D base data area for the pivot table, either from its direct reference or named table/range.protected AreaReference
XSSFPivotTable. getPivotArea()
Methods in org.apache.poi.xssf.usermodel with parameters of type AreaReference Modifier and Type Method Description XSSFPivotTable
XSSFSheet. createPivotTable(AreaReference source, CellReference position)
Create a pivot table using the AreaReference range, at the given position.XSSFPivotTable
XSSFSheet. createPivotTable(AreaReference source, CellReference position, Sheet sourceSheet)
Create a pivot table using the AreaReference range on sourceSheet, at the given position.XSSFTable
XSSFSheet. createTable(AreaReference tableArea)
Creates a new Table, and associates it with this Sheet.Ptg
BaseXSSFEvaluationWorkbook. get3DReferencePtg(AreaReference area, SheetIdentifier sheet)
void
XSSFTable. setArea(AreaReference tableArea)
Set the area reference for the cells which this table covers.protected void
XSSFTable. setCellRef(AreaReference refs)
void
XSSFTable. setCellReferences(AreaReference refs)
Set the area reference for the cells which this table covers.
-