js 导出 word 和Excel
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<script type="text/javascript">
//导出Excel
function Exportexcel()
{
var oXL = new ActiveXObject("Excel.Application");
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
var sel=document.body.createTextRange();
sel.moveToElementText(tableID);
sel.select();
sel.execCommand("Copy");
oSheet.Paste();
oXL.Visible = true;
}
//导出Word
function AllAreaWord()
{
var oWD = new ActiveXObject("Word.Application");
var oDC = oWD.Documents.Add("",0,1);
var oRange =oDC.Range(0,1);
var sel = document.body.createTextRange();
sel.moveToElementText(tableID);
sel.select();
sel.execCommand("Copy");
oRange.Paste();
oWD.Application.Visible = true;
}
</script>
</head>
<body>
<input type="button" id="btn" value="导出Excel" onclick="Exportexcel()" />
<input type="button" value="导出word" id="btn1" onclick="AllAreaWord()"/>
<table width="200" border="1" id="tableID">
<tr>
<td>1234</td>
<td>1234</td>
<td>1234</td>
</tr>
<tr>
<td>1234</td>
<td>1234</td>
<td>1234</td>
</tr>
<tr>
<td>1324</td>
<td>1234</td>
<td>1234</td>
</tr>
</table>
</body>
</html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<script type="text/javascript">
//导出Excel
function Exportexcel()
{
var oXL = new ActiveXObject("Excel.Application");
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
var sel=document.body.createTextRange();
sel.moveToElementText(tableID);
sel.select();
sel.execCommand("Copy");
oSheet.Paste();
oXL.Visible = true;
}
//导出Word
function AllAreaWord()
{
var oWD = new ActiveXObject("Word.Application");
var oDC = oWD.Documents.Add("",0,1);
var oRange =oDC.Range(0,1);
var sel = document.body.createTextRange();
sel.moveToElementText(tableID);
sel.select();
sel.execCommand("Copy");
oRange.Paste();
oWD.Application.Visible = true;
}
</script>
</head>
<body>
<input type="button" id="btn" value="导出Excel" onclick="Exportexcel()" />
<input type="button" value="导出word" id="btn1" onclick="AllAreaWord()"/>
<table width="200" border="1" id="tableID">
<tr>
<td>1234</td>
<td>1234</td>
<td>1234</td>
</tr>
<tr>
<td>1234</td>
<td>1234</td>
<td>1234</td>
</tr>
<tr>
<td>1324</td>
<td>1234</td>
<td>1234</td>
</tr>
</table>
</body>
</html>
在导出时,可能会遇到“AutoMation server can't create object或“AutoMation 服务器创建对象失败"!错,设置下IE的安全性,将允许ActiveX就可以了。