Uses of Class
org.apache.poi.ss.util.CellRangeAddress

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.
 



Copyright 2017 The Apache Software Foundation or its licensors, as applicable.