org.apache.poi.ss.usermodel

Interface CellRange<C extends Cell>

All Superinterfaces:

java.lang.Iterable<C>

All Known Implementing Classes:

SSCellRange

public interface CellRange<C extends Cell>
extends java.lang.Iterable<C>

Represents a rectangular region of a Sheet (表示 Sheet 的矩形区域)

Method Summary

Modifier and Type	Method and Description
C	getCell(int relativeRowIndex, int relativeColumnIndex)
C[][]	getCells()
C[]	getFlattenedCells()
int	getHeight()
java.lang.String	getReferenceText()
C	getTopLeftCell()
int	getWidth()
java.util.Iterator<C>	iterator()
int	size() Gets the number of cells in this range. (获取此范围内的单元格数。)

Methods inherited from interface java.lang.Iterable

forEach, spliterator

Method Detail

getWidth

int getWidth()

getHeight

int getHeight()

size

int size()

Gets the number of cells in this range. (获取此范围内的单元格数。)

Returns:

height * width (高度宽度)

getReferenceText

java.lang.String getReferenceText()

Returns:

the text format of this range. Single cell ranges are formatted like single cell references (e.g. 'A1' instead of 'A1:A1'). (此范围的文本格式。单个单元格区域的格式类似于单个单元格引用（例如“A1”而不是“A1:A1”）。)

getTopLeftCell

C getTopLeftCell()

Returns:

the cell at relative coordinates (0,0). Never null. (相对坐标 (0,0) 处的单元格。从不为空。)

getCell

C getCell(int relativeRowIndex,
          int relativeColumnIndex)

Parameters:

relativeRowIndex - must be between 0 and height-1 (relativeRowIndex - 必须介于 0 和 height-1 之间)

relativeColumnIndex - must be between 0 and width-1 (relativeColumnIndex - 必须介于 0 和 width-1 之间)

Returns:

the cell at the specified coordinates. Never null. (指定坐标处的单元格。从不为空。)

getFlattenedCells

C[] getFlattenedCells()

Returns:

a flattened array of all the cells in this CellRange (此 CellRange 中所有单元格的扁平数组)

getCells

C[][] getCells()

Returns:

a 2-D array of all the cells in this CellRange. The first array dimension is the row index (values 0...height-1) and the second dimension is the column index (values 0...width-1) (此 CellRange 中所有单元格的二维数组。第一个数组维度是行索引（值 0...height-1），第二个维度是列索引（值 0...width-1）)

iterator

java.util.Iterator<C> iterator()

Specified by:

iterator in interface java.lang.Iterable<C extends Cell> (接口 java.lang.Iterable 中的迭代器 )

Returns:

an Iterator over all cells in this range. Iteration starts with all cells in the first row followed by all cells in the next row, etc. (此范围内所有单元格的迭代器。迭代从第一行中的所有单元格开始，然后是下一行中的所有单元格，依此类推。)