一童漩。導(dǎo)出Excel有兩種：
1.
function ExportExcel(tableid){//讀取表格中每個單元到EXCEL中
try
{
var curTbl = document.getElementById(tableid);
var oXL = new ActiveXObject("Excel.Application"); //創(chuàng)建AX對象excel
var oWB = oXL.Workbooks.Add(); //獲取workbook對象
var oSheet = oWB.ActiveSheet; //激活當(dāng)前sheet
var Lenr = curTbl.rows.length; //取得表格行數(shù)
for (i = 0; i < Lenr; i++){
var Lenc = curTbl.rows(i).cells.length; //取得每行的列數(shù)
for (j = 0; j < Lenc; j++){
oSheet.Cells(i + 1, j + 1).value = curTbl.rows(i).cells(j).innerText; //賦值
}
}
oXL.Visible = true; //設(shè)置excel可見屬性
}
catch(e)
{
alert(e.message);
}
}
2：
function dataToExcel(tableid) {//整個表格拷貝到EXCEL中
var curTbl = document.getElementById(tableid);
var oXL;
try {
oXL = GetObject("", "Excel.Application");
}
catch (E) {
try {
oXL = new ActiveXObject("Excel.Application");
}
catch (E2) {
//alert("Please confirm:\n1.Microsoft Excel has been installed.\n2.Internet Options=>Security=>Setting \"Enable unsafe ActiveX\"");
alert("請確認(rèn):\n1.機(jī)器上Excel已經(jīng)安裝.\n2.Internet 選項=>安全=>Internet \"對沒有標(biāo)記為安全的ActiveX控件進(jìn)行初始化和腳本運(yùn)行喝滞，設(shè)定為啟用\"");
return;
}
}
//創(chuàng)建AX對象excel
var oWB = oXL.Workbooks.Add();
//獲取workbook對象
var oSheet = oWB.ActiveSheet;
//激活當(dāng)前sheet
var sel = document.body.createTextRange();
sel.moveToElementText(curTbl);
//把表格中的內(nèi)容移到TextRange中
sel.select();
//全選TextRange中內(nèi)容
sel.execCommand("Copy");
//復(fù)制TextRange中內(nèi)容
oSheet.Paste();
//粘貼到活動的EXCEL中
oXL.Visible = true;
//設(shè)置excel可見屬性
}
二炼幔。導(dǎo)出Txt
function dataToTxt(tableid)
{
var file_name=window.prompt("請指定輸出文件名稱(.txt)","C://ExportTxt.txt");
if(file_name!=null)
{
var curTbl = document.getElementById(tableid);
file_name=file_name.split("http://").join("http:////");
alert(file_name);
var FSO=new ActiveXObject("Scripting.FileSystemObject");
var f1 = FSO.CreateTextFile(file_name, true);
var Lenr = curTbl.rows.length; //取得表格行數(shù)
for (i = 0; i < Lenr; i++){
var Lenc = curTbl.rows(i).cells.length; //取得每行的列數(shù)
for (j = 0; j < Lenc; j++){
f1.write(curTbl.rows(i).cells(j).innerText+" "); //賦值
}
f1.write("\r\n");
}
f1.close();
}
}
