首頁 > 開發者 > JavaScript
上面是將整個表格式資料copy到Excel，這個例子，是一個一個儲存格的方法copy到Excel
<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><script type="text/javascript">function exportExcel02(){var tab = document.getElementById("tab");//取得表格對象// 建立AX對象excelvar ax = new ActiveXObject("Excel.Application");// 擷取workbook對象var wb = ax.Workbooks.Add();// 啟用當前sheetvar sheet = wb.ActiveSheet;// 去得表格中行，是個數組var rowsArr = tab.rows;// 擷取得表格的行數var rowLen = rowsArr.length;for(var i=0;i<rowLen;i++){// 取得每一行的列var colsArr = rowsArr[i].cells;// 去得一行中的列數var colLen = colsArr.length;for(var j=0;j<colLen;j++){// 一個儲存格var cell = colsArr[j];// 賦值sheet.Cells(i+1,j+1).value=cell.innerText;}}// 設定excel可見屬性ax.Visible = true; }</script><title>JavaScript 匯出table資料到Excel的第二種方法：讀取表格中每個單元到EXCEL中</title></head><body><table id="tab" width="90%" border="1" align="center" cellpadding="0" cellspacing="0"><thead><tr><th>姓名</th><th>性別</th><th>出生日期</th><th>Email</th><th>專業</th></tr></thead><tbody><tr><td>張三</td><td>男</td><td>1988-08-09</td><td>zhangsan@163.com</td><td>軟體工程</td></tr><tr><td>李四</td><td>男</td><td>1985-04-23</td><td>lisi@163.com</td><td>土木工程</td></tr><tr><td>小紅</td><td>女</td><td>1990-11-19</td><td>xiaohong@163.com</td><td>電子商務</td></tr><tr><td>小軍</td><td>男</td><td>1987-04-22</td><td>xiaojun@163.com</td><td>市場營銷</td></tr></tbody></table><br /><br /><center><input type="button" value="匯出到Excel" id="sp" onClick="exportExcel02();" /></center></body></html>
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
