复制代码 代码如下:
<script language="javascript"> <br> <!-- <br> function AutomateExcel() <br> { <br> // Start Excel and get Application object. <br> var oXL = new ActiveXObject("Excel.Application"); <br> // Get a new workbook. <br> var oWB = oXL.Workbooks.Add(); <br> var oSheet = oWB.ActiveSheet; <br> var table = document.all.data; <br> var hang = table.rows.length; <br> var lie = table.rows(0).cells.length; <br> // Add table headers going cell by cell. <br> for (i=0;i<hang;i++) <br> { <br> for (j=0;j<lie;j++) <br> { <br> //oSheet.Cells(i+1,j+1).Font.Bold = True <br> //oSheet.Cells(i+1,j+1).Font.Size = 50 <br> //oSheet.Cells(i+1,j+1).Alignment = 2<br> oSheet.Cells(i+1,j+1).value = table.rows(i).cells(j).innerText; <br> } <br> } <br> oXL.Visible = true; <br> oXL.UserControl = true; <br> } <br> //--><br> </script>
| 姓名 | 年龄 | 出生日期 | |
| 6 | 25 | 8 | |
| 1 | 2 | 4 | |
excel" onclick="AutomateExcel();" value="导出到excel" class="notPrint">
