-
-
Notifications
You must be signed in to change notification settings - Fork 36
getCellComments
Julian Halliwell edited this page Sep 20, 2021
·
2 revisions
Returns comment properties from the entire active sheet as an array of structs.
getCellComments( workbook )
-
workbookspreadsheet object
Author-
Column(number) Comment-
Row(number)
Chainable? Yes but ends the chain.
spreadsheet = New spreadsheet();
workbook = spreadsheet.new();
data = [ [ "a", "b" ], [ "c", "d" ] ];
spreadsheet.addRows( workbook, data );
theComment = {
author="cfsimplicity"
,comment="This is the comment in row 1 column 1"
};
spreadsheet.setCellComment( workbook,theComment, 1, 1 );
theComment = {
author="cfsimplicity"
,comment="This is the comment in row 2 column 2"
};
spreadsheet.setCellComment( workbook, theComment, 2, 2 );
allComments = spreadsheet.getCellComments( workbook );//array of structs