使用Jquery插件将HTML表格和表单数据导出到Excel

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="jquery.plugin.js"></script>

<table id="myTable">
  <thead>
    <tr>
      <th>Name</th>
      <th>Email</th>
      <th>Phone</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>John Doe</td>
      <td>john@example.com</td>
      <td>1234567890</td>
    </tr>
    <tr>
      <td>Jane Smith</td>
      <td>jane@example.com</td>
      <td>0987654321</td>
    </tr>
  </tbody>
</table>

<form id="myForm">
  <label for="name">Name:</label>
  <input type="text" id="name" name="name" value="John Doe"><br>
  <label for="email">Email:</label>
  <input type="email" id="email" name="email" value="john@example.com"><br>
  <label for="phone">Phone:</label>
  <input type="tel" id="phone" name="phone" value="1234567890"><br>
</form>

<button id="exportBtn">Export to Excel</button>

$(document).ready(function() {
  // 导出表格数据
  $('#exportBtn').click(function() {
    $('#myTable').table2excel({
      filename: 'table_data',
      sheetName: 'Sheet1'
    });
  });

  // 导出表单数据
  $('#exportBtn').click(function() {
    $('#myForm').form2excel({
      filename: 'form_data',
      sheetName: 'Sheet1'
    });
  });
});