com.aspose.cells

  • java.lang.Object
    • com.aspose.cells.Row
  • All Implemented Interfaces:
    java.lang.Iterable
    public class Row 
    extends java.lang.Object

Represents a single row in a worksheet.

Property Getters/Setters Summary
CellgetFirstCell()
Gets the first cell object in the row.
CellgetFirstDataCell()
Gets the first non-blank cell in the row.
bytegetGroupLevel()
Gets the group level of the row.
doublegetHeight()
void
setHeight(doublevalue)
           Gets and sets the row height in unit of Points.
intgetIndex()
Gets the index of this row.
booleanisBlank()
Indicates whether the row contains any data
booleanisHeightMatched()
void
setHeightMatched(booleanvalue)
           Indicates that row height and default font height matches
booleanisHidden()
void
setHidden(booleanvalue)
           Indicates whether the row is hidden.
CellgetLastCell()
Gets the last cell object in the row.
CellgetLastDataCell()
Gets the last non-blank cell in the row.
StylegetStyle()
Represents the style of this row.
Cellget(int column)
Gets the cell.
 
Method Summary
voidapplyStyle(Style style, StyleFlag flag)
Applies formats for a whole row.
voidcopySettings(Row source, boolean checkStyle)
Copy settings of row, such as style, height, visibility, ...etc.
booleanequals(Row row)
Checks whether this object refers to the same row with another row object.
booleanequals(java.lang.Object obj)
Checks whether this object refers to the same row with another.
CellgetCellByIndex(int index)
Get the cell by specific index in the list.
CellgetCellOrNull(int column)
Gets the cell or null in the specific index.
java.util.Iteratoriterator()
Gets the cells enumerator
 

    • Property Getters/Setters Detail

      • isBlank

        public boolean isBlank()
        
        Indicates whether the row contains any data
      • getHeight/setHeight

        public double getHeight() / public void setHeight(double value)
        
        Gets and sets the row height in unit of Points.
      • isHidden/setHidden

        public boolean isHidden() / public void setHidden(boolean value)
        
        Indicates whether the row is hidden.
      • getIndex

        public int getIndex()
        
        Gets the index of this row.
      • getGroupLevel

        public byte getGroupLevel()
        
        Gets the group level of the row.
      • isHeightMatched/setHeightMatched

        public boolean isHeightMatched() / public void setHeightMatched(boolean value)
        
        Indicates that row height and default font height matches
      • getStyle

        public 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

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

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

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

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

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

    setHeight

    public voidsetHeight(doublevalue)
    
    Gets and sets the row height in unit of Points.

    setHidden

    public voidsetHidden(booleanvalue)
    
    Indicates whether the row is hidden.

    setHeightMatched

    public voidsetHeightMatched(booleanvalue)
    
    Indicates that row height and default font height matches
    • Method Detail

      • getCellByIndex

        public Cell getCellByIndex(int 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 - The position.
        Returns:
        The Cell object.
      • iterator

        public java.util.Iterator iterator()
        Gets the cells enumerator
        Returns:
        The cells enumerator
      • getCellOrNull

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

        public void copySettings(Row source, boolean checkStyle)
        Copy settings of row, such as style, height, visibility, ...etc.
        Parameters:
        source - the source row whose settings will be copied to this one
        checkStyle - 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

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

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

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