Copy kode kodenya sebagai berikut:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transisi//EN">
<HTML>
<KEPALA>
<TITLE>Ekspor Excel</TITLE>
<skrip tipe="teks/javascript">
var idTmr = "";
fungsi killExcelProcess(appExcel_){
appExcel_.Keluar();
appExcel_ = nol;
idTmr = window.setInterval("Pembersihan();",1);
}
//Ekspor ke excel. Parameter tableid adalah id tabel yang perlu diekspor pada halaman JSP. Anda perlu mengubah pengaturan keamanan IE dan membuka ActiveX. Jika masih tidak dapat digunakan, jalankan "regsvr32 scrrun. dll" di server.
fungsi eksporToExcel(tableid,notitleandsearch){
mencoba {
clipboardData.setData('Teks','');
var appExcel = new ActiveXObject("Excel.Aplikasi");
killExcelProcess(aplikasiExcel);
appExcel.workbooks.add;
//judul
if (notitleandsearch==null||notitleandsearch==false){
var elTable = dokumen.getElementById('div_title');
var oRangeRef = dokumen.body.createTextRange();
oRangeRef.moveToElementText(elTable);
oRangeRef.execCommand( "Salinan" );
appExcel.ActiveSheet.Cells(1,3).select();
appExcel.ActiveSheet.Tempel();
clipboardData.setData('Teks','');
appExcel.ActiveSheet.Cells(2,1).select();
appExcel.ActiveSheet.Tempel();
}
var elTable1 = dokumen.getElementById(tableid);
var oRangeRef1 = dokumen.body.createTextRange();
oRangeRef1.moveToElementText(elTable1);
oRangeRef1.execCommand( "Salinan" );
appExcel.WorkSheets(1).Aktifkan;
if (notitleandsearch==null||notitleandsearch==false){
appExcel.ActiveSheet.Cells(3,1).select();
}kalau tidak{
appExcel.ActiveSheet.Cells(1,1).select();
}
appExcel.WorkSheets(1).Aktifkan;
appExcel.ActiveSheet.Tempel();
appExcel.Visible = benar;
} tangkapan(e) {
alert("Harap konfirmasi pengaturan keamanan IE dan aktifkan ActiveX!");
kembali salah;
}
clipboardData.setData('teks','');
}
</skrip>
</KEPALA>
<TUBUH>
<button onclick="javascript:exportToExcel('testList','');">Ekspor</button><br>
<div id='judul_div' >
<font color='black' size='4'><strong>Ekspor laporan</strong></font>
</div>
<tabel id = "testList" bordercolor="#000000" border = "1">
<tr>
<td>Urutan</td>
<td>Nama</td>
<td>Jumlah</td>
</tr>
<tr>
<td>1</td>
<td>Zhang San 1</td>
<td>2</td>
</tr>
<tr>
<td>2</td>
<td>Zhang San 2</td>
<td>2</td>
</tr>
<tr>
<td>3</td>
<td>Zhang San 3</td>
<td>2</td>
</tr>
<tr>
<td>4</td>
<td>Zhang San 4</td>
<td>2</td>
</tr>
<tr>
<td>5</td>
<td>Zhang San 5</td>
<td>2</td>
</tr>
<tr>
<td colspan="2">Jumlah:</td>
<td>10</td>
</tr>
</tabel>
</BODI>
</HTML>