Class Comment

public class Comment

Workbook workbook = new Workbook();
CommentCollection comments = workbook.Worksheets[0].Comments;

//เพิ่มความคิดเห็นในเซลล์ A1
int commentIndex1 = comments.Add(0, 0);
Comment comment1 = comments[commentIndex1];
comment1.Note = "หมายเหตุแรก.";
comment1.Font.Name = "Times New Roman";

//เพิ่มความคิดเห็นในเซลล์ B2
comments.Add("B2");
Comment comment2 = comments["B2"];
comment2.Note = "หมายเหตุที่สอง.";

//ทำธุรกิจของคุณ

//บันทึกไฟล์ excel
workbook.Save("exmaple.xlsx");

Dim workbook as Workbook = new Workbook()
Dim comments as CommentCollection = workbook.Worksheets(0).Comments

'เพิ่มความคิดเห็นในเซลล์ A1
Dim commentIndex1 as Integer = comments.Add(0, 0)
Dim comment1 as Comment = comments(commentIndex1)
comment1.Note = "หมายเหตุแรก."
comment1.Font.Name = "Times New Roman"

'เพิ่มความคิดเห็นในเซลล์ B2
comments.Add("B2")
Dim comment2 As Comment = comments("B2")
comment2.Note = "หมายเหตุที่สอง."

public string Author { get; set; }

comment1.Author = "Carl.Yang";

public bool AutoSize { get; set; }

if(!comment1.AutoSize)
{
    //ขนาดของความคิดเห็นจะแตกต่างตามเนื้อหา
    comment1.AutoSize = true;
}

public int Column { get; }

int column = comment1.Column;

public CommentShape CommentShape { get; }

CommentShape shape = comment1.CommentShape;
int w = shape.Width;
int h = shape.Height;

public Font Font { get; }

Aspose.Cells.Font font = comment1.Font;
font.Size = 12;

public int Height { get; set; }

comment1.Height = 10;

public double HeightCM { get; set; }

comment1.HeightCM = 1.0;

public double HeightInch { get; set; }

comment1.HeightInch = 1.0;

public string HtmlNote { get; set; }

comment1.HtmlNote = "<Font Style='FONT-FAMILY: Calibri;FONT-SIZE: 11pt;COLOR: #0000ff;TEXT-ALIGN: left;'>นี่คือ <b>การทดสอบ</b>.</Font>";

public bool IsThreadedComment { get; }

if(comment1.IsThreadedComment)
{
    //ความคิดเห็นนี้เป็นความคิดเห็นแบบเธรด
}

public bool IsVisible { get; set; }

if(comment1.IsVisible)
{
    //ความคิดเห็นมองเห็นได้
}

public string Note { get; set; }

comment1.Note = "หมายเหตุแรก.";

public int Row { get; }

int row = comment1.Row;

public TextAlignmentType TextHorizontalAlignment { get; set; }

if (comment1.TextHorizontalAlignment ==  TextAlignmentType.Fill)
{
    comment1.TextHorizontalAlignment = TextAlignmentType.Center;
}

public TextOrientationType TextOrientationType { get; set; }

if(comment1.TextOrientationType == TextOrientationType.NoRotation)
{
    comment1.TextOrientationType = TextOrientationType.TopToBottom;
}

public TextAlignmentType TextVerticalAlignment { get; set; }

if (comment1.TextVerticalAlignment ==  TextAlignmentType.Fill)
{
    comment1.TextVerticalAlignment = TextAlignmentType.Center;
}

public ThreadedCommentCollection ThreadedComments { get; }

ThreadedCommentCollection threadedComments = comment1.ThreadedComments;
for (int i = 0; i < threadedComments.Count; ++i)
{
    ThreadedComment tc = threadedComments[i];
    string note = tc.Notes;
}

public int Width { get; set; }

comment1.Width = 10;

public double WidthCM { get; set; }

comment1.WidthCM = 1.0;

public double WidthInch { get; set; }

comment1.WidthInch = 1.0;

public FontSetting Characters(int startIndex, int length)

Aspose.Cells.FontSetting fontSetting = comment1.Characters(0, 4);

public void FormatCharacters(int startIndex, int length, Font font, StyleFlag flag)

public FontSetting[] GetRichFormattings()

FontSetting[] list = comment1.GetRichFormattings();