Google Apps Scripts - Accessing Cell Notes and Com

问题:

Hello everybody and thank you for taking the time to check out my question. I am a 9th grade teacher making a customized grade sheet and just finished a GUI that lets parents see their kid's grades. However, on the actual gradesheet I use cell notes (previously, comments) to store information specific to a grade (i.e. Jimmy was missing part b of the assignment). I would like to be able to access the data within those notes.

I would like to consider myself a good researcher but have not been able to find a single reference to apps scripts interacting with cell comments or notes. Any help on this would be greatly appreciated.

Also, should there be no infrastructure to support this, I am very open to other ideas on how to store related information while still keeping my interface more more or less constant.

my interface: https://docs.google.com/spreadsheet/ccc?key=0AuptsBCDJBomdGtjc0xBcDctZ3FENmlsdlpRQmdkNkE

parent interface is a simple form that takes a student id number and returns a flex table with grade headers and only that students information.

回答1:

You can use the Range.getComments() method to gain access to the comments on cells.

https://developers.google.com/apps-script/class_range#getComment

---

Update (original author: Simon):

Google Docs Comments were relaunched on Sept 5th 2012 as discussion-style comments. All the old Comments were renamed to be Notes. See this notice. The curious thing is that Google has kept the old simple Notes, but not provided any documentation for it.