spreadsheet ,How do I use code to insert comments

[三]

How do I use code to insert comments 

[Petar]

Hi, 三,

You can programmatically add comments to the Spreadsheet cells using the comment method. 

Here is a StackBlitz example demonstrating the usage of the mentioned method.

I hope the above example will help you achieve what you need in your application.

Regards,
Petar
Progress Telerik

[三]

Thank you very much for your answer. Based on this question, is there any way we can get the comments in the designated cell?

[Petar]

Hi, 三.

You can use the same comment method to get the value of a given cell. Here is a modified version of the previous example I sent you. In it, I've added the below lines. 

console.log(sheet.range('A1').comment());
console.log(sheet.range('B2').comment());

If you run the linked project and check the browser's console, you will see the comments of cells A1 and B2.