Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const sheetID = "1DalaGJ3rGHmagpUqq3aOXSKRkyZQapfw-bCNTW5lgBE";
- const sheetName = "data";
- function doGet(e) {
- var coordinates = [1, 1, 1, 3]; //just grab a few cells from the spreadsheet
- var params = JSON.stringify(e);
- var htmlOutput = HtmlService.createTemplateFromFile('index');
- htmlOutput.params = params;
- htmlOutput.update = 'updated value is: ' + e.parameter['update'];
- htmlOutput.row = 'row is: ' + e.parameter['row'];
- coordinates[0] = row;
- coordinates[2] = row;
- htmlOutput.values = read(coordinates);
- htmlOutput.url = getUrl();
- return htmlOutput.evaluate();
- }
- function read(coordinates) {
- var sheet = SpreadsheetApp.openById(sheetID);
- var data = sheet.getSheetByName(sheetName);
- var range = data.getRange(coordinates[0], coordinates[1], coordinates[2], coordinates[3]);
- var values = range.getValues();
- Logger.log(values);
- return values;
- }
- function getUrl() {
- var url = ScriptApp.getService().getUrl();
- return url;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement