//function doGet(e) {
var template = HtmlService.createTemplateFromFile("index");
var output = template.evaluate();
output.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL);
return output;
}
function getSheetData() {
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var sheet1 = spreadsheet.getSheetByName('From Responses 1');
var sheet2 = spreadsheet.getSheetByName('Sheet1');
var data = [];
if (sheet1) {
var dataRange1 = sheet1.getDataRange();
var values1 = dataRange1.getValues();
data = data.concat(values1); // Add data from 'From Responses 1'
}
if (sheet2) {
var dataRange2 = sheet2.getDataRange();
var values2 = dataRange2.getValues();
data = data.concat(values2); // Add data from 'Sheet1'
}
return data;
}
Comments
Post a Comment