时间戳

首页 > 解决方案 > 填充一个 html 下拉框 () with data from a google sheet I have created this website with google that is hosted in my google drive https://sites.google.com/view/cryptocurrencyman/home Now, on the page Crypto Currency Charts I want a dropdown box with all

问题描述

标签： htmlgoogle-apps-script

解决方案

你确定要这么做吗？这是简单的部分。

HTML_Test：

<!DOCTYPE html>
  <html>
    <head>
    <base target="_top">
  </head>
  <body>
    <select id="mySelectList">
    </select>
    <script>
      (function () {
        google.script.run.withSuccessHandler(
          function (selectList) {
            var select = document.getElementById("mySelectList");
            for( var i=0; i<selectList.length; i++ ) {
              var option = document.createElement("option");
              option.text = selectList[i][0];
              select.add(option);
            }
          }
        ).getSelectList();
      }());
    </script>
  </body>
</html>

代码.gs

function getSelectList() {
  try {
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
    var values = sheet.getRange(1,1,sheet.getLastRow(),1).getValues();
    return values;
  }
  catch(err) {
    Logger.log(err);
  }
}

推荐阅读