<script>

// 這個(gè)代碼可以大大減少IE下的當(dāng)前頁面的Excel導(dǎo)出工作量
// 如果不能正確執(zhí)行, 請(qǐng)把當(dāng)前站點(diǎn)加入可信站點(diǎn)并調(diào)低安全級(jí) 參考圖片: IE添加可信站點(diǎn).png
// 導(dǎo)出為Excel, 參數(shù)為 HTML 或者 表格代碼, 如: "A\tB", xxx.innerHTML
function printToExcel(html) {
? try{
??? var ExApp = new ActiveXObject("Excel.Application")
??? var ExWBk = ExApp.workbooks.add()
??? var ExWSh = ExWBk.worksheets(1)
??? ExApp.DisplayAlerts = false
??? ExApp.visible = true
? }catch(e){
??? alert("您所設(shè)定的安全級(jí)別太高，或者您的電腦沒有安裝Microsoft Excel軟件！")
??? return false
? }
? window.clipboardData.setData("Text", html);?
? ExWBk.worksheets(1).Paste;
? ExWBk.worksheets(1).Columns.AutoFit;
? ExWBk.worksheets(1).Rows.AutoFit;
}
?? // 將 HTML 表格導(dǎo)出為 Excel
? function?? exportToExcel(table)???
? {
????? if(confirm("確認(rèn)要導(dǎo)出嗎?")){
????? //?? Start?? Excel?? and?? get?? Application?? object.?
????? var?? oXL?? =?? new?? ActiveXObject("Excel.Application");???
????? //?? Get?? a?? new?? workbook.?
????? var?? oWB?? =?? oXL.Workbooks.Add();?
????? var?? oSheet?? =?? oWB.ActiveSheet;
????? var?? hang?? =?? table.rows.length;????
????? var?? lie?? =?? table.rows(0).cells.length;??????
????? //?? Add?? table?? headers?? going?? cell?? by?? cell.?
????? 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;??????
????? }
? }
//printToExcel("A\tB");
</script>
<!-- 以下為數(shù)據(jù)區(qū) -->
<div id="dataArea">
<font color=red>2009年豬流感統(tǒng)計(jì)表</font>
??? <table border="1"? cellpadding="0" style="border-collapse: collapse; " bordercolor="#000000">
<tbody><tr>
<td>&nbsp;<b>編號(hào)</b></td>
<td>&nbsp;<b>用戶名</b></td></tr>
<tr>
<td>&nbsp;1</td>
<td>&nbsp;金正日</td></tr>
<tr>
<td>&nbsp;2</td>
<td>&nbsp;薩達(dá)姆</td></tr>
</tbody>

</table>

</div>
<script>
if(confirm("是否導(dǎo)出表格數(shù)據(jù)為 Excel?")) {
??? printToExcel(dataArea.innerHTML);
}
</script>

?

IE下用JavaScript動(dòng)態(tài)生成excel