[]
Sheets.Comments.CommentManager
• new CommentManager(sheet
)
Represents a comment manager that can manage all comments in a sheet.
Name | Type | Description |
---|---|---|
sheet |
Worksheet |
The worksheet. |
▸ add(row
, col
, text
): Comment
Adds a comment to the cell for the indicated row and column.
Name | Type | Description |
---|---|---|
row |
number |
The row index of the cell. |
col |
number |
The column index of the cell. |
text |
string |
The text of the comment. |
The comment that has been added to the cell.
▸ all(): Comment
[]
Gets all comments in the sheet.
Comment
[]
▸ clear(range
): void
Clears all of the comments in the indicated range on the sheet. When the range is not specified, it clears all the comments in the sheet.
Name | Type | Description |
---|---|---|
range |
Range |
The range that you want clear all comments from. |
void
▸ get(row
, col
): Comment
Gets the comment in the cell with the indicated row and column.
Name | Type | Description |
---|---|---|
row |
number |
The row index of the cell. |
col |
number |
The column index of the cell. |
The comment in the indicated cell.
▸ remove(row
, col
): void
Removes the comment from the cell for the indicated row and column.
Name | Type | Description |
---|---|---|
row |
number |
The row index of the cell. |
col |
number |
The column index of the cell. |
void