\/**
\n* Adds a custom menu to the active spreadsheet, containing a single menu item
\n* for invoking the readRows() function specified above.
\n* The onOpen() function, when defined, is automatically invoked whenever the
\n* spreadsheet is opened.
\n* For more information on using the Spreadsheet API, see
\n* https:\/\/developers.google.com\/apps-script\/service_spreadsheet
\n*\/
\nfunction onOpen() {
\nvar spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
\nvar entries = [{
\nname : “Read Data”,
\nfunctionName : “readRows”
\n}];
\nspreadsheet.addMenu(“Script Center Menu”, entries);
\n};<\/p>\n
\/**
\n* Retrieves all the rows in the active spreadsheet that contain data and logs the
\n* values for each row.
\n* For more information on using the Spreadsheet API, see
\n* https:\/\/developers.google.com\/apps-script\/service_spreadsheet
\n*\/
\nfunction readRows() {
\nvar sheet = SpreadsheetApp.getActiveSheet();
\nvar rows = sheet.getDataRange();
\nvar numRows = rows.getNumRows();
\nvar values = rows.getValues();<\/p>\n
for (var i = 0; i <= numRows – 1; i++) {
\nvar row = values[i];
\nLogger.log(row);
\n}
\n};<\/p>\n","protected":false},"excerpt":{"rendered":"
\/** * Adds a custom menu to the active spreadsheet, containing a single menu item * for invoking the readRows() function specified above. * The onOpen() function, when defined, is automatically invoked whenever the * spreadsheet is opened. * For … Continue reading