<
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 >
< 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 >