JavaScript将页面表格导出为Excel

来源：互联网发布：linux 查看当前组编辑：程序博客网时间：2024/05/19 13:24
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML> <HEAD>  <TITLE>导出Excel</TITLE>  <script type="text/javascript">    var idTmr = "";function killExcelProcess(appExcel_){   appExcel_.Quit();   appExcel_ = null;   idTmr = window.setInterval("Cleanup();",1);}        //导出到excel，参数tableid为JSP页面需要导出的table的id，需要更改IE的安全设置，ActiveX都打开，如果还是不能使用，再服务端运行“regsvr32 scrrun.dll”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 onclick="javascript:exportToExcel('testList','');">导出</button><br>        <div id='div_title' >    <font color='black' size='4'><strong>导出报表</strong></font> </div>    <table id = "testList" bordercolor="#000000" border = "1">    <tr>    <td>序列</td>    <td>姓名</td>    <td>数量</td>    </tr>    <tr>    <td>1</td>    <td>张三1</td>    <td>2</td>    </tr>    <tr>    <td>2</td>    <td>张三2</td>    <td>2</td>    </tr>    <tr>    <td>3</td>    <td>张三3</td>    <td>2</td>    </tr>    <tr>    <td>4</td>    <td>张三4</td>    <td>2</td>    </tr>    <tr>    <td>5</td>    <td>张三5</td>    <td>2</td>    </tr>    <tr>    <td colspan="2">总计：</td>    <td>10</td>    </tr>        </table> </BODY></HTML>
0 0