87,997
社区成员




<html>
<head>
<title>将table中选择的数据导出为Execl文件 JavaScript</title>
<script language="javascript">...
function SaveToExcel()
...{
if(typeof(objExecl)!="object")
...{
document.body.insertAdjacentHTML("afterBegin","<OBJECT style='display:none' classid='clsid:0002E510-0000-0000-C000-000000000046' id='objExecl' VIEWASTEXT></OBJECT>");
}
objExecl.DataType = "HTMLData";
objExecl.HTMLData =getData();
try
...{
objExecl.ActiveSheet.Export("OutToExcel.xls",0);
alert("保存成功");
}
catch(e)
...{
alert(e.description);
}
}
function getData()
...{
var data="<table ><tr><td>选择</td><td>title</td><td>id</td> </tr>";
for(var i=0;i<document.Form1.elements.length;i++)
...{
if(Form1.elements[i].checked==true && Form1.elements[i].type.toString()=="checkbox")
...{
data.value+=Form1.elements["data"+i].innerHTML;
}
}
return data;
}
</script>
</head>
<body>
<form id="Form1">
<table id="tblData">
<tr>
<td>选择</td>
<td>title</td>
<td>id</td>
</tr>
<tr id="data1">
<td><input type="checkbox" vallue="1"></td>
<td>aaaa</td>
<td>1</td>
</tr>
<tr id="data2">
<td><input type="checkbox" value="2"></td>
<td>aaaa</td>
<td>1</td>
</tr>
</table>
<input type="button" value="导出为EXCEL" onclick="SaveToExcel();"></form>
</body>
</html>