Uses of Class
org.apache.poi.ss.util.AreaReference
Packages that use AreaReference
Package
Description
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
This package contains common internal POI code for manipulating formulas.
formula package contains binary PTG structures used in Formulas
-
Uses of AreaReference in org.apache.poi.hssf.usermodel
Methods in org.apache.poi.hssf.usermodel that return AreaReferenceModifier and TypeMethodDescriptionHSSFCreationHelper.createAreaReference
(String reference) Creates an 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 AreaReferenceModifier and TypeMethodDescriptionHSSFEvaluationWorkbook.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 AreaReferenceModifier and TypeMethodDescriptionFormulaParsingWorkbook.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 AreaReferenceModifierConstructorDescriptionprotected
Area3DPtg
(AreaReference arearef, int externIdx) Area3DPxg
(int externalWorkbookNumber, SheetIdentifier sheetName, AreaReference arearef) Area3DPxg
(SheetIdentifier sheetName, AreaReference arearef) AreaPtg
(AreaReference arearef) protected
-
Uses of AreaReference in org.apache.poi.ss.usermodel
Methods in org.apache.poi.ss.usermodel that return AreaReferenceModifier and TypeMethodDescriptionCreationHelper.createAreaReference
(String reference) Creates an 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 AreaReferenceModifier and TypeMethodDescriptionstatic AreaReference[]
AreaReference.generateContiguous
(SpreadsheetVersion version, String reference) Takes a non-contiguous area reference, and returns an array of contiguous area referencesstatic AreaReference
AreaReference.getWholeColumn
(SpreadsheetVersion version, String start, String end) static AreaReference
AreaReference.getWholeRow
(SpreadsheetVersion version, String start, String end) -
Uses of AreaReference in org.apache.poi.xssf.streaming
Methods in org.apache.poi.xssf.streaming that return AreaReferenceModifier and TypeMethodDescriptionSXSSFCreationHelper.createAreaReference
(String reference) Creates an 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 AreaReferenceModifier and TypeMethodDescriptionXSSFCreationHelper.createAreaReference
(String reference) Creates an AreaReference.XSSFCreationHelper.createAreaReference
(CellReference topLeft, CellReference bottomRight) Creates an area ref from a pair of Cell References..XSSFTable.getArea()
Get the area that this table covers.XSSFTable.getCellReferences()
Get the area reference for the cells which this table covers.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 AreaReferenceModifier and TypeMethodDescriptionXSSFSheet.createPivotTable
(AreaReference source, CellReference position) Create a pivot table using the AreaReference range, at the given position.XSSFSheet.createPivotTable
(AreaReference source, CellReference position, Sheet sourceSheet) Create a pivot table using the AreaReference range on sourceSheet, at the given position.XSSFSheet.createTable
(AreaReference tableArea) Creates a new Table, and associates it with this Sheet.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.