代码描述:JavaScript表格数据 导入Excel表。JavaScript将表格数据导入Excel表源码实例下载
表格可以用来组织数据,但是Excel的功能更为强大,在办公中几乎是比不可少的,所以有时候可能需要将表格中的数据导入到Excel表中,这样更加容易管理和保存,下面就是一段实现此功能的代码实例。 代码如下:
<!DOCTYPE html> <html> <head> <meta charset=" utf-8"> <meta name="author" content="http://www.51qianduan.com/" /> <title>51前端</title> <script type="text/javascript"> var idTmr=""; function killExcelProcess(appExcel_){ appExcel_.Quit(); appExcel_ = null; idTmr = window.setInterval("Cleanup();",1); } function exportToExcel(tableid,notitleandsearch){ try { clipboardData.setData('Text',''); var appExcel = new ActiveXObject("Excel.Application"); killExcelProcess(appExcel); appExcel.workbooks.add; if (notitleandsearch==null||notitleandsearch==false){ var elTable = document.getElementById('div_title'); var oRangeRef = document.body.createTextRange(); oRangeRef.moveToElementText(elTable); oRangeRef.execCommand( "Copy" ); appExcel.ActiveSheet.Cells(1,3).select(); appExcel.ActiveSheet.Paste(); clipboardData.setData('Text',''); appExcel.ActiveSheet.Cells(2,1).select(); appExcel.ActiveSheet.Paste(); } var elTable1 = document.getElementById(tableid); var oRangeRef1 = document.body.createTextRange(); oRangeRef1.moveToElementText(elTable1); oRangeRef1.execCommand( "Copy" ); appExcel.WorkSheets(1).Activate; if (notitleandsearch==null||notitleandsearch==false){ appExcel.ActiveSheet.Cells(3,1).select(); }else{ appExcel.ActiveSheet.Cells(1,1).select(); } appExcel.WorkSheets(1).Activate; appExcel.ActiveSheet.Paste(); appExcel.Visible = true; } catch(e) { alert("请确认IE安全设置,ActiveX都启用!"); return false; } clipboardData.setData('text',''); } </script> </HEAD> <BODY> <button>导出</button> <br> <div id='div_title' ><font color='black' size='4'><strong>导出报表</strong></font></div> <table id = "testList" bordercolor="#000000" border = "1"> <tr> <td>51前端一</td> <td>51前端二</td> <td>51前端三</td> </tr> <tr> <td>51前端一</td> <td>51前端二</td> <td>51前端三</td> </tr> <tr> <td>51前端一</td> <td>51前端二</td> <td>51前端三</td> </tr> <tr> <td>51前端一</td> <td>51前端二</td> <td>51前端三</td> </tr> <tr> <td>51前端一</td> <td>51前端二</td> <td>51前端三</td> </tr> <tr> <td>51前端一</td> <td>51前端二</td> <td>51前端三</td> </tr> <tr> <td colspan="2">总计:</td> <td>10</td> </tr> </table> </body> </html>
请绑定手机号,在继续操作
注意:只有绑定手机以后,才可使用网站全部功能