asposecells.api
Class Row

Represents a single row in a worksheet.

Property Getters/Setters Summary
methodgetFirstCell()
           Gets the first cell object in the row.
methodgetFirstDataCell()
           Gets the first non-blank cell in the row.
methodgetGroupLevel()
           Gets the group level of the row.
methodgetHeight()
methodsetHeight(value)
           Gets and sets the row height in unit of Points.
methodgetIndex()
           Gets the index of this row.
methodisBlank()
           Indicates whether the row contains any data
methodisHeightMatched()
methodsetHeightMatched(value)
           Indicates that row height and default font height matches
methodisHidden()
methodsetHidden(value)
           Indicates whether the row is hidden.
methodgetLastCell()
           Gets the last cell object in the row.
methodgetLastDataCell()
           Gets the last non-blank cell in the row.
methodgetStyle()
           Represents the style of this row.
methodget(column)
           Gets the cell.
 
Method Summary
methodapplyStyle(style, flag)
           Applies formats for a whole row.
methodcopySettings(source, checkStyle)
           Copy settings of row, such as style, height, visibility, ...etc.
methodequals(row)
           Checks whether this object refers to the same row with another row object.
methodequals(obj)
           Checks whether this object refers to the same row with another.
methodgetCellByIndex(index)
           Get the cell by specific index in the list.
methodgetCellOrNull(column)
           Gets the cell or null in the specific index.
methoditerator()
           Gets the cells enumerator
 

Property Getters/Setters Detail

isBlank : boolean 

boolean isBlank()
Indicates whether the row contains any data

getHeight/setHeight : float 

float getHeight() / setHeight(value)
Gets and sets the row height in unit of Points.

isHidden/setHidden : boolean 

boolean isHidden() / setHidden(value)
Indicates whether the row is hidden.

getIndex : int 

int getIndex()
Gets the index of this row.

getGroupLevel : byte 

byte getGroupLevel()
Gets the group level of the row.

isHeightMatched/setHeightMatched : boolean 

boolean isHeightMatched() / setHeightMatched(value)
Indicates that row height and default font height matches

getStyle : Style 

Style 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.

getFirstCell : Cell 

Cell getFirstCell()
Gets the first cell object in the row.

getFirstDataCell : Cell 

Cell getFirstDataCell()
Gets the first non-blank cell in the row.

getLastCell : Cell 

Cell getLastCell()
Gets the last cell object in the row.

getLastDataCell : Cell 

Cell getLastDataCell()
Gets the last non-blank cell in the row.

get : Cell 

Cell get(column)
Gets the cell.
Parameters:
column - The column index
Returns:

Method Detail

getCellByIndex

Cell getCellByIndex(index)
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.
Parameters:
index: int - The position.
Returns:
The Cell object.

iterator

Iterator iterator()
Gets the cells enumerator
Returns:
The cells enumerator

getCellOrNull

Cell getCellOrNull(column)
Gets the cell or null in the specific index.
Parameters:
column: int - The column index
Returns:
Returns the cell object if the cell exists. Or returns null if the cell object does not exist.

copySettings

 copySettings(source, checkStyle)
Copy settings of row, such as style, height, visibility, ...etc.
Parameters:
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.

applyStyle

 applyStyle(style, flag)
Applies formats for a whole row.
Parameters:
style: Style - The style object which will be applied.
flag: StyleFlag - Flags which indicates applied formatting properties.

equals

boolean equals(obj)
Checks whether this object refers to the same row with another.
Parameters:
obj: Object - another object
Returns:
true if two objects refers to the same row.

equals

boolean equals(row)
Checks whether this object refers to the same row with another row object.
Parameters:
row: Row - another row object
Returns:
true if two row objects refers to the same row.

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.