如何将 HTML 表格导出为 .xlsx 文件 [英] How to export an HTML table as a .xlsx file
问题描述
我有一个关于将 HTML 表 导出为 xlsx 文件的问题.我做了一些工作，现在我可以将它导出为 xls，但我需要将它导出为 xlsx.
I have a question about exporting an HTML table as an xlsx file. I did some work and now I can export it as an xls, but I need to export it as an xlsx.
这是我的 jsFiddle: https://jsfiddle.net/272406sv/1/
这是我的 HTML:
<table id="toExcel" class="uitable">
<thead>
<tr>
<th>Kampanya Basligi</th>
<th>Kampanya Türü</th>
<th>Kampanya Baslangiç</th>
<th>Kampanya Bitis</th>
<th style="text-align: center">Aksiyonlar</th>
</tr>
</thead>
<tbody>
<tr ng-repeat="Item in campaign.campaignList">
<td> Item.CampaignTitle </td>
<td> Item.CampaignHotelType </td>
<td> Item.CampaignHotelCheckInDate) </td>
<td>Item.CampaignHotelCheckOutDate</td>
<td style="text-align: center">
<button> Some Action </button>
</td>
</tr>
</tbody>
</table>
<button onclick="exceller()">EXCEL</button>
这是我的 JavaScript 代码:
<script>
function exceller() {
var uri = 'data:application/vnd.ms-excel;base64,',
template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>',
base64 = function(s) {
return window.btoa(unescape(encodeURIComponent(s)))
},
format = function(s, c) {
return s.replace(/{(w+)}/g, function(m, p) {
return c[p];
})
}
var toExcel = document.getElementById("toExcel").innerHTML;
var ctx = {
worksheet: name || '',
table: toExcel
};
var link = document.createElement("a");
link.download = "export.xls";
link.href = uri + base64(format(template, ctx))
link.click();
}
</script>
推荐答案
如果不返回到服务器，您将无法将其导出为 XLSX.XLSX 文件是压缩在一起的 XML 文件的集合.这意味着您确实需要创建多个文件.这在客户端的 JS 中是不可能的.
You won't be able to export it as XLSX without going back to the server. A XLSX file is a collection of XML files, zipped together. This means you do need to create multiple files. This is impossible to do with JS, client-side.
相反，您应该创建一个函数，从您的 HTML 表中检索数据并将其发送到您的服务器.然后，服务器可以为您创建 XLSX 文件(有很多可用的库！)并将其发送回客户端进行下载.
Instead, you should create a function retrieving the data from your HTML table and send that to you server. The server can then create the XLSX file for you (there are a bunch of libs available for that!) and send it back to the client for download.
如果您希望拥有一个庞大的数据集，则服务器上的 XLSX 创建应该作为一个异步过程完成，在该过程中您会在完成时通知用户(而不是让用户等待创建文件).
If you expect to have a huge dataset, the XLSX creation on the server should be done as an async process, where you notify the user when it's done (instead of having the user waiting for the file to be created).
告诉我们您在服务器上使用哪种语言，我们将能够向您推荐一些好的库.
Let us know which language you use on your server, and we'll be able to recommend you some good libraries.
这篇关于如何将 HTML 表格导出为 .xlsx 文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
