Methods

applyStyle(style, flag)

Applies formats for a whole row.

Parameters

Name Type Optional Description

style

Style

 

The style object which will be applied.

flag

StyleFlag

 

Flags which indicates applied formatting properties.

copySettings(source, checkStyle)

Copy settings of row, such as style, height, visibility, ...etc.

Parameters

Name Type Optional Description

source

Row

 

the source row whose settings will be copied to this one

checkStyle

boolean

 

whether check and gather style. Only takes effect and be needed when two row objects belong to different workbook and the styles of two workbooks are different.

equals(obj) → boolean

Checks whether this object refers to the same row with another.

Parameter

Name Type Optional Description

obj

Object

 

another object

Returns

boolean true if two objects refers to the same row.

equals(row) → boolean

Checks whether this object refers to the same row with another row object.

Parameter

Name Type Optional Description

row

Row

 

another row object

Returns

boolean true if two row objects refers to the same row.

get(column) → Cell

Gets the cell.

Parameter

Name Type Optional Description

column

Number

 

The column index

Returns

Cell 

getCellByIndex(index) → Cell

Get the cell by specific index in the list. NOTE: This member is now obsolete. Instead, please use Row.GetEnumerator() method to iterate all cells in this row. This property will be removed 12 months later since February 2015. Aspose apologizes for any inconvenience you may have experienced.

Parameter

Name Type Optional Description

index

Number

 

The position.

Returns

Cell The Cell object.

getCellOrNull(column) → Cell

Gets the cell or null in the specific index.

Parameter

Name Type Optional Description

column

Number

 

The column index

Returns

Cell Returns the cell object if the cell exists. Or returns null if the cell object does not exist.

getFirstCell()

Gets the first cell object in the row.

getFirstDataCell()

Gets the first non-blank cell in the row.

getGroupLevel()

Gets the group level of the row.

getHeight()

Gets and sets the row height in unit of Points.

getIndex()

Gets the index of this row.

getLastCell()

Gets the last cell object in the row.

getLastDataCell()

Gets the last non-blank cell in the row.

getStyle()

Represents the style of this row. You have to call Row.ApplyStyle() method to save your changing with the row style, otherwise it will not effect.

isBlank()

Indicates whether the row contains any data

isHeightMatched()

Indicates that row height and default font height matches.

isHidden()

Indicates whether the row is hidden.

iterator() → Iterator

Gets the cells enumerator

Returns

Iterator The cells enumerator

setHeight()

Gets and sets the row height in unit of Points.

setHeightMatched()

Indicates that row height and default font height matches.

setHidden()

Indicates whether the row is hidden.