CommentCollection

CommentCollection class

Encapsulates a collection of Comment objects.

public class CommentCollection : CollectionBase<Comment>

Properties

Name Description
Capacity { get; set; }
Count { get; }
Item { get; } Gets the Comment element at the specified index. (3 indexers)
Item { get; set; }

Methods

Name Description
Add(string) Adds a comment to the collection.
Add(int, int) Adds a comment to the collection.
AddThreadedComment(string, string, ThreadedCommentAuthor) Adds a threaded comment.
AddThreadedComment(int, int, string, ThreadedCommentAuthor) Adds a threaded comment.
BinarySearch(Comment)
BinarySearch(Comment, IComparer<Comment>)
BinarySearch(int, int, Comment, IComparer<Comment>)
Clear() Removes all comments; (2 methods)
Contains(Comment)
CopyTo(Comment[])
CopyTo(Comment[], int)
CopyTo(int, Comment[], int, int)
Exists(Predicate<Comment>)
Find(Predicate<Comment>)
FindAll(Predicate<Comment>)
FindIndex(Predicate<Comment>)
FindIndex(int, Predicate<Comment>)
FindIndex(int, int, Predicate<Comment>)
FindLast(Predicate<Comment>)
FindLastIndex(Predicate<Comment>)
FindLastIndex(int, Predicate<Comment>)
FindLastIndex(int, int, Predicate<Comment>)
GetEnumerator()
GetThreadedComments(string) Gets the threaded comments by cell name.
GetThreadedComments(int, int) Gets the threaded comments by row and column index.
IndexOf(Comment)
IndexOf(Comment, int)
IndexOf(Comment, int, int)
LastIndexOf(Comment)
LastIndexOf(Comment, int)
LastIndexOf(Comment, int, int)
RemoveAt(int)
RemoveAt(string) Removes the comment of the specific cell.
RemoveAt(int, int) Removes the comment of the specific cell.

Examples

[C#]

Workbook workbook = new Workbook();

CommentCollection comments = workbook.Worksheets[0].Comments;

//do your business

[Visual Basic]

Dim workbook as Workbook = new Workbook()

Dim comments as CommentCollection = workbook.Worksheets(0).Comments

See Also