JSFiddle - React, Tailwind, and code Playground
by Shang-De You
HTML
<html xmlns=”http://www.w3.org/1999/xhtml”>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″/>
<title>WEB頁面匯出為EXCEL文件的方法</title>
</head>
<body>
<table id=”tableExcel” width=”100%” border=”1″ cellspacing=”0″ cellpadding=”0″>
<tr>
<td colspan=”5″ align=”center”>WEB頁面匯出為EXCEL文件的方法</td>
</tr>
<tr>
<td>列標題1</td>
<td>列標題2</td>
<td>列標題3</td>
<td>列標題4</td>
<td>列標題5</td>
</tr>
<tr>
<td>aaa</td>
<td>bbb</td>
<td>ccc</td>
<td>ddd</td>
<td>eee</td>
</tr>
<tr>
<td>AAA</td>
<td>BBB</td>
<td>CCC</td>
<td>DDD</td>
<td>EEE</td>
</tr>
<tr>
<td>FFF</td>
<td>GGG</td>
<td>HHH</td>
<td>III</td>
<td>JJJ</td>
</tr>
</table>
<input type=”button” onclick=”javascript:method1(‘tableExcel’);” value=”第一種方法匯入到EXCEL”>
<input type=”button” onclick=”javascript:method2(‘tableExcel’);” value=”第二種方法匯入到EXCEL”>
<input type=”button” onclick=”javascript:getXlsFromTbl(‘tableExcel’,null);” value=”第三種方法匯入到EXCEL”>
<SCRIPT LANGUAGE=”javascript”>
function method1(tableid) {//整個表格拷貝到EXCEL中
var curTbl = document.getElementByIdx_x_x(tableid);
var oXL = new ActiveXObject(“Excel.Application”);
//建立AX物件excel
var oWB = oXL.Workbooks.Add();
//獲取workbook物件
var oSheet = oWB.ActiveSheet;
//啟用當前sheet
var sel = document.body.createTextRange();
sel.moveToElementText(curTbl);
//把表格中的內容移到TextRange中
sel.select();
//全選TextRange中內容
sel.execCommand(“Copy”);
//複製TextRange中內容
oSheet.Paste();
//貼上到活動的EXCEL中
oXL.Visible = true;
//設定excel可見屬性
}
function method2(tableid) //讀取表格中每個單元到EXCEL中
{
var curTbl = document.getElementByIdx_x_x(tableid);
var oXL = new ActiveXObject(“Excel.Application”);
//建立AX物件excel
var oWB = oXL.Workbooks.Add();
//獲取workbook物件
var oSheet = oWB.ActiveSheet;
//啟用當前sheet
var Lenr = curTbl.rows.length;
//取得表格行數
for (i = 0; i < Lenr; i )
{
var Lenc = curTbl.rows(i).cells.length;
//取得每行的列數
for (j = 0; j < Lenc; j )
{
oSheet.Cells(i 1, j 1).value = curTbl.rows(i).cells(j).innerText;
//賦值
}
}
oXL.Visible = true;
//設定excel可見屬性
}
function getXlsFromTbl(inTblId, inWindow) {
try {
var allStr =...