<html >
<head>
<title>用js來實(shí)現(xiàn)導(dǎo)出數(shù)據(jù)到Excel</title>
<SCRIPT LANGUAGE="JavaScript">
function ExportExcel()
{
var oXL = new ActiveXObject("Excel.Application"); //創(chuàng)建excel應(yīng)用程序?qū)ο?br>var oWB = oXL.Workbooks.Add(); //創(chuàng)建工作簿
var oSheet = oWB.ActiveSheet; //獲取當(dāng)前活動(dòng)的工作簿
var table = document.all.data; //獲取當(dāng)前頁面中的表格
var hang = table.rows.length; //獲取表格有多少行
var lie = table.rows(0).cells.length; //獲取首行有多少列-多少標(biāo)題
for (i=0;i<hang;i++) //添加標(biāo)題到表格中
{
for (j=0;j<lie;j++)
{
oSheet.Cells(i+1,j+1).Value = table.rows(i).cells(j).innerText;//設(shè)置標(biāo)題的內(nèi)容
}
}
oXL.Visible = true; //設(shè)置Excel的屬性
oXL.UserControl = true;
}
</SCRIPT>
</head>
<body>
<input type="button" name="btnExcel" onclick="ExportExcel()" value="導(dǎo)出到excel" class="notPrint">
<table id="data" width="200" border="1">
<tr>
<td>姓名</td>
<td>年齡</td>
</tr>
<tr>
<td>無敵</td>
<td>22</td>
</tr>
<tr>
<td>技巧</td>
<td>33</td>
</tr>
<tr>
<td>無敵技巧</td>
<td>23</td>
</tr>
</table>
</body>
</html>
