Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. function doGet() {
  2. return HtmlService.createTemplateFromFile("index.html")
  3. .evaluate()
  4. .setSandboxMode(HtmlService.SandboxMode.IFRAME);
  5. }
  6.  
  7. function include(filename) {
  8. return HtmlService.createHtmlOutputFromFile(filename)
  9. .setSandboxMode(HtmlService.SandboxMode.IFRAME)
  10. .getContent();
  11. }
  12.  
  13. function getData(){
  14. var sheetid = "your sheet id";
  15. var sheet = SpreadsheetApp.openById(sheetid).getSheets()[0];
  16. return sheet.getDataRange().getValues();
  17. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement