Salinan kode adalah sebagai berikut:
<Html>
<head>
<bahasa skrip = "javascript" type = "text/javascript">
fungsi makeExcel () {
var i, j;
mencoba {
var xls = ActivexObject baru ("Excel.Application");
}
Catch (e) {
Peringatan ("Untuk mencetak tabel ini, Anda harus menginstal perangkat lunak spreadsheet Excel, dan browser harus menggunakan" Kontrol ActiveX ", dan browser Anda harus mengizinkan pelaksanaan kontrol. Silakan klik [Bantuan] untuk memahami cara mengatur browser!");
kembali "";
}
xls.visible = true; // atur excel menjadi terlihat
var xlbook = xls.workbooks.add;
var xlsheet = xlbook.worksheets (1);
<!-Gabungkan->
xlsheet.range (xlsheet.cells (1,1), xlsheet.cells (1,7)). mergecells = true;
xlsheet.range (xlsheet.cells (1,1), xlsheet.cells (1,7)). Value = "Catatan Penerbitan Kartu";
// xlsheet.range (xlsheet.cells (1,1), xlsheet.cells (1,6)). Interior.colorIndex = 5; // Atur warna latar belakang menjadi biru
// xlsheet.range (xlsheet.cells (1,1), xlsheet.cells (1,6)). font.colorindex = 4; // atur warna font
// xlsheet.rows (1). Interior .colorIndex = 5; // Atur warna latar belakang menjadi biru. Atur baris warna latar belakang (1) .font.colorIndex = 4
<!-Atur ketinggian garis->
xlsheet.rows (1) .rowHeight = 25;
<!-Atur font ws.range (ws.cells (i0+1, j0), ws.cells (i0+1, j1)). Font.size = 13->
xlsheet.rows (1) .font.size = 14;
<!-Atur Font Atur font dari area yang dipilih xlsheet.range (xlsheet.cells (i0, j0), ws.cells (i0, j0)). Font.name = "bold"->
xlsheet.rows (1) .font.name = "boldbody";
<!-Atur lebar kolom xlsheet.columns (2) = 14;->
xlsheet.columns ("A: D"). ColumnWidth = 18;
<!-Atur karakter tampilan, bukan angka->
xlsheet.columns (2) .NumberFormatLocal = "@";
xlsheet.columns (7) .NumberFormatLocal = "@";
// Atur konten sel untuk secara otomatis membungkus rentang garis.wraptext = true;
// Atur penyelarasan horizontal dari rentang konten sel.horizontalAlignment = excel.xlhalig.xlhaligcenter; // Atur metode penumpukan vertikal dari konten sel
//range.verticalalignment=excel.xlvalign.xlvalignCenter
//range.wraptext = true; xlsheet.rows (3) .wraptext = pembungkus otomatis true
// Atur judul bilah
xlsheet.cells (2,1) .Value = "Nomor Kartu";
xlsheet.cells (2,2) .value = "kata sandi";
xlsheet.cells (2,3) .value = "Metode penagihan";
xlsheet.cells (2,4) .Value = "Nilai Jumlah Hari yang Valid";
xlsheet.cells (2,5) .value = "jumlah";
xlsheet.cells (2,6) .value = "item layanan";
xlsheet.cells (2,7) .value = "waktu penerbitan";
var otable = document.all ['fors: data'];
var rownum = otable.rows.length;
untuk (i = 2; i <= rownum; i ++) {
untuk (j = 1; j <= 7; j ++) {
// Konten kelas tabel html ditulis ke Excel
xlsheet.cells (i+1, j) .value = otable.rows (i-1) .cells (j-1) .innerhtml;
}
}
<!- xlsheet.range (xls.cells (i+4,2), xls.cells (rownum, 4)). gabungkan; ->
// xlsheet.range (xlsheet.cells (i, 4), xlsheet.cells (i-1, 6)). Borderaround, 4
// untuk (mn = 1, mn <= 6; mn ++). xlsheet.range (xlsheet.cells (1, mn), xlsheet.cells (i1, j)). Columns.autofit;
xlsheet.columns.autofit;
xlsheet.range (xlsheet.cells (1,1), xlsheet.cells (rownum+1,7)). horizontalAlignment = -4108; // center
xlsheet.range (xlsheet.cells (1,1), xlsheet.cells (1,7)). VerticalAlignment = -4108;
xlsheet.range (xlsheet.cells (2,1), xlsheet.cells (rownum+1,7)). font.size = 10;
xlsheet.range (xlsheet.cells (2,1), xlsheet.cells (rownum+1,7)). Borders (3) .Weight = 2; // atur margin kiri
xlsheet.range (xlsheet.cells (2,1), xlsheet.cells (rownum+1,7)). Borders (4) .Weight = 2; // Setel margin kanan
xlsheet.range (xlsheet.cells (2,1), xlsheet.cells (rownum+1,7)). Borders (1) .Weight = 2; // Setel margin atas
xlsheet.range (xlsheet.cells (2,1), xlsheet.cells (rownum+1,7)). Borders (2) .weight = 2; // Atur margin bawah bawah
xls.usercontrol = true; // Ini sangat penting dan tidak dapat dihilangkan, jika tidak akan ada masalah. Itu berarti bahwa Excel diserahkan kepada pengguna untuk mengontrol
xls = null;
xlbook = null;
xlsheet = null;
}
</script> <link href = "css/styles3.css" rel = "stylesheet" type = "text/css"/>
<title> ziyuanweihu </iteme>
</head>
<body>
<Form id = "fors" Method = "POST" ACTION = "/WebModule/Admin/Card/ShowCard.Faces" Enctype = "Application/X-WWW-Form-Urlencoded">
<tabel id = "fors: cellpadding =" 0 "cellPacing =" 0 ">
<tbody>
<tr>
<td> <img src = "gambar/jiao1.gif"/> </td>
<td> </td>
<td> <img src = "gambar/jiao2.gif"/> </td>
</tr>
</tbody>
</boable>
<tabel cellpadding = "0" cellPacing = "0">
<tbody>
<tr>
<td> </td>
<td> <tabel id = "fors: sort" cellpadding = "0" cellPacing = "0" style = "valign: center">
<tbody>
<tr>
<td> <input type = "tombol" name = "fors: _id7" value = "menghasilkan file excel" ontClick = "makeExcel ()" /> <input type = "kirim" name = "fors: _id8" value = "return" /> </td>
</tr>
</tbody>
</boable>
<tabel id = "fors: data" cellPadding = "0" cellPacing = "1">
<head>
<tr>
<TH scope = "col"> <span id = "fors: data: headerText1"> nomor kartu </span> </th>
<tH scope = "col"> <span id = "fors: data: headerText2"> kata sandi </span> </th>
<TH scope = "col"> <span id = "fors: data: headerText3"> Metode penagihan </span> </th>
<TH scope = "col"> <span id = "fors: data: headerText4"> hari yang valid </span> </th>
<tH scope = "col"> Jumlah </t>
<tH scope = "col"> <span id = "fors: data: headerText6"> layanan </span> </th>
<TH scope = "col"> <span id = "fors: data: headerText7"> waktu penerbitan </span> </th>
</tr>
</head>
<tbody>
<tr>
<td> H000010010 </td>
<td> 543860 </td>
<td> menghitung poin </td>
<td> </td>
<td> 2.0 </td>
<td> Proyek uji </td>
<td> 2006-06-23 10: 14: 40.843 </td>
</tr>
<tr>
<td> H000010011 </td>
<td> 683352 </td>
<td> menghitung poin </td>
<td> </td>
<td> 2.0 </td>
<td> Proyek uji </td>
<td> 2006-06-23 10: 14: 40.843 </td>
</tr>
<tr>
<td> H000010012 </td>
<td> 433215 </td>
<td> menghitung poin </td>
<td> </td>
<td> 2.0 </td>
<td> Proyek uji </td>
<td> 2006-06-23 10: 14: 40.843 </td>
</tr>
<tr>
<td> H000010013 </td>
<td> 393899 </td>
<td> menghitung poin </td>
<td> </td>
<td> 2.0 </td>
<td> Proyek uji </td>
<td> 2006-06-23 10: 14: 40.843 </td>
</tr>
<tr>
<td> H000010014 </td>
<td> 031736 </td>
<td> menghitung poin </td>
<td> </td>
<td> 2.0 </td>
<td> Proyek uji </td>
<td> 2006-06-23 10: 14: 40.843 </td>
</tr>
<tr>
<td> H000010015 </td>
<td> 188600 </td>
<td> menghitung poin </td>
<td> </td>
<td> 2.0 </td>
<td> Proyek uji </td>
<td> 2006-06-23 10: 14: 40.843 </td>
</tr>
<tr>
<td> H000010016 </td>
<td> 363407 </td>
<td> menghitung poin </td>
<td> </td>
<td> 2.0 </td>
<td> Proyek uji </td>
<td> 2006-06-23 10: 14: 40.843 </td>
</tr>
<tr>
<td> H000010017 </td>
<td> 175315 </td>
<td> menghitung poin </td>
<td> </td>
<td> 2.0 </td>
<td> Proyek uji </td>
<td> 2006-06-23 10: 14: 40.843 </td>
</tr>
<tr>
<td> H000010018 </td>
<td> 354437 </td>
<td> menghitung poin </td>
<td> </td>
<td> 2.0 </td>
<td> Proyek uji </td>
<td> 2006-06-23 10: 14: 40.843 </td>
</tr>
<tr>
<td> H000010019 </td>
<td> 234750 </td>
<td> menghitung poin </td>
<td> </td>
<td> 2.0 </td>
<td> Proyek uji </td>
<td> 2006-06-23 10: 14: 40.843 </td>
</tr>
</tbody>
</boable>
</td>
<td> </td>
</tr>
</tbody>
</boable>
<tabel id = "fors: cellpadding =" 0 "cellPacing =" 0 ">
<tbody>
<tr>
<td>
<img src = "gambar/jiao3.gif"/>
</td>
<td> </td>
<td>
<img src = "gambar/jiao4.gif"/>
</td>
</tr>
</tbody>
</boable>
<input type = "tersembunyi" name = "fors" value = "fors" /> </form>
</body>
</html>