js制作导出excel数据
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><html><head><title> New Document </title><meta name="Generator" content="EditPlus"><meta name="Author" content=""><meta name="Keywords" content=""><meta name="Description" content=""></head><body><table border='1' id="viewtable"><tr> <td>1</td> <td>2</td> <td>3</td> <td>4</td> <td>5</td></tr><tr> <td>6</td> <td>7</td> <td>8</td> <td>9</td> <td>10</td></tr><tr> <td>11</td> <td>12</td> <td>13</td> <td>14</td> <td>15</td></tr><tr> <td>16</td> <td>17</td> <td>18</td> <td>19</td> <td>20</td></tr></table><form method=post action=""><input type="button" value='导出到EXCEl' ></form></body></html><script language="JavaScript"><!--function AutomateExcel(viewtable) { //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 = viewtable; 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).value = table.rows(i).cells(j).innerText; } } oXL.Visible = true; oXL.UserControl = true; }/*functionprintToExcel(){window.clipboardData.setData("Text",document.all('viewtable').outerHTML); try { varExApp=newActiveXObject( "Excel.Application"); varExWBk=ExApp.workbooks.add() ;varExWSh=ExWBk.worksheets(1) ;ExApp.DisplayAlerts=false ;ExApp.visible=true ;}catch(e) { alert( "您的电脑没有安装MicrosoftExcel软件！ ") ;returnfalse ;}ExWBk.worksheets(1).Paste;} function AutomateExcel() { var oXL = new ActiveXObject("Excel.Application"); var oWB = oXL.Workbooks.Add(); var oSheet = oWB.ActiveSheet; var table =viewtable; var hang = table.rows.length; var lie = table.rows(0).cells.length; for (i=0;i<hang;i++) { for (j=0;j<lie;j++) { oSheet.Cells(i+1,j+1).value = table.rows(i).cells(j).innerText; }} oXL.Visible = true; oXL.UserControl = true; } *///--></script>
页:
[1]