- 论坛徽章:
- 0
|
<script language="javascript">
function outExcel(){
var oXL = new ActiveXObject("Excel.Application");
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
var table = document.all.test;
var hang = table.rows.length;
var lie = table.rows(0).cells.length;
for (i=0;i<hang;i++){
for (j=0;j<lie;j++){
oSheet.Cells(i+1,j+1).value = table.rows(i).cells(j).innerText;
}
}
oXL.Visible = true;
oXL.UserControl = true;
}
</script>
我的页面table:<table width="100%" border="0" bgcolor="#000000" cellpadding="0" cellspacing="1" id="test">
当我点击链接“导入到excel”应该弹出一excel表格,其中显示我jsp页面的表格中的数据,为什么不能实现呢?
<tr>
<td height="19"><input type="button" name="button1" value="导入到excel" onClick="outExcel();"></td>
</tr> |
|