网页点击按钮,下载Excel表格到本地
function getExcelUrl(table, elem, tableName) {
var html = '<html><head><meta charset=\'utf-8\' /></head><body>' + table + '</body></html>';
var blob = new Blob([html], {
type: 'application/vnd.ms-excel'
});
$(elem).attr('href', URL.createObjectURL(blob)).attr('download', tableName);
}
下载/表格:
<a class="download-report"><i class="fa fa-download"></i>下载报表</a>
<div id="content"></div>
<script>
var tableHtml = '. . . . . . ';
$("#content").html(tableHtml);
</script>
在这里插入代码片
调用方式:
getExcelUrl(tableHtml,'.download-report','报表.xls');