Skip to content

Adding a comment

Jump to bottom
JanKallman edited this page Oct 19, 2023 · 10 revisions

You can add Comments (in later Excel versions called Notes) either via the ExcelRange class or via the Comments property on the ExcelWorksheet class.
Comments/Notes can be added using plain text or using richtext as descibed in this example below.

using(var package = new ExcelPackage(@"c:\temp\commentstest.xlsx"))
{
    var ws = package.Workbook.Worksheets.Add("comments");
    //Add Comments using the range class
    var comment = ws.Cells["A3"].AddComment("Jan Källman:\r\n", "JK");
    comment.Font