網上收集的代碼
<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>