I'm a mildly experienced programmer ... I have an OK understanding of OOP concepts, I've been using PHP and MySQL lately. I've started to dabble with Google API Scripts. I'm trying to write a very simple program to read cell 1,1 in a google spreadsheet. The API is NOT embedded in the google spreadsheet, I need it to run outside of the SS.
Here is the code in question:
function email() {
// Opens SS by its ID
var ss = SpreadsheetApp.openById("0AgJjDgtUl5KddE5rR01NSFcxYTRnUHBCQ0stTXNMenc");
// Get the name of this SS
var name = ss.getName();
Read cell 1,1 * Line below doesn't work *
var data = Range.getCell(0, 0);
I understand that getCell() is a method within the Range class. From what I can see in the resources, it looks like Range is the top / parent / super class. Looking at the bold code above, I believe I have created a Range object and trying to call a method from that object. What am I doing wrong here??
Thanks for looking!
This question is related to
google-apps-script
You have to first obtain the Range object. Also, getCell() will not return the value of the cell but instead will return a Range object of the cell. So, use something on the lines of
function email() {
// Opens SS by its ID
var ss = SpreadsheetApp.openById("0AgJjDgtUl5KddE5rR01NSFcxYTRnUHBCQ0stTXNMenc");
// Get the name of this SS
var name = ss.getName(); // Not necessary
// Read cell 1,1 * Line below does't work *
// var data = Range.getCell(0, 0);
var sheet = ss.getSheetByName('Sheet1'); // or whatever is the name of the sheet
var range = sheet.getRange(1,1);
var data = range.getValue();
}
The hierarchy is Spreadsheet --> Sheet --> Range --> Cell.
Source: Stackoverflow.com