jQuery 将 HTML 表格导出到 Excel，但为文件选择一个名称
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/14125819/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Export HTML table to Excel but select a name for the file
提问by GalloPinto
I'm using this function
我正在使用这个功能
var tableToExcel = (function() {
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]; }) }
return function(table, name) {
if (!table.nodeType) table = document.getElementById(table)
var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML}
window.location.href = uri + base64(format(template, ctx))
}
})()
Here is the example:
这是示例：
http://jsfiddle.net/insin/cmewv/
http://jsfiddle.net/insin/cmewv/
In that example, they change the name of the worksheet, but is there any way to change the name of the file?
在那个例子中，他们更改了工作表的名称，但是有没有办法更改文件的名称？
采纳答案by newtron
See the answers at: Is there any way to specify a suggested filename when using data: URI?
请参阅以下位置的答案：使用 data: URI 时是否可以指定建议的文件名？
Basically, there's no way to do this with JavaScript. If the file is being downloaded with an <a>link, you can specify a filename using the downloadattribute, but this is not widely supported(right now just Chrome and BB10).
基本上，JavaScript 无法做到这一点。如果文件是通过<a>链接下载的，您可以使用该download属性指定文件名，但这并没有得到广泛支持（现在只有 Chrome 和 BB10）。
回答by Amay Kulkarni
This works for me :
这对我有用：
$scope.exportData = (function() {
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]; }) }
return function(table, name) {
if (!table.nodeType) table = document.getElementById(table)
var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML}
//window.location.href = uri + base64(format(template, ctx))
var link = document.createElement("a");
link.download = "filename.xls";
link.href = uri + base64(format(template, ctx));
link.click();
}
})()
回答by adio
works for me too. I add a prompt to take download name dynamicly
也适用于我。我添加了动态取下载名的提示
var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML}
//window.location.href = uri + base64(format(template, ctx))
var downloadName = prompt("write some explanation", "table");
var link = document.createElement("a");
link.download = downloadName + ".xls";
link.href = uri + base64(format(template, ctx));
link.click();
