这是写好的例子可以测试一下就明白了,有需要的朋友可以参考一下
Javascript 是一种由 Netscape 的 LiveScript 发展而来的原型化继承的基于对象的动态类型的区分大小写的客户端脚本语言,主要目的是为了解决服务器端语言,比如 Perl,遗留的速度问题,为客户提供更流畅的浏览效果。
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <title>
- new document
- </title>
- <meta name="generator" content="editplus" />
- <meta name="author" content="" />
- <meta name="keywords" content="" />
- <meta name="description" content="" />
- <SCRIPT LANGUAGE="javascript">
- < !--
- function AutomateExcel() { // Start Excel and get Application object.
- var oXL = new ActiveXObject("Excel.Application"); // Get a new workbook.
- var oWB = oXL.Workbooks.Add();
- var oSheet = oWB.ActiveSheet;
- var table = document.all.data;
- var hang = table.rows.length;
- var lie = table.rows(0).cells.length; // Add table headers going cell by cell.
- for (i = 0; i < hang; i++) {
- for (j = 0; j < lie; j++) { //oSheet.Cells(i+1,j+1).Font.Bold = True
- //oSheet.Cells(i+1,j+1).Font.Size = 50
- //oSheet.Cells(i+1,j+1).Alignment = 2
- oSheet.Cells(i + 1, j + 1).value = table.rows(i).cells(j).innerText;
- }
- } oXL.Visible = true; oXL.UserControl = true;
- } //-->
- </SCRIPT>
- </head>
- <body>
- <table border="1" width="100%" id="data">
- <tr>
- <td>
- 姓名
- </td>
- <td colspan="2">
- 年龄
- </td>
- <td>
- 出生日期
- </td>
- </tr>
- <tr>
- <td>
- 6
- </td>
- <td>
- 25
- </td>
- <td colspan="2">
- 8
- </td>
- </tr>
- <tr>
- <td height="22">
- 1
- </td>
- <td height="22">
- 2
- </td>
- <td colspan="2" height="22">
- 4
- </td>
- </tr>
- </table>
- <input type="button" name="out_excel" onclick="AutomateExcel();" value="导出到excel"
- class="notPrint">
- </body>
- </html>
来源: