function table2xls() //将 Table 的内容导出到 Excel
{
function String.prototype.Trim()
{
return this.replace(/(^/s*)|(/s*$)/g,"");
}
try
{
var e = document.getElementById("2Excel"); //这里你可以重得取多个表的数据
var s = ""
for (var j=0; j<e.rows.length; j++)
{
if (e.rows[0].cells[0].innerText.Trim() == "")
{
for (var i=1; i<e.rows[j].cells.length; i++)
s += e.rows[j].cells[i].innerText.Trim() +"/t";
}
else
{
for (var i=0; i<e.rows[j].cells.length; i++)
s += e.rows[j].cells[i].innerText.Trim() +"/t";
}
s += "/r/n";
}
var xlsWindow = window.open("","_blank","width=100,height=100");
xlsWindow.document.write(s);
xlsWindow.document.close();
xlsWindow.document.execCommand('Saveas',true,'%homeDrive%//Data.csv');
xlsWindow.close();
}
catch(e)
{}
}