function ExportExcel(btn, TabId, strCols, sTitle, sHeader, sFooter) {
btn.style.cursor = "wait";
event.returnValue = false;
var tab = document.getElementById(TabId);
if (!tab) { alert("缺少表格對象"); btn.style.cursor = "hand"; return; }
// 計算欄數(處理 colspan)
var t = tab.firstChild; // tbody
var rows = t.childNodes.length;
var tds = t.childNodes[0].childNodes.length;
var cols = 0;
for (var i = 0; i < tds; i++) {
var td = t.childNodes[0].childNodes[i];
cols += parseInt(td.colSpan) > 1 ? parseInt(td.colSpan) : 1;
}
// 建立 Excel 應用程式
var oXL;
try { oXL = new ActiveXObject("Excel.Application"); }
catch(e) {
alert("請確認已安裝 Excel 並允許執行 ActiveX!\n" +
"IE 設定:工具→網際網路選項→安全性→自訂層級→" +
"「對未標記為可安全執行腳本的 ActiveX 控制項初始化並執行腳本」→啟用");
btn.style.cursor = "hand"; return;
}
oXL.Workbooks.Add();
var osheet = oXL.ActiveWorkBook.Sheets(1);
var xlrow = 1;
// 標題列
osheet.Cells(1, 1) = sTitle || "";
osheet.Range(osheet.Cells(1,1), osheet.Cells(1,cols)).Merge();
osheet.Range(osheet.Cells(1,1), osheet.Cells(1,cols)).HorizontalAlignment = 3; // xlCenter
xlrow++;
// 小標題
if (sHeader) {
osheet.Cells(2, 1) = sHeader;
osheet.Range(osheet.Cells(2,1), osheet.Cells(2,cols)).Merge();
xlrow++;
}
// 進度視窗(略,原碼極長)
// 資料寫入
var aRowSpans = new Array(cols).fill(1);
for (var i = 0; i < rows; i++) {
var row = t.childNodes[i];
var xlcol = 0;
// ... 處理 rowSpan/colSpan 邏輯(原碼截斷)
}
oXL.Visible = true; // 顯示 Excel
}
<script src="execl.js"></script>
<table id="tableNr" class="tableNr">...</table>
<input type="button" value="匯出 Excel"
onclick="ExportExcel(this,'tableNr','','報表標題')" />
colSpan/rowSpan 需額外處理// 1. SheetJS (xlsx) - 純前端產出 .xlsx
// npm install xlsx
import * as XLSX from 'xlsx';
var wb = XLSX.utils.table_to_book(document.getElementById('tableNr'));
XLSX.writeFile(wb, 'report.xlsx');
// 2. HTML5 Blob 下載 CSV
function downloadCSV(tableId, filename) {
var rows = document.querySelectorAll("#" + tableId + " tr");
var csv = [...rows].map(row =>
[...row.cells].map(cell => '"' + cell.innerText.replace(/"/g,'""') + '"').join(",")
).join("\n");
var blob = new Blob(["\ufeff" + csv], {type: "text/csv;charset=utf-8"});
var a = document.createElement("a");
a.href = URL.createObjectURL(blob);
a.download = filename || "export.csv";
a.click();
}
強烈建議: 放棄 ActiveX 方案,改用 SheetJS 或 CSV Blob 下載,支援所有現代瀏覽器、無需 Excel 安裝、安全性高。