officefileapi-devexpress-dot-spreadsheet-dot-threadedcommentcollection-dot-removeat-x28-system-dot-int32-x29.md
Removes a comment at the specified index from the collection.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
void RemoveAt(
int index
)
Sub RemoveAt(
index As Integer
)
| 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.
|
The code sample below removes all comments with the specified author:
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);
}
}
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
See Also
ThreadedCommentCollection Interface