aspose.cells

Class CommentCollection

Encapsulates a collection of Comment objects.

Example:

var workbook = new aspose.cells.Workbook();

var comments = workbook.getWorksheets().get(0).getComments();

Property Getters/Setters Summary
functiongetCount()
functionget(index)
Gets the Comment element at the specified index.
functionget(row, column)
Gets the Comment element at the specified row index and column index.
functionget(cellName)
Gets the Comment element at the specified cell.
 
Method Summary
functionadd(row, column)
Adds a comment to the collection.
functionadd(value)
Reserved for internal use.
functionadd(cellName)
Adds a comment to the collection.
functionclear()
Removes all comments;
functioncontains(value)
Reserved for internal use.
functionget(index)
Reserved for internal use.
functionindexOf(value)
Reserved for internal use.
functioniterator()
functionremoveAt(index)
functionremoveAt(row, column)
Removes the comment of the specific cell.
functionremoveAt(cellName)
Removes the comment of the specific cell.
 

    • Property Getters/Setters Detail

      • getCount : Number 

        function getCount()
        
      • get : Comment 

        function get(index)
        
        Gets the Comment element at the specified index.
        Parameters:
        index - The zero based index of the element.
        Returns:
        The element at the specified index.
      • get : Comment 

        function get(cellName)
        
        Gets the Comment element at the specified cell.
        Parameters:
        cellName - Cell name.
        Returns:
        The element at the specified cell.
      • get : Comment 

        function get(row, column)
        
        Gets the Comment element at the specified row index and column index.
        Parameters:
        row - Row index.
        column - Column index.
        Returns:
        The element at the specified cell.
    • Method Detail

      • add

        function add(row, column)
        Adds a comment to the collection.
        Parameters:
        row: Number - Cell row index.
        column: Number - Cell column index.
        Returns:
        Comment object index.
      • add

        function add(cellName)
        Adds a comment to the collection.
        Parameters:
        cellName: String - Cell name.
        Returns:
        Comment object index.
      • removeAt

        function removeAt(cellName)
        Removes the comment of the specific cell.
        Parameters:
        cellName: String - The name of cell which contains a comment.
      • removeAt

        function removeAt(row, column)
        Removes the comment of the specific cell.
        Parameters:
        row: Number - The row index.
        column: Number - the column index.
      • clear

        function clear()
        Removes all comments;
      • removeAt

        function removeAt(index)
      • iterator

        function iterator()
      • get

        function get(index)
        Reserved for internal use.
      • contains

        function contains(value)
        Reserved for internal use.
      • add

        function add(value)
        Reserved for internal use.
      • indexOf

        function indexOf(value)
        Reserved for internal use.