How to add Comment

using IronXL;
using System.Linq;

// Create a new workbook
WorkBook workBook = WorkBook.Create();

// Get the default worksheet from the workbook
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Get the first cell in column "A", row 1
Cell cellA1 = workSheet["A1"].First();

// Get the first cell in column "D", row 1
Cell cellD1 = workSheet["D1"].First();

// Add a comment to cell A1 with content and author. The comment is invisible by default.
// The 'AddComment' method specifies the content of the comment and the author.
cellA1.AddComment("Hello World!", "John Doe");

// Add a comment to cell D1 with no content and no author.
// The 'AddComment' method is overloaded to take a third parameter that sets the comment visibility immediately.
cellD1.AddComment(string.Empty, string.Empty, true);

// Save the workbook as an Excel file named "addComment.xlsx"
// This method persists the changes made to the spreadsheet/workbook on the disk.
workBook.SaveAs("addComment.xlsx");

Imports IronXL
Imports System.Linq

' Create a new workbook
Private workBook As WorkBook = WorkBook.Create()

' Get the default worksheet from the workbook
Private workSheet As WorkSheet = workBook.DefaultWorkSheet

' Get the first cell in column "A", row 1
Private cellA1 As Cell = workSheet("A1").First()

' Get the first cell in column "D", row 1
Private cellD1 As Cell = workSheet("D1").First()

' Add a comment to cell A1 with content and author. The comment is invisible by default.
' The 'AddComment' method specifies the content of the comment and the author.
cellA1.AddComment("Hello World!", "John Doe")

' Add a comment to cell D1 with no content and no author.
' The 'AddComment' method is overloaded to take a third parameter that sets the comment visibility immediately.
cellD1.AddComment(String.Empty, String.Empty, True)

' Save the workbook as an Excel file named "addComment.xlsx"
' This method persists the changes made to the spreadsheet/workbook on the disk.
workBook.SaveAs("addComment.xlsx")

// Make sure to include the necessary namespaces
using IronXL;
using System.Linq;

// Load the Excel workbook from the specified file
WorkBook workBook = WorkBook.Load("addComment.xlsx");

// Retrieve the default worksheet from the workbook
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Access the cell at position A1 in the worksheet
Cell cellA1 = workSheet["A1"].First();

// Check if the cell has a comment
if (cellA1.HasComment)
{
    // Retrieve the comment from the cell
    var comment = cellA1.Comment;

    // Edit the comment properties
    comment.Author = "Jane Doe"; // Set the author of the comment
    comment.Text = "Bye World"; // Set the content of the comment
    comment.IsVisible = true; // Make the comment visible

    // Save the modified workbook as a new file
    workBook.SaveAs("editComment.xlsx");
}
else
{
    // Handle the case where the cell does not have a comment
    // This could be an error message or logging, depending on the application's needs
    Console.WriteLine("No comment found in cell A1.");
}

' Make sure to include the necessary namespaces
Imports IronXL
Imports System.Linq

' Load the Excel workbook from the specified file
Private workBook As WorkBook = WorkBook.Load("addComment.xlsx")

' Retrieve the default worksheet from the workbook
Private workSheet As WorkSheet = workBook.DefaultWorkSheet

' Access the cell at position A1 in the worksheet
Private cellA1 As Cell = workSheet("A1").First()

' Check if the cell has a comment
If cellA1.HasComment Then
	' Retrieve the comment from the cell
	Dim comment = cellA1.Comment

	' Edit the comment properties
	comment.Author = "Jane Doe" ' Set the author of the comment
	comment.Text = "Bye World" ' Set the content of the comment
	comment.IsVisible = True ' Make the comment visible

	' Save the modified workbook as a new file
	workBook.SaveAs("editComment.xlsx")
Else
	' Handle the case where the cell does not have a comment
	' This could be an error message or logging, depending on the application's needs
	Console.WriteLine("No comment found in cell A1.")
End If

using IronXL;
using System.Linq;

// Load the existing Excel workbook
WorkBook workBook = WorkBook.Load("addComment.xlsx");

// Select the default worksheet from the workbook
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Access the specific cell "A1" from the worksheet
Cell cellA1 = workSheet["A1"].First();

// Check if the cell has a comment, then remove it
if (cellA1.HasComment)
{
    cellA1.RemoveComment();
}

// Save the changes to a new Excel file
workBook.SaveAs("removeComment.xlsx");

Imports IronXL
Imports System.Linq

' Load the existing Excel workbook
Private workBook As WorkBook = WorkBook.Load("addComment.xlsx")

' Select the default worksheet from the workbook
Private workSheet As WorkSheet = workBook.DefaultWorkSheet

' Access the specific cell "A1" from the worksheet
Private cellA1 As Cell = workSheet("A1").First()

' Check if the cell has a comment, then remove it
If cellA1.HasComment Then
	cellA1.RemoveComment()
End If

' Save the changes to a new Excel file
workBook.SaveAs("removeComment.xlsx")