javaScript读取页面表格中每个单元到EXCEL中

最新推荐文章于 2022-07-16 16:54:27 发布

mafanhe

最新推荐文章于 2022-07-16 16:54:27 发布

阅读量679

点赞数

分类专栏： JavaWeb

本文链接：https://blog.csdn.net/u011235518/article/details/49024257

版权

JavaWeb 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

function method2(tableid) //读取表格中每个单元到EXCEL中 
{ 
    var curTbl = document.getElementById(tableid); 
     var oXL = new ActiveXObject("Excel.Application"); 
     //创建AX对象excel 
     var oWB = oXL.Workbooks.Add(); 
     //获取workbook对象 
    var oSheet = oWB.ActiveSheet; 
    //激活当前sheet 
     var Lenr = curTbl.rows.length; 
     //取得表格行数 
     for (i = 0; i < Lenr; i++) 
     { 
         var Lenc = curTbl.rows(i).cells.length; 
         //取得每行的列数 
         for (j = 0; j < Lenc; j++) 
         { 
             oSheet.Cells(i + 1, j + 1).value = curTbl.rows(i).cells(j).innerText; 
             //赋值 
         } 
     } 
     oXL.Visible = true; 
     //设置excel可见属性 
}

2.例子

<!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',''); 
} 



function method2(tableid) //读取表格中每个单元到EXCEL中?
	{
	var curTbl = document.getElementById(tableid);
	var oXL = new ActiveXObject("Excel.Application");
	//创建AX对象excel?
	var oWB = oXL.Workbooks.Add();
	//获取workbook对象?
	var oSheet = oWB.ActiveSheet;
	//激活当前sheet?
	var Lenr = curTbl.rows.length;
	//取得表格行数?
	for (i = 0; i < Lenr; i++)
	{
	 var Lenc = curTbl.rows(i).cells.length;
	//取得每行的列数
	for (j = 0; j < Lenc; j++)
	{
	 oSheet.Cells(i + 1, j + 1).value = curTbl.rows(i).cells(j).innerText;
	 //赋值
	}
	}
	 oXL.Visible = true;?
	 //设置excel可见属性?
	}
</script> 
</HEAD> 

<BODY> 
<button οnclick="javascript:exportToExcel('testList','');">导出</button><br> 
<button οnclick="javascript:method2('testList','');">导出2</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>

mafanhe

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
javaScript读取页面表格中每个单元到EXCEL中

function method2(tableid) //读取表格中每个单元到EXCEL中 { var curTbl = document.getElementById(tableid); var oXL = new ActiveXObject("Excel.Application"); //创建AX对象excel var oWB = oXL.Work
复制链接

扫一扫

专栏目录