Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function doGet() {
- return HtmlService.createTemplateFromFile("index.html")
- .evaluate()
- .setSandboxMode(HtmlService.SandboxMode.IFRAME);
- }
- function include(filename) {
- return HtmlService.createHtmlOutputFromFile(filename)
- .setSandboxMode(HtmlService.SandboxMode.IFRAME)
- .getContent();
- }
- function getData(){
- var sheetid = "your sheet id";
- var sheet = SpreadsheetApp.openById(sheetid).getSheets()[0];
- return sheet.getDataRange().getValues();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement