网上收集的代码
<input type =“ button” name =“ out_excel” onclick =“ automateexcel();”值=“导出到excel”>
导出到excel代码
<脚本语言=“ javascript”> <! - function automateexcel(){//启动Excel并获取应用程序对象。 var oxl = new ActiveXobject(“ excel.Application”); //获取新工作簿。 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; //添加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 = 2osheet.cells(i+1,j+1).value = table.Rows(i).cells(j).innertext; }} oxl.visible = true; oxl.usercontrol = true; } // - > </script><table ID =“ data”> <tr> <td> </td> <td colspan =“ 2”>年龄</td> <td> <td> </td> </td> </tr> </tr> <tr> <td> 6 </td> <td> <td> <td> 25 </td> 25 </td> <td colspan =“ 2”> 8 </td> </tr> <tr> <td> 1 </td> <td> 2 </td> <td> <td colspan =“ 2”> 4 </td> </td> </tr> </table>