在Code.gs中使用javascript从数组值生成动态html表

function generateTable(dataArray) {
  var table = "<table>";
  
  // 生成表头
  table += "<thead><tr>";
  for (var header in dataArray[0]) {
    table += "<th>" + header + "</th>";
  }
  table += "</tr></thead>";
  
  // 生成表格内容
  table += "<tbody>";
  for (var i = 0; i < dataArray.length; i++) {
    table += "<tr>";
    for (var key in dataArray[i]) {
      table += "<td>" + dataArray[i][key] + "</td>";
    }
    table += "</tr>";
  }
  table += "</tbody>";
  
  table += "</table>";
  
  return table;
}

var data = [
  { "姓名": "张三", "年龄": 25, "性别": "男" },
  { "姓名": "李四", "年龄": 30, "性别": "女" },
  { "姓名": "王五", "年龄": 28, "性别": "男" }
];

var dynamicTable = generateTable(data);

document.getElementById("tableContainer").innerHTML = dynamicTable;