& ltHTML & gt
& ltHEAD & gt
& ltTITLE & gt新文檔& lt/TITLE & gt;
& ltMETA NAME = " Generator " CONTENT = " EditPlus " & gt;
& ltMETA NAME = " Author " CONTENT = " " & gt;
& ltMETA NAME = " Keywords " CONTENT = " " & gt;
& ltMETA NAME = " Description " CONTENT = " " & gt;
& lt/HEAD & gt;
& ltBODY & gt
& lth 1 & gt;通過javascript,表格是什麽樣式,導出的excel是什麽,用ActiveX保證IE允許運行未標記的ActiveX
& ltinput type = " button " onclick = " Export excel()" value = " Export to excel " & gt;
& lttable id="table1 " >
& lttr & gt
& lttd & gtasdfas<。td & gt
& lttd & gtasdfas2 & lttd & gt
& lttd & gtasdfas3 & lttd & gt
& lt/tr & gt;
& lttr & gt
& lttd & gtasdfas<。td & gt
& lttd & gtasdfas2 & lttd & gt
& lttd & gtasdfas3 & lttd & gt
& lt/tr & gt;
& lt/table & gt;
& lt/BODY & gt;
& lt腳本& gt
函數ExportExcel() {
window . clipboard data . setdata(" Text ",document . getelementbyid(' table 1 ')。outer html);
嘗試{
var ex app = new ActiveX object(" Excel。應用”)
var ExWBk = ExApp.workbooks.add()
var ex wsh = ex wbk . worksheets(1)
ExApp。顯示警報=假
ExApp.visible = true
} catch(e) {
Alert("您的計算機上沒有安裝Microsoft Excel軟件!")
返回false
}
ExWBk.worksheets(1)。粘貼;
}
& lt/script & gt;
& lt/HTML & gt;