Uses of Class
org.apache.poi.ss.util.CellRangeAddress
Packages that use CellRangeAddress
Package
Description
Provides low level API structures for reading, writing, modifying XLS files.
Record package contains class representations for XLS binary strutures.
record aggregates are not real "records" but collections of records that act as a single record.
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
util package contains tools needed for writing HSSF files that are not necesarily "real"
HSSF concepts.
This package contains common internal POI code for manipulating formulas.
-
Uses of CellRangeAddress in org.apache.poi.hssf.converter
Methods in org.apache.poi.hssf.converter that return CellRangeAddressModifier and TypeMethodDescriptionstatic CellRangeAddress[][]ExcelToHtmlUtils.buildMergedRangesMap(Sheet sheet) Creates a map (i.e.static CellRangeAddressAbstractExcelUtils.getMergedRange(CellRangeAddress[][] mergedRanges, int rowNumber, int columnNumber) Methods in org.apache.poi.hssf.converter with parameters of type CellRangeAddressModifier and TypeMethodDescriptionstatic CellRangeAddressAbstractExcelUtils.getMergedRange(CellRangeAddress[][] mergedRanges, int rowNumber, int columnNumber) protected intExcelToFoConverter.processRow(HSSFWorkbook workbook, CellRangeAddress[][] mergedRanges, HSSFRow row, Element tableRowElement) protected intExcelToHtmlConverter.processRow(CellRangeAddress[][] mergedRanges, HSSFRow row, Element tableRowElement) -
Uses of CellRangeAddress in org.apache.poi.hssf.model
Methods in org.apache.poi.hssf.model that return CellRangeAddress -
Uses of CellRangeAddress in org.apache.poi.hssf.record
Methods in org.apache.poi.hssf.record that return CellRangeAddressModifier and TypeMethodDescriptionMergeCellsRecord.getAreaAt(int index) CFHeader12Record.getAssociatedRange()CFRule12Record.getAssociatedRange()CFHeaderBase.getCellRanges()FeatRecord.getCellRefs()CFHeaderBase.getEnclosingCellRange()Methods in org.apache.poi.hssf.record with parameters of type CellRangeAddressModifier and TypeMethodDescriptionvoidCFHeaderBase.setCellRanges(CellRangeAddress[] cellRanges) Set cell ranges list to a single cell range and modify the enclosing cell range accordingly.voidFeatRecord.setCellRefs(CellRangeAddress[] cellRefs) voidCFHeaderBase.setEnclosingCellRange(CellRangeAddress cr) Constructors in org.apache.poi.hssf.record with parameters of type CellRangeAddressModifierConstructorDescriptionCFHeader12Record(CellRangeAddress[] regions, int nRules) protectedCFHeaderBase(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 CellRangeAddressModifier and TypeMethodDescriptionMergedCellsTable.get(int index) FormulaRecordAggregate.getArrayFormulaRange()FormulaRecordAggregate.removeArrayFormula(int rowIndex, int columnIndex) Removes an array formulaMethods in org.apache.poi.hssf.record.aggregates with parameters of type CellRangeAddressModifier and TypeMethodDescriptionvoidFormulaRecordAggregate.setArrayFormula(CellRangeAddress r, Ptg[] ptgs) Constructors in org.apache.poi.hssf.record.aggregates with parameters of type CellRangeAddress -
Uses of CellRangeAddress in org.apache.poi.hssf.record.common
Methods in org.apache.poi.hssf.record.common that return CellRangeAddressModifier and TypeMethodDescriptionFtrHeader.getAssociatedRange()FutureRecord.getAssociatedRange()Methods in org.apache.poi.hssf.record.common with parameters of type CellRangeAddressModifier and TypeMethodDescriptionvoidFtrHeader.setAssociatedRange(CellRangeAddress associatedRange) -
Uses of CellRangeAddress in org.apache.poi.hssf.usermodel
Methods in org.apache.poi.hssf.usermodel that return CellRangeAddressModifier and TypeMethodDescriptionHSSFCell.getArrayFormulaRange()HSSFConditionalFormatting.getFormattingRanges()HSSFSheet.getMergedRegion(int index) HSSFSheet.getRepeatingColumns()HSSFSheet.getRepeatingRows()Methods in org.apache.poi.hssf.usermodel that return types with arguments of type CellRangeAddressMethods in org.apache.poi.hssf.usermodel with parameters of type CellRangeAddressModifier and TypeMethodDescriptionintHSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, HSSFConditionalFormattingRule rule1) intHSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, HSSFConditionalFormattingRule[] cfRules) Allows to add a new Conditional Formatting set to the sheet.intHSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, HSSFConditionalFormattingRule rule1, HSSFConditionalFormattingRule rule2) intHSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1) intHSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule[] cfRules) intHSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1, ConditionalFormattingRule rule2) intHSSFSheet.addMergedRegion(CellRangeAddress region) Adds a merged region of cells on a sheet.intHSSFSheet.addMergedRegionUnsafe(CellRangeAddress region) Adds a merged region of cells (hence those cells form one).HSSFSheet.setArrayFormula(String formula, CellRangeAddress range) HSSFSheet.setAutoFilter(CellRangeAddress range) voidHSSFConditionalFormatting.setFormattingRanges(CellRangeAddress[] ranges) voidHSSFSheet.setRepeatingColumns(CellRangeAddress columnRangeRef) voidHSSFSheet.setRepeatingRows(CellRangeAddress rowRangeRef) -
Uses of CellRangeAddress in org.apache.poi.hssf.util
Methods in org.apache.poi.hssf.util with parameters of type CellRangeAddressModifier and TypeMethodDescriptionstatic voidHSSFRegionUtil.setBorderBottom(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the borderBottom attribute of the HSSFRegionUtil objectstatic voidHSSFRegionUtil.setBorderLeft(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the left border for a region of cells by manipulating the cell style of the individual cells on the leftstatic voidHSSFRegionUtil.setBorderRight(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the borderRight attribute of the HSSFRegionUtil objectstatic voidHSSFRegionUtil.setBorderTop(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the borderBottom attribute of the HSSFRegionUtil objectstatic voidHSSFRegionUtil.setBottomBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the bottomBorderColor attribute of the HSSFRegionUtil objectstatic voidHSSFRegionUtil.setLeftBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the leftBorderColor attribute of the HSSFRegionUtil objectstatic voidHSSFRegionUtil.setRightBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the rightBorderColor attribute of the HSSFRegionUtil objectstatic voidHSSFRegionUtil.setTopBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.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 CellRangeAddressModifier and TypeMethodDescriptionEvaluationCell.getArrayFormulaRange()EvaluationConditionalFormatRule.getRegions()Constructors in org.apache.poi.ss.formula with parameters of type CellRangeAddressModifierConstructorDescriptionEvaluationConditionalFormatRule(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 CellRangeAddressModifier and TypeMethodDescriptionCell.getArrayFormulaRange()Only valid for array formula cellsConditionalFormatting.getFormattingRanges()Sheet.getMergedRegion(int index) Returns the merged region at the specified indexSheet.getRepeatingColumns()Gets the repeating columns used when printing the sheet, as found in File->PageSetup->Sheet.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 CellRangeAddressMethods in org.apache.poi.ss.usermodel with parameters of type CellRangeAddressModifier and TypeMethodDescriptionintSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule) Add a new Conditional Formatting to the sheet.intSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule[] cfRules) Add a new Conditional Formatting set to the sheet.intSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1, ConditionalFormattingRule rule2) Add a new Conditional Formatting consisting of two rules.intSheet.addMergedRegion(CellRangeAddress region) Adds a merged region of cells (hence those cells form one)intSheet.addMergedRegionUnsafe(CellRangeAddress region) Adds a merged region of cells (hence those cells form one).voidRangeCopier.copyRange(CellRangeAddress tilePatternRange, CellRangeAddress tileDestRange) Uses input pattern to tile destination region, overwriting existing content.Sheet.setArrayFormula(String formula, CellRangeAddress range) Sets array formula to specified region for result.Sheet.setAutoFilter(CellRangeAddress range) Enable filtering for a range of cellsvoidConditionalFormatting.setFormattingRanges(CellRangeAddress[] ranges) Sets the cell ranges the rule conditional formatting must be applied to.voidSheet.setRepeatingColumns(CellRangeAddress columnRangeRef) Sets the repeating columns used when printing the sheet, as found in File->PageSetup->Sheet.voidSheet.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 CellRangeAddressModifier and TypeMethodDescriptionstatic ChartDataSource<Number>DataSources.fromNumericCellRange(Sheet sheet, CellRangeAddress cellRangeAddress) Deprecated.static ChartDataSource<String>DataSources.fromStringCellRange(Sheet sheet, CellRangeAddress cellRangeAddress) Deprecated. -
Uses of CellRangeAddress in org.apache.poi.ss.usermodel.helpers
Methods in org.apache.poi.ss.usermodel.helpers that return CellRangeAddressModifier and TypeMethodDescriptionstatic CellRangeAddressBaseRowColShifter.shiftRange(FormulaShifter formulaShifter, CellRangeAddress cra, int currentExternSheetIx) Methods in org.apache.poi.ss.usermodel.helpers that return types with arguments of type CellRangeAddressModifier and TypeMethodDescriptionabstract List<CellRangeAddress>BaseRowColShifter.shiftMergedRegions(int start, int end, int n) Shifts, grows, or shrinks the merged regions due to a row shift (RowShifter) or column shift (ColumnShifter).ColumnShifter.shiftMergedRegions(int startColumn, int endColumn, int n) Shifts, grows, or shrinks the merged regions due to a column shift.RowShifter.shiftMergedRegions(int startRow, int endRow, int n) Shifts, grows, or shrinks the merged regions due to a row shift.Methods in org.apache.poi.ss.usermodel.helpers with parameters of type CellRangeAddressModifier and TypeMethodDescriptionstatic CellRangeAddressBaseRowColShifter.shiftRange(FormulaShifter formulaShifter, CellRangeAddress cra, int currentExternSheetIx) -
Uses of CellRangeAddress in org.apache.poi.ss.util
Fields in org.apache.poi.ss.util with type parameters of type CellRangeAddressModifier and TypeFieldDescriptionprotected final List<CellRangeAddress>CellRangeAddressList._listList of CellRangeAddresses.Methods in org.apache.poi.ss.util that return CellRangeAddressModifier and TypeMethodDescriptionCellRangeAddress.copy()static CellRangeAddressCellRangeUtil.createEnclosingCellRange(CellRangeAddress crA, CellRangeAddress crB) Create an enclosing CellRange for the two cell ranges.CellRangeAddressList.getCellRangeAddress(int index) 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 rangeCellRangeAddressList.remove(int rangeIndex) static CellRangeAddressCreates a CellRangeAddress from a cell range reference string.Methods in org.apache.poi.ss.util with parameters of type CellRangeAddressModifier and TypeMethodDescriptionvoidCellRangeAddressList.addCellRangeAddress(CellRangeAddress cra) static booleanCellRangeUtil.contains(CellRangeAddress crA, CellRangeAddress crB) Check if cell range A contains cell range B (B <= A) TODO: move this intoCellRangeAddressBasestatic CellRangeAddressCellRangeUtil.createEnclosingCellRange(CellRangeAddress crA, CellRangeAddress crB) Create an enclosing CellRange for the two cell ranges.voidPropertyTemplate.drawBorderColors(CellRangeAddress range, short color, BorderExtent extent) Sets the color for a group of cell borders for a cell range.voidPropertyTemplate.drawBorders(CellRangeAddress range, BorderStyle borderType, short color, BorderExtent extent) Draws a group of cell borders for a cell range.voidPropertyTemplate.drawBorders(CellRangeAddress range, BorderStyle borderType, BorderExtent extent) Draws a group of cell borders for a cell range.static booleanCellRangeUtil.hasExactSharedBorder(CellRangeAddress crA, CellRangeAddress crB) Check if the two cell ranges have a shared border.static intCellRangeUtil.intersect(CellRangeAddress crA, CellRangeAddress crB) Get the type of intersection between two cell rangesstatic 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 rangestatic voidRegionUtil.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 bottomstatic voidRegionUtil.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 leftstatic voidRegionUtil.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 rightstatic voidRegionUtil.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 topstatic voidRegionUtil.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 bottomstatic voidRegionUtil.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 leftstatic voidRegionUtil.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 rightstatic voidRegionUtil.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 -
Uses of CellRangeAddress in org.apache.poi.xddf.usermodel.chart
Methods in org.apache.poi.xddf.usermodel.chart with parameters of type CellRangeAddressModifier and TypeMethodDescriptionXDDFChart.formatRange(CellRangeAddress range) static XDDFNumericalDataSource<Double>XDDFDataSourcesFactory.fromNumericCellRange(XSSFSheet sheet, CellRangeAddress cellRangeAddress) static XDDFCategoryDataSourceXDDFDataSourcesFactory.fromStringCellRange(XSSFSheet sheet, CellRangeAddress cellRangeAddress) -
Uses of CellRangeAddress in org.apache.poi.xssf.streaming
Methods in org.apache.poi.xssf.streaming that return CellRangeAddressModifier and TypeMethodDescriptionSXSSFCell.getArrayFormulaRange()Only valid for array formula cellsSXSSFSheet.getMergedRegion(int index) Returns the merged region at the specified index.SXSSFSheet.getRepeatingColumns()SXSSFSheet.getRepeatingRows()Methods in org.apache.poi.xssf.streaming that return types with arguments of type CellRangeAddressModifier and TypeMethodDescriptionSXSSFSheet.getMergedRegions()Returns the list of merged regions.Methods in org.apache.poi.xssf.streaming with parameters of type CellRangeAddressModifier and TypeMethodDescriptionintSXSSFSheet.addMergedRegion(CellRangeAddress region) Adds a merged region of cells (hence those cells form one)intSXSSFSheet.addMergedRegionUnsafe(CellRangeAddress region) Adds a merged region of cells (hence those cells form one)SXSSFSheet.setArrayFormula(String formula, CellRangeAddress range) Sets array formula to specified region for result.SXSSFSheet.setAutoFilter(CellRangeAddress range) Enable filtering for a range of cellsvoidSXSSFSheet.setRepeatingColumns(CellRangeAddress columnRangeRef) voidSXSSFSheet.setRepeatingRows(CellRangeAddress rowRangeRef) -
Uses of CellRangeAddress in org.apache.poi.xssf.usermodel
Methods in org.apache.poi.xssf.usermodel that return CellRangeAddressModifier and TypeMethodDescriptionXSSFCell.getArrayFormulaRange()XSSFConditionalFormatting.getFormattingRanges()XSSFSheet.getMergedRegion(int index) Returns the merged region at the specified index.XSSFSheet.getRepeatingColumns()XSSFSheet.getRepeatingRows()Methods in org.apache.poi.xssf.usermodel that return types with arguments of type CellRangeAddressModifier and TypeMethodDescriptionXSSFSheet.getIgnoredErrors()Returns the errors currently being ignored and the ranges where they are ignored.XSSFSheet.getMergedRegions()Returns the list of merged regions.Methods in org.apache.poi.xssf.usermodel with parameters of type CellRangeAddressModifier and TypeMethodDescriptionintXSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1) intXSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule[] cfRules) intXSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1, ConditionalFormattingRule rule2) voidXSSFSheet.addIgnoredErrors(CellRangeAddress region, IgnoredErrorType... ignoredErrorTypes) Ignore errors across a range of cells.intXSSFSheet.addMergedRegion(CellRangeAddress region) Adds a merged region of cells on a sheet.intXSSFSheet.addMergedRegionUnsafe(CellRangeAddress region) Adds a merged region of cells (hence those cells form one).XSSFSheet.setArrayFormula(String formula, CellRangeAddress range) XSSFSheet.setAutoFilter(CellRangeAddress range) voidXSSFConditionalFormatting.setFormattingRanges(CellRangeAddress[] ranges) voidXSSFSheet.setRepeatingColumns(CellRangeAddress columnRangeRef) voidXSSFSheet.setRepeatingRows(CellRangeAddress rowRangeRef)