js拿前端的:table导出
时间: 2023-06-02 11:02:22 浏览: 44
以下是使用JavaScript和HTML5导出表格的示例代码:
HTML:
```
<table id="myTable">
<thead>
<tr>
<th>Name</th>
<th>Age</th>
<th>Gender</th>
</tr>
</thead>
<tbody>
<tr>
<td>John</td>
<td>25</td>
<td>Male</td>
</tr>
<tr>
<td>Jane</td>
<td>30</td>
<td>Female</td>
</tr>
<tr>
<td>Bob</td>
<td>40</td>
<td>Male</td>
</tr>
</tbody>
</table>
<button onclick="exportTableToCSV()">Export to CSV</button>
```
JavaScript:
```
function exportTableToCSV() {
var csv = [];
var rows = document.querySelectorAll("#myTable tbody tr");
for (var i = 0; i < rows.length; i++) {
var row = [];
var cols = rows[i].querySelectorAll("td");
for (var j = 0; j < cols.length; j++) {
row.push(cols[j].innerText);
}
csv.push(row.join(","));
}
// Download CSV file
downloadCSV(csv.join("\n"));
}
function downloadCSV(csv) {
var csvFile;
var downloadLink;
csvFile = new Blob([csv], { type: "text/csv" });
downloadLink = document.createElement("a");
downloadLink.download = "myTable.csv";
downloadLink.href = window.URL.createObjectURL(csvFile);
downloadLink.style.display = "none";
document.body.appendChild(downloadLink);
downloadLink.click();
}
```
这个JavaScript函数将表格数据转换为逗号分隔的值(CSV)格式,并将其下载为文件。使用这个代码,你可以将表格数据导出到CSV文件中,然后在Excel等电子表格应用程序中打开它。