|
||||||||||
PREV NEXT | FRAMES NO FRAMES |
Packages that use CellRangeAddress | |
---|---|
org.apache.poi.hssf.converter | |
org.apache.poi.hssf.model | Provides low level API structures for reading, writing, modifying XLS files. |
org.apache.poi.hssf.record | Record package contains class representations for XLS binary strutures. |
org.apache.poi.hssf.record.aggregates | record aggregates are not real "records" but collections of records that act as a single record. |
org.apache.poi.hssf.record.common | |
org.apache.poi.hssf.usermodel | usermodel package maps HSSF low level strutures to familiar workbook/sheet model |
org.apache.poi.hssf.util | util package contains tools needed for writing HSSF files that are not necesarily "real" HSSF concepts. |
org.apache.poi.ss.formula | This package contains common internal POI code for manipulating formulas. |
org.apache.poi.ss.usermodel | |
org.apache.poi.ss.usermodel.charts | |
org.apache.poi.ss.usermodel.helpers | |
org.apache.poi.ss.util | |
org.apache.poi.ss.util.cellwalk | |
org.apache.poi.xssf.streaming | |
org.apache.poi.xssf.usermodel | |
org.apache.poi.xssf.usermodel.helpers |
Uses of CellRangeAddress in org.apache.poi.hssf.converter |
---|
Methods in org.apache.poi.hssf.converter that return CellRangeAddress | |
---|---|
static CellRangeAddress[][] |
ExcelToHtmlUtils.buildMergedRangesMap(HSSFSheet sheet)
Creates a map (i.e. |
static CellRangeAddress |
AbstractExcelUtils.getMergedRange(CellRangeAddress[][] mergedRanges,
int rowNumber,
int columnNumber)
|
Methods in org.apache.poi.hssf.converter with parameters of type CellRangeAddress | |
---|---|
static CellRangeAddress |
AbstractExcelUtils.getMergedRange(CellRangeAddress[][] mergedRanges,
int rowNumber,
int columnNumber)
|
protected int |
ExcelToHtmlConverter.processRow(CellRangeAddress[][] mergedRanges,
HSSFRow row,
org.w3c.dom.Element tableRowElement)
|
protected int |
ExcelToFoConverter.processRow(HSSFWorkbook workbook,
CellRangeAddress[][] mergedRanges,
HSSFRow row,
org.w3c.dom.Element tableRowElement)
|
Uses of CellRangeAddress in org.apache.poi.hssf.model |
---|
Methods in org.apache.poi.hssf.model that return CellRangeAddress | |
---|---|
CellRangeAddress |
InternalSheet.getMergedRegionAt(int index)
|
Uses of CellRangeAddress in org.apache.poi.hssf.record |
---|
Methods in org.apache.poi.hssf.record that return CellRangeAddress | |
---|---|
CellRangeAddress |
MergeCellsRecord.getAreaAt(int index)
|
CellRangeAddress |
CFRule12Record.getAssociatedRange()
|
CellRangeAddress |
CFHeader12Record.getAssociatedRange()
|
CellRangeAddress[] |
CFHeaderBase.getCellRanges()
|
CellRangeAddress[] |
FeatRecord.getCellRefs()
|
CellRangeAddress |
CFHeaderBase.getEnclosingCellRange()
|
Methods in org.apache.poi.hssf.record with parameters of type CellRangeAddress | |
---|---|
void |
CFHeaderBase.setCellRanges(CellRangeAddress[] cellRanges)
Set cell ranges list to a single cell range and modify the enclosing cell range accordingly. |
void |
FeatRecord.setCellRefs(CellRangeAddress[] cellRefs)
|
void |
CFHeaderBase.setEnclosingCellRange(CellRangeAddress cr)
|
Constructors in org.apache.poi.hssf.record with parameters of type CellRangeAddress | |
---|---|
CFHeader12Record(CellRangeAddress[] regions,
int nRules)
|
|
CFHeaderBase(CellRangeAddress[] regions,
int nRules)
|
|
CFHeaderRecord(CellRangeAddress[] regions,
int nRules)
|
|
MergeCellsRecord(CellRangeAddress[] regions,
int startIndex,
int numberOfRegions)
|
Uses of CellRangeAddress in org.apache.poi.hssf.record.aggregates |
---|
Methods in org.apache.poi.hssf.record.aggregates that return CellRangeAddress | |
---|---|
CellRangeAddress |
MergedCellsTable.get(int index)
|
CellRangeAddress |
FormulaRecordAggregate.getArrayFormulaRange()
|
CellRangeAddress |
FormulaRecordAggregate.removeArrayFormula(int rowIndex,
int columnIndex)
Removes an array formula |
Methods in org.apache.poi.hssf.record.aggregates with parameters of type CellRangeAddress | |
---|---|
void |
FormulaRecordAggregate.setArrayFormula(CellRangeAddress r,
Ptg[] ptgs)
|
Constructors in org.apache.poi.hssf.record.aggregates with parameters of type CellRangeAddress | |
---|---|
CFRecordsAggregate(CellRangeAddress[] regions,
CFRuleBase[] rules)
|
Uses of CellRangeAddress in org.apache.poi.hssf.record.common |
---|
Methods in org.apache.poi.hssf.record.common that return CellRangeAddress | |
---|---|
CellRangeAddress |
FutureRecord.getAssociatedRange()
|
CellRangeAddress |
FtrHeader.getAssociatedRange()
|
Methods in org.apache.poi.hssf.record.common with parameters of type CellRangeAddress | |
---|---|
void |
FtrHeader.setAssociatedRange(CellRangeAddress associatedRange)
|
Uses of CellRangeAddress in org.apache.poi.hssf.usermodel |
---|
Methods in org.apache.poi.hssf.usermodel that return CellRangeAddress | |
---|---|
CellRangeAddress |
HSSFCell.getArrayFormulaRange()
|
CellRangeAddress[] |
HSSFConditionalFormatting.getFormattingRanges()
|
CellRangeAddress |
HSSFSheet.getMergedRegion(int index)
|
CellRangeAddress |
HSSFSheet.getRepeatingColumns()
|
CellRangeAddress |
HSSFSheet.getRepeatingRows()
|
Methods in org.apache.poi.hssf.usermodel that return types with arguments of type CellRangeAddress | |
---|---|
java.util.List<CellRangeAddress> |
HSSFSheet.getMergedRegions()
|
Methods in org.apache.poi.hssf.usermodel with parameters of type CellRangeAddress | |
---|---|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule1)
|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule[] cfRules)
|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule1,
ConditionalFormattingRule rule2)
|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
HSSFConditionalFormattingRule rule1)
|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
HSSFConditionalFormattingRule[] cfRules)
Allows to add a new Conditional Formatting set to the sheet. |
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
HSSFConditionalFormattingRule rule1,
HSSFConditionalFormattingRule rule2)
|
int |
HSSFSheet.addMergedRegion(CellRangeAddress region)
Adds a merged region of cells on a sheet. |
int |
HSSFSheet.addMergedRegionUnsafe(CellRangeAddress region)
Adds a merged region of cells (hence those cells form one). |
CellRange<HSSFCell> |
HSSFSheet.setArrayFormula(java.lang.String formula,
CellRangeAddress range)
|
HSSFAutoFilter |
HSSFSheet.setAutoFilter(CellRangeAddress range)
|
void |
HSSFConditionalFormatting.setFormattingRanges(CellRangeAddress[] ranges)
|
void |
HSSFSheet.setRepeatingColumns(CellRangeAddress columnRangeRef)
|
void |
HSSFSheet.setRepeatingRows(CellRangeAddress rowRangeRef)
|
Uses of CellRangeAddress in org.apache.poi.hssf.util |
---|
Methods in org.apache.poi.hssf.util with parameters of type CellRangeAddress | |
---|---|
static void |
HSSFRegionUtil.setBorderBottom(int border,
CellRangeAddress region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Sets the borderBottom attribute of the HSSFRegionUtil object |
static void |
HSSFRegionUtil.setBorderLeft(int border,
CellRangeAddress region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Sets the left border for a region of cells by manipulating the cell style of the individual cells on the left |
static void |
HSSFRegionUtil.setBorderRight(int border,
CellRangeAddress region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Sets the borderRight attribute of the HSSFRegionUtil object |
static void |
HSSFRegionUtil.setBorderTop(int border,
CellRangeAddress region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Sets the borderBottom attribute of the HSSFRegionUtil object |
static void |
HSSFRegionUtil.setBottomBorderColor(int color,
CellRangeAddress region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Sets the bottomBorderColor attribute of the HSSFRegionUtil object |
static void |
HSSFRegionUtil.setLeftBorderColor(int color,
CellRangeAddress region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Sets the leftBorderColor attribute of the HSSFRegionUtil object |
static void |
HSSFRegionUtil.setRightBorderColor(int color,
CellRangeAddress region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Sets the rightBorderColor attribute of the HSSFRegionUtil object |
static void |
HSSFRegionUtil.setTopBorderColor(int color,
CellRangeAddress region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Sets the topBorderColor attribute of the HSSFRegionUtil object |
Uses of CellRangeAddress in org.apache.poi.ss.formula |
---|
Methods in org.apache.poi.ss.formula that return CellRangeAddress | |
---|---|
CellRangeAddress[] |
EvaluationConditionalFormatRule.getRegions()
|
Constructors in org.apache.poi.ss.formula with parameters of type CellRangeAddress | |
---|---|
EvaluationConditionalFormatRule(WorkbookEvaluator workbookEvaluator,
Sheet sheet,
ConditionalFormatting formatting,
int formattingIndex,
ConditionalFormattingRule rule,
int ruleIndex,
CellRangeAddress[] regions)
|
Uses of CellRangeAddress in org.apache.poi.ss.usermodel |
---|
Methods in org.apache.poi.ss.usermodel that return CellRangeAddress | |
---|---|
CellRangeAddress |
Cell.getArrayFormulaRange()
Only valid for array formula cells |
CellRangeAddress[] |
ConditionalFormatting.getFormattingRanges()
|
CellRangeAddress |
Sheet.getMergedRegion(int index)
Returns the merged region at the specified index |
CellRangeAddress |
Sheet.getRepeatingColumns()
Gets the repeating columns used when printing the sheet, as found in File->PageSetup->Sheet. |
CellRangeAddress |
Sheet.getRepeatingRows()
Gets the repeating rows used when printing the sheet, as found in File->PageSetup->Sheet. |
Methods in org.apache.poi.ss.usermodel that return types with arguments of type CellRangeAddress | |
---|---|
java.util.List<CellRangeAddress> |
Sheet.getMergedRegions()
Returns the list of merged regions. |
Methods in org.apache.poi.ss.usermodel with parameters of type CellRangeAddress | |
---|---|
int |
SheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule)
Add a new Conditional Formatting to the sheet. |
int |
SheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule[] cfRules)
Add a new Conditional Formatting set to the sheet. |
int |
SheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule1,
ConditionalFormattingRule rule2)
Add a new Conditional Formatting consisting of two rules. |
int |
Sheet.addMergedRegion(CellRangeAddress region)
Adds a merged region of cells (hence those cells form one) |
int |
Sheet.addMergedRegionUnsafe(CellRangeAddress region)
Adds a merged region of cells (hence those cells form one). |
CellRange<? extends Cell> |
Sheet.setArrayFormula(java.lang.String formula,
CellRangeAddress range)
Sets array formula to specified region for result. |
AutoFilter |
Sheet.setAutoFilter(CellRangeAddress range)
Enable filtering for a range of cells |
void |
ConditionalFormatting.setFormattingRanges(CellRangeAddress[] ranges)
Sets the cell ranges the rule conditional formatting must be applied to. |
void |
Sheet.setRepeatingColumns(CellRangeAddress columnRangeRef)
Sets the repeating columns used when printing the sheet, as found in File->PageSetup->Sheet. |
void |
Sheet.setRepeatingRows(CellRangeAddress rowRangeRef)
Sets the repeating rows used when printing the sheet, as found in File->PageSetup->Sheet. |
Uses of CellRangeAddress in org.apache.poi.ss.usermodel.charts |
---|
Methods in org.apache.poi.ss.usermodel.charts with parameters of type CellRangeAddress | |
---|---|
static ChartDataSource<java.lang.Number> |
DataSources.fromNumericCellRange(Sheet sheet,
CellRangeAddress cellRangeAddress)
|
static ChartDataSource<java.lang.String> |
DataSources.fromStringCellRange(Sheet sheet,
CellRangeAddress cellRangeAddress)
|
Uses of CellRangeAddress in org.apache.poi.ss.usermodel.helpers |
---|
Methods in org.apache.poi.ss.usermodel.helpers that return types with arguments of type CellRangeAddress | |
---|---|
java.util.List<CellRangeAddress> |
RowShifter.shiftMergedRegions(int startRow,
int endRow,
int n)
Shifts, grows, or shrinks the merged regions due to a row shift. |
Uses of CellRangeAddress in org.apache.poi.ss.util |
---|
Fields in org.apache.poi.ss.util with type parameters of type CellRangeAddress | |
---|---|
protected java.util.List<CellRangeAddress> |
CellRangeAddressList._list
List of CellRangeAddresses. |
Methods in org.apache.poi.ss.util that return CellRangeAddress | |
---|---|
CellRangeAddress |
CellRangeAddress.copy()
|
static CellRangeAddress |
CellRangeUtil.createEnclosingCellRange(CellRangeAddress crA,
CellRangeAddress crB)
Create an enclosing CellRange for the two cell ranges. |
CellRangeAddress |
CellRangeAddressList.getCellRangeAddress(int index)
|
CellRangeAddress[] |
CellRangeAddressList.getCellRangeAddresses()
|
static CellRangeAddress[] |
CellRangeUtil.mergeCellRanges(CellRangeAddress[] cellRanges)
Do all possible cell merges between cells of the list so that: if a cell range is completely inside of another cell range, it gets removed from the list if two cells have a shared border, merge them into one bigger cell range |
CellRangeAddress |
CellRangeAddressList.remove(int rangeIndex)
|
static CellRangeAddress |
CellRangeAddress.valueOf(java.lang.String ref)
Creates a CellRangeAddress from a cell range reference string. |
Methods in org.apache.poi.ss.util with parameters of type CellRangeAddress | |
---|---|
void |
CellRangeAddressList.addCellRangeAddress(CellRangeAddress cra)
|
static boolean |
CellRangeUtil.contains(CellRangeAddress crA,
CellRangeAddress crB)
Check if cell range A contains cell range B (B <= A) TODO: move this into CellRangeAddressBase |
static boolean |
SheetUtil.containsCell(CellRangeAddress cr,
int rowIx,
int colIx)
Deprecated. 3.15 beta 2. Use CellRangeAddressBase.isInRange(int, int) . |
static CellRangeAddress |
CellRangeUtil.createEnclosingCellRange(CellRangeAddress crA,
CellRangeAddress crB)
Create an enclosing CellRange for the two cell ranges. |
void |
PropertyTemplate.drawBorderColors(CellRangeAddress range,
short color,
BorderExtent extent)
Sets the color for a group of cell borders for a cell range. |
void |
PropertyTemplate.drawBorders(CellRangeAddress range,
BorderStyle borderType,
BorderExtent extent)
Draws a group of cell borders for a cell range. |
void |
PropertyTemplate.drawBorders(CellRangeAddress range,
BorderStyle borderType,
short color,
BorderExtent extent)
Draws a group of cell borders for a cell range. |
static boolean |
CellRangeUtil.hasExactSharedBorder(CellRangeAddress crA,
CellRangeAddress crB)
Check if the two cell ranges have a shared border. |
static int |
CellRangeUtil.intersect(CellRangeAddress crA,
CellRangeAddress crB)
Get the type of intersection between two cell ranges |
static CellRangeAddress[] |
CellRangeUtil.mergeCellRanges(CellRangeAddress[] cellRanges)
Do all possible cell merges between cells of the list so that: if a cell range is completely inside of another cell range, it gets removed from the list if two cells have a shared border, merge them into one bigger cell range |
static void |
RegionUtil.setBorderBottom(BorderStyle border,
CellRangeAddress region,
Sheet sheet)
Sets the bottom border style for a region of cells by manipulating the cell style of the individual cells on the bottom |
static void |
RegionUtil.setBorderBottom(int border,
CellRangeAddress region,
Sheet sheet)
Deprecated. POI 3.16 beta 1. Use RegionUtil.setBorderBottom(BorderStyle, CellRangeAddress, Sheet) . |
static void |
RegionUtil.setBorderLeft(BorderStyle border,
CellRangeAddress region,
Sheet sheet)
Sets the left border style for a region of cells by manipulating the cell style of the individual cells on the left |
static void |
RegionUtil.setBorderLeft(int border,
CellRangeAddress region,
Sheet sheet)
Deprecated. 3.16 beta 1. Use RegionUtil.setBorderLeft(BorderStyle, CellRangeAddress, Sheet) . |
static void |
RegionUtil.setBorderRight(BorderStyle border,
CellRangeAddress region,
Sheet sheet)
Sets the right border style for a region of cells by manipulating the cell style of the individual cells on the right |
static void |
RegionUtil.setBorderRight(int border,
CellRangeAddress region,
Sheet sheet)
Deprecated. POI 3.16 beta 1. Use RegionUtil.setBorderRight(BorderStyle, CellRangeAddress, Sheet) . |
static void |
RegionUtil.setBorderTop(BorderStyle border,
CellRangeAddress region,
Sheet sheet)
Sets the top border style for a region of cells by manipulating the cell style of the individual cells on the top |
static void |
RegionUtil.setBorderTop(int border,
CellRangeAddress region,
Sheet sheet)
Deprecated. 3.16 beta 1. Use RegionUtil.setBorderTop(BorderStyle, CellRangeAddress, Sheet) . |
static void |
RegionUtil.setBottomBorderColor(int color,
CellRangeAddress region,
Sheet sheet)
Sets the bottom border color for a region of cells by manipulating the cell style of the individual cells on the bottom |
static void |
RegionUtil.setLeftBorderColor(int color,
CellRangeAddress region,
Sheet sheet)
Sets the left border color for a region of cells by manipulating the cell style of the individual cells on the left |
static void |
RegionUtil.setRightBorderColor(int color,
CellRangeAddress region,
Sheet sheet)
Sets the right border color for a region of cells by manipulating the cell style of the individual cells on the right |
static void |
RegionUtil.setTopBorderColor(int color,
CellRangeAddress region,
Sheet sheet)
Sets the top border color for a region of cells by manipulating the cell style of the individual cells on the top |
Uses of CellRangeAddress in org.apache.poi.ss.util.cellwalk |
---|
Constructors in org.apache.poi.ss.util.cellwalk with parameters of type CellRangeAddress | |
---|---|
CellWalk(Sheet sheet,
CellRangeAddress range)
|
Uses of CellRangeAddress in org.apache.poi.xssf.streaming |
---|
Methods in org.apache.poi.xssf.streaming that return CellRangeAddress | |
---|---|
CellRangeAddress |
SXSSFCell.getArrayFormulaRange()
Only valid for array formula cells |
CellRangeAddress |
SXSSFSheet.getMergedRegion(int index)
Returns the merged region at the specified index. |
CellRangeAddress |
SXSSFSheet.getRepeatingColumns()
|
CellRangeAddress |
SXSSFSheet.getRepeatingRows()
|
Methods in org.apache.poi.xssf.streaming that return types with arguments of type CellRangeAddress | |
---|---|
java.util.List<CellRangeAddress> |
SXSSFSheet.getMergedRegions()
Returns the list of merged regions. |
Methods in org.apache.poi.xssf.streaming with parameters of type CellRangeAddress | |
---|---|
int |
SXSSFSheet.addMergedRegion(CellRangeAddress region)
Adds a merged region of cells (hence those cells form one) |
int |
SXSSFSheet.addMergedRegionUnsafe(CellRangeAddress region)
Adds a merged region of cells (hence those cells form one) |
CellRange<? extends Cell> |
SXSSFSheet.setArrayFormula(java.lang.String formula,
CellRangeAddress range)
Sets array formula to specified region for result. |
AutoFilter |
SXSSFSheet.setAutoFilter(CellRangeAddress range)
Enable filtering for a range of cells |
void |
SXSSFSheet.setRepeatingColumns(CellRangeAddress columnRangeRef)
|
void |
SXSSFSheet.setRepeatingRows(CellRangeAddress rowRangeRef)
|
Uses of CellRangeAddress in org.apache.poi.xssf.usermodel |
---|
Methods in org.apache.poi.xssf.usermodel that return CellRangeAddress | |
---|---|
CellRangeAddress |
XSSFCell.getArrayFormulaRange()
|
CellRangeAddress[] |
XSSFConditionalFormatting.getFormattingRanges()
|
CellRangeAddress |
XSSFSheet.getMergedRegion(int index)
Returns the merged region at the specified index. |
CellRangeAddress |
XSSFSheet.getRepeatingColumns()
|
CellRangeAddress |
XSSFSheet.getRepeatingRows()
|
Methods in org.apache.poi.xssf.usermodel that return types with arguments of type CellRangeAddress | |
---|---|
java.util.Map<IgnoredErrorType,java.util.Set<CellRangeAddress>> |
XSSFSheet.getIgnoredErrors()
Returns the errors currently being ignored and the ranges where they are ignored. |
java.util.List<CellRangeAddress> |
XSSFSheet.getMergedRegions()
Returns the list of merged regions. |
Methods in org.apache.poi.xssf.usermodel with parameters of type CellRangeAddress | |
---|---|
int |
XSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule1)
|
int |
XSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule[] cfRules)
|
int |
XSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule1,
ConditionalFormattingRule rule2)
|
void |
XSSFSheet.addIgnoredErrors(CellRangeAddress region,
IgnoredErrorType... ignoredErrorTypes)
Ignore errors across a range of cells. |
int |
XSSFSheet.addMergedRegion(CellRangeAddress region)
Adds a merged region of cells on a sheet. |
int |
XSSFSheet.addMergedRegionUnsafe(CellRangeAddress region)
Adds a merged region of cells (hence those cells form one). |
CellRange<XSSFCell> |
XSSFSheet.setArrayFormula(java.lang.String formula,
CellRangeAddress range)
|
XSSFAutoFilter |
XSSFSheet.setAutoFilter(CellRangeAddress range)
|
void |
XSSFConditionalFormatting.setFormattingRanges(CellRangeAddress[] ranges)
|
void |
XSSFSheet.setRepeatingColumns(CellRangeAddress columnRangeRef)
|
void |
XSSFSheet.setRepeatingRows(CellRangeAddress rowRangeRef)
|
Uses of CellRangeAddress in org.apache.poi.xssf.usermodel.helpers |
---|
Methods in org.apache.poi.xssf.usermodel.helpers that return types with arguments of type CellRangeAddress | |
---|---|
java.util.List<CellRangeAddress> |
XSSFRowShifter.shiftMerged(int startRow,
int endRow,
int n)
Deprecated. POI 3.15 beta 2. Use RowShifter.shiftMergedRegions(int, int, int) instead. |
|
||||||||||
PREV NEXT | FRAMES NO FRAMES |