将 HTML 表格追加到现有 Excel 文件：JavaScript 教程

<script src="https://cdn.sheetjs.com/xlsx-0.18.8/package/dist/xlsx.full.min.js"></script>

<table id="test_table" class="tftable" border="1">
  <tr>
    <th>Header 1</th>
    <th>Header 2</th>
    <th>Header 3</th>
    <th>Header 4</th>
    <th>Header 5</th>
  </tr>
  <tr>
    <td>NEW Row:1 Cell:1</td>
    <td>NEW Row:1 Cell:2</td>
    <td>NEW Row:1 Cell:3</td>
    <td>NEW Row:1 Cell:4</td>
    <td>Row:1 Cell:5</td>
  </tr>
  <tr>
    <td>NEW Row:2 Cell:1</td>
    <td>NEW Row:2 Cell:2</td>
    <td>NEW Row:2 Cell:3</td>
    <td>NEW Row:2 Cell:4</td>
    <td>NEW Row:2 Cell:5</td>
  </tr>
</table>

(async () => {
  // 1. 从 HTML 表格获取数据
  var data_to_append = XLSX.utils.table_to_book(
    document.getElementById("test_table")
  );

  // 2. 获取要追加的工作表 "Sheet1"
  const newSheet = data_to_append.Sheets["Sheet1"];

  // 3. 获取原始 Excel 文件
  const url =
    "https://www.lucasroquilly.com/stack_overflow_samples/workbook.xls"; // 替换为你的 Excel 文件 URL
  const data = await (await fetch(url)).arrayBuffer();

  // 4. 从原始 Excel 文件数据创建工作簿
  const workbook = XLSX.read(data);

  // 5. 将工作表追加到工作簿，命名为 "Appended Sheet"
  XLSX.utils.book_append_sheet(workbook, newSheet, "Appended Sheet", true);

  // 6. 尝试启动文件下载
  XLSX.writeFile(workbook, "workbook.xls");
})();

.tftable {
  font-size: 12px;
  color: #333333;
  width: 100%;
  border-width: 1px;
  border-color: #729ea5;
  border-collapse: collapse;
}
.tftable th {
  font-size: 12px;
  background-color: #acc8cc;
  border-width: 1px;
  padding: 8px;
  border-style: solid;
  border-color: #729ea5;
  text-align: left;
}
.tftable tr {
  background-color: #d4e3e5;
}
.tftable td {
  font-size: 12px;
  border-width: 1px;
  padding: 8px;
  border-style: solid;
  border-color: #729ea5;
}
.tftable tr:hover {
  background-color: #ffffff;
}