JavaScript将页面表格导出为Excel

最新推荐文章于 2021-05-17 17:12:55 发布

农茶

最新推荐文章于 2021-05-17 17:12:55 发布

阅读量646

点赞数

分类专栏： JavaScript 文章标签： javascript

本文链接：https://blog.csdn.net/wbsoso/article/details/17588045

版权

JavaScript 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

<!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 οnclick="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

收藏

觉得还不错? 一键收藏
0
评论
JavaScript将页面表格导出为Excel

导出Excel var idTmr = ""; function killExcelProcess(appExcel_){ appExcel_.Quit(); appExcel_ = null; idTmr = window.setInterval("Cleanup();",1); } //导出到excel，参数tableid为JSP页面
复制链接

扫一扫