Table of Contents

Class CommentsCollection

Namespace
Spire.Xls.Collections
Assembly
Spire.XLS.dll
public class CommentsCollection : XlsCommentsCollection, IList<XlsComment>, ICollection<XlsComment>, IEnumerable<XlsComment>, IExcelApplication, ICloneParent, IComments, IEnumerable
Inheritance
CommentsCollection
Implements
Inherited Members

Properties

this[int]

Gets a comment object.

public ExcelComment this[int index] { get; }

Parameters

index int

Property Value

ExcelComment

this[int, int]

Gets a comment object.

public ExcelComment this[int Row, int Column] { get; }

Parameters

Row int
Column int

Property Value

ExcelComment

this[string]

public ExcelComment this[string name] { get; }

Parameters

name string

Property Value

ExcelComment

Methods

AddComment(CellRange)

Adds comment to the specified range.

public ExcelComment AddComment(CellRange range)

Parameters

range CellRange

Range that adds comment.

Returns

ExcelComment

Created comment object..

AddComment(int, int)

Adds comment to the specified row and column.

public ExcelComment AddComment(int rowIndex, int columnIndex)

Parameters

rowIndex int

Row index..

columnIndex int

Column index.

Returns

ExcelComment

Created comment object.

Remove(ExcelComment)

Removes comment object from the collection.

public void Remove(ExcelComment comment)

Parameters

comment ExcelComment

Comment to remove.