js简单实现下载EXCEL

最新推荐文章于 2024-03-11 17:17:17 发布

iteye_279

最新推荐文章于 2024-03-11 17:17:17 发布

阅读量380

点赞数

文章标签： Excel HTML

本文链接：https://blog.csdn.net/iteye_279/article/details/81821089

版权

<html>
<body>
<table id='tableExcel'>
<tr>
<td>aa
</td>
<td>bb
</td>
<td>cc
</td>
</tr>
<tr>
<td>aa
</td>
<td>bb
</td>
<td>cc
</td>
</tr>
<tr>
<td>aa
</td>
<td>bb
</td>
<td>cc
</td>
</tr>
</table>
<input name="btmExcel" class="button1" type="button" id="btmExcel" value="导出当前页" οnclick="toExcel();">
<input name="btmExcel" class="button1" type="button" id="btmExcel" value="导出当前页" οnclick="saveCode('tableExcel');">

</body>
</html>
<script language='javascript'>
function saveCode(obj){

var winname = window.open('', '_blank', 'top=10000');
var strHTML = document.all.tableExcel.innerHTML;

winname.document.open('text/html', 'replace');
winname.document.writeln(strHTML);
winname.document.execCommand('saveas','',' 假植情况报表.xls');
winname.close();
}

function toExcel(){
window.clipboardData.setData("Text",document.all('tableExcel').outerHTML);
try
{
var ExApp = new ActiveXObject("Excel.Application");
var ExWBk = ExApp.workbooks.add();
var ExWSh = ExWBk.worksheets(1);
ExApp.DisplayAlerts = false;
ExApp.visible = true;
}
catch(e)
{
alert(e.message);
return false;
}
ExWBk.worksheets(1).Paste;
}
</script>

iteye_279

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
js简单实现下载EXCEL

aabbccaabbccaabbcc function saveCode(obj){ var winname = window.open('', '_blank', 'top=10000'); var strHTML = ...
复制链接

扫一扫