aspose.cells

Property Getters/Setters Detail

• isBlank : boolean 

  function isBlank()
  

  Indicates whether the row contains any data

• isCollapsed/setCollapsed : boolean 

  function isCollapsed() / function setCollapsed(value)
  

  whether the row is collapsed

• getHeight/setHeight : Number 

  function getHeight() / function setHeight(value)
  

  Gets and sets the row height in unit of Points.

• isHidden/setHidden : boolean 

  function isHidden() / function setHidden(value)
  

  Indicates whether the row is hidden.

• getIndex : Number 

  function getIndex()
  

  Gets the index of this row.

• getGroupLevel : byte 

  function getGroupLevel()
  

  Gets the group level of the row.

• isHeightMatched/setHeightMatched : boolean 

  function isHeightMatched() / function setHeightMatched(value)
  

  Indicates that row height and default font height matches.

• getStyle : Style 

  function 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 

  function getFirstCell()
  

  Gets the first cell object in the row.

• getFirstDataCell : Cell 

  function getFirstDataCell()
  

  Gets the first non-blank cell in the row.

• getLastCell : Cell 

  function getLastCell()
  

  Gets the last cell object in the row.

• getLastDataCell : Cell 

  function getLastDataCell()
  

  Gets the last non-blank cell in the row.

• get : Cell 

  function get(column)
  

  Gets the cell.

  Parameters:

  column - The column index

  Returns:

Method Detail

• getCellByIndex

  function 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: Number - The position.

  Returns:

  The Cell object.

• iterator

  function iterator()

  Gets the cells enumerator

  Returns:

  The cells enumerator

• getCellOrNull

  function getCellOrNull(column)

  Gets the cell or null in the specific index.

  Parameters:

  column: Number - The column index

  Returns:

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

• copySettings

  function 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

  function 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

  function 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

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