//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; // Create threaded comment for range C3. ICommentThreaded commentThreadedE3 = worksheet.Range["E3"].AddCommentThreaded("Range E3's threaded comment", "Even"); // Add a reply for commentThreadedC3. worksheet.Range["F3"].AddCommentThreaded("Range F3's threaded comment", "Charles"); // Delete a single cell threaded comment. commentThreadedE3.Delete(); // Clear a range of cells threaded comment. worksheet.Range["F3:G4"].ClearCommentsThreaded(); // Save to an excel file workbook.Save("ClearCommentThreaded.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) ' Create threaded comment for range C3. Dim commentThreadedE3 = worksheet.Range("E3").AddCommentThreaded("Range E3's threaded comment", "Even") ' Add a reply for commentThreadedC3. worksheet.Range("F3").AddCommentThreaded("Range F3's threaded comment", "Charles") ' Delete a single cell threaded comment. commentThreadedE3.Delete() ' Clear a range of cells threaded comment. worksheet.Range("F3:G4").ClearCommentsThreaded() ' save to an excel file workbook.Save("ClearCommentThreaded.xlsx")