html表格在javascript中excel表格

var workbook = XLSX.readFile('example.xlsx');
var sheet_name_list = workbook.SheetNames;
var data = XLSX.utils.sheet_to_json(workbook.Sheets[sheet_name_list[0]]);

var table = document.createElement('table');
var thead = document.createElement('thead');
var tbody = document.createElement('tbody');

// 创建表头
var tr = document.createElement('tr');
for (var key in data[0]) {
  var th = document.createElement('th');
  th.textContent = key;
  tr.appendChild(th);
}
thead.appendChild(tr);

// 创建表格数据
for (var i = 0; i< data.length; i++) {
  var tr = document.createElement('tr');
  for (var key in data[i]) {
    var td = document.createElement('td');
    td.textContent = data[i][key];
    tr.appendChild(td);
  }
  tbody.appendChild(tr);
}

// 将表头和表格数据添加到表格中
table.appendChild(thead);
table.appendChild(tbody);

// 将表格添加到页面中
document.body.appendChild(table);

var worksheet = XLSX.utils.json_to_sheet(data);
var workbook = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');
XLSX.writeFile(workbook, 'example.xlsx');