ThreadedCommentCollection.RemoveAt(Int32) Method

Removes a comment at the specified index from the collection.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void RemoveAt(
    int index
)

VB.NET

Sub RemoveAt(
    index As Integer
)

Parameters

Name	Type	Description
index	Int32	A zero-based index of the comment to be removed. It should be non-negative and less than the number of elements in the collection.

Example

The code sample below removes all comments with the specified author:

C#

var workbook = new Workbook();
workbook.LoadDocument(@"C:\Docs\Comments.xlsx");
Worksheet worksheet = workbook.Worksheets[0];
var comments = worksheet.ThreadedComments.Where(comment => comment.Author.Name == "Nancy Davolio");
if (comments!=null)
{
    foreach (var comment in comments)
    {
        worksheet.ThreadedComments.Remove(comment);
    }
}

VB.NET

Dim workbook As New Workbook()
workbook.LoadDocument("C:\Docs\Comments.xlsx")
Dim worksheet As Worksheet = workbook.Worksheets(0)
Dim comments = worksheet.ThreadedComments.Where(Function(comment) comment.Author.Name = "Nancy Davolio")
If comments IsNot Nothing Then
  For Each comment In comments
    worksheet.ThreadedComments.Remove(comment)
  Next comment
End If