javascript - 从新数组创建表返回

Question

我有一个数组，但我无法显示结果。我不知道我该如何解决它。

有人知道我该如何解决吗？

function criarTabela(conteudo) {
  var tabela = document.createElement("table")
  var thead = document.createElement("thead")
  var tbody = document.createElement("tbody")
  var thd = function(i){return (i==0)?"th":"td";}
  for (var i=0;i<conteudo.length;i++) {
    var tr = document.createElement("tr")
    for(var o=0;o<conteudo[i].length;o++){
      var t = document.createElement(thd(i))
      var texto=document.createTextNode(conteudo[i][o])
      t.appendChild(texto)
      tr.appendChild(t)
    }
    (i==0)?thead.appendChild(tr):tbody.appendChild(tr)
  }
  tabela.appendChild(thead)
  tabela.appendChild(tbody)
  return tabela
}
document.getElementById("consulta").appendChild(criarTabela(conteudo))
var conteudo = new Array google.script.run.withSuccessHandler(criarTabela).Alunos()

从 Alunos() 返回

['Data do Cadastro', 'Matricula', 'E-mail', 'Curso', 'OC', 'GN', 'P1', 'P2', 'Certificado'],
    [ '30/09/2021 14:11:12', '2021.02.34870', '[e-mail]', 'Analise e Desenvolvimento de Sistemas', 3, 3, 1, 1, ''],
    [ '30/09/2021 18:52:12', '2021.02.95859', '[e-mail]', 'Marketing Digital', 0, 0, 0, 0, ''],
    [ '30/09/2021 18:58:22', '2021.02.29425', '[e-mail]', 'Relacionamento e Vendas', 0, 0, 0, 0, ''],
    [ '30/09/2021 19:18:53', '2021.02.82395', '[e-mail]', 'Marketing', 0, 0, 0, 0, ''],
    [ '04/10/2021 14:28:56', '2021.02.54954', '[e-mail]', 'Marketing Digital', 0, 0, 0, 0, ''],
    [ '04/10/2021 14:28:56', '2021.02.34870', '[e-mail]', 'Analise e Desenvolvimento de Sistemas', 3, 3, 1, 1, ''],
    [ '04/10/2021 14:28:56', '2021.02.95859', '[e-mail]', 'Marketing Digital', 0, 0, 0, 0, ''],
    [ '04/10/2021 14:28:56', '2021.02.29425', '[e-mail]', 'Relacionamento e Vendas', 0, 0, 0, 0, ''],
    [ '04/10/2021 14:28:56', '2021.02.82395', '[e-mail]', 'Marketing', 0, 0, 0, 0, ''],
    [ '04/10/2021 14:28:56', '2021.02.34870', '[e-mail]', 'Analise e Desenvolvimento de Sistemas', 3, 3, 1, 1, ''],
    [ '04/10/2021 14:28:56', '2021.02.95859', '[e-mail]', 'Marketing Digital', 0, 0, 0, 0, ''],
    [ '04/10/2021 14:28:56', '2021.02.29425', '[e-mail]', 'Relacionamento e Vendas', 0, 0, 0, 0, ''],
    [ '04/10/2021 14:28:56', '2021.02.82395', '[e-mail]', 'Marketing', 0, 0, 0, 0, ''],
    [ '04/10/2021 14:28:56', '2021.02.34870', '[e-mail]', 'Analise e Desenvolvimento de Sistemas', 3, 3, 1, 1, ''],
    [ '04/10/2021 14:28:56', '2021.02.95859', '[e-mail]', 'Marketing Digital', 0, 0, 0, 0, ''],
    [ '04/10/2021 14:28:56', '2021.02.29425', '[e-mail]', 'Relacionamento e Vendas', 0, 0, 0, 0, ''],
    [ '04/10/2021 14:28:56', '2021.02.82395', '[e-mail]', 'Marketing', 0, 0, 0, 0, '']

标签： javascript

Answer 1

我使用地图和模板文字

const arr = [['Data do Cadastro', 'Matricula', 'E-mail', 'Curso', 'OC', 'GN', 'P1', 'P2', 'Certificado'],
    [ '30/09/2021 14:11:12', '2021.02.34870', '[e-mail]', 'Analise e Desenvolvimento de Sistemas', 3, 3, 1, 1, 'Si'],
    [ '30/09/2021 18:52:12', '2021.02.95859', '[e-mail]', 'Marketing Digital', 0, 0, 0, 0, 'No'],
    [ '30/09/2021 18:58:22', '2021.02.29425', '[e-mail]', 'Relacionamento e Vendas', 0, 0, 0, 0, ''],
    [ '30/09/2021 19:18:53', '2021.02.82395', '[e-mail]', 'Marketing', 0, 0, 0, 0, ''],
    [ '04/10/2021 14:28:56', '2021.02.54954', '[e-mail]', 'Marketing Digital', 0, 0, 0, 0, ''],
    [ '04/10/2021 14:28:56', '2021.02.34870', '[e-mail]', 'Analise e Desenvolvimento de Sistemas', 3, 3, 1, 1, ''],
    [ '04/10/2021 14:28:56', '2021.02.95859', '[e-mail]', 'Marketing Digital', 0, 0, 0, 0, ''],
    [ '04/10/2021 14:28:56', '2021.02.29425', '[e-mail]', 'Relacionamento e Vendas', 0, 0, 0, 0, ''],
    [ '04/10/2021 14:28:56', '2021.02.82395', '[e-mail]', 'Marketing', 0, 0, 0, 0, ''],
    [ '04/10/2021 14:28:56', '2021.02.34870', '[e-mail]', 'Analise e Desenvolvimento de Sistemas', 3, 3, 1, 1, ''],
    [ '04/10/2021 14:28:56', '2021.02.95859', '[e-mail]', 'Marketing Digital', 0, 0, 0, 0, ''],
    [ '04/10/2021 14:28:56', '2021.02.29425', '[e-mail]', 'Relacionamento e Vendas', 0, 0, 0, 0, ''],
    [ '04/10/2021 14:28:56', '2021.02.82395', '[e-mail]', 'Marketing', 0, 0, 0, 0, ''],
    [ '04/10/2021 14:28:56', '2021.02.34870', '[e-mail]', 'Analise e Desenvolvimento de Sistemas', 3, 3, 1, 1, ''],
    [ '04/10/2021 14:28:56', '2021.02.95859', '[e-mail]', 'Marketing Digital', 0, 0, 0, 0, ''],
    [ '04/10/2021 14:28:56', '2021.02.29425', '[e-mail]', 'Relacionamento e Vendas', 0, 0, 0, 0, ''],
    [ '04/10/2021 14:28:56', '2021.02.82395', '[e-mail]', 'Marketing', 0, 0, 0, 0, '']]
    
document.getElementById("thead").innerHTML = 
`<tr>
  ${arr[0].map(item => `<th>${item}</th>`)
  .join("")}
<tr>`;
document.getElementById("tbody").innerHTML = 
  arr.slice(1).map(item => `<tr>
    ${item.map(cell => `<td>${cell}</td>`).join("")}
  </tr>`).join("");

#myTable tr:nth-child(odd) { 
      background-color:  #fff;  
 }
#myTable tr:nth-child(even) { 
      background-color:  #ccc;
 }

<table id="myTable">
<thead id="thead"></thead>
<tbody id="tbody"></tbody>
</table>