快捷導(dǎo)航

JavaScript將頁面表格導(dǎo)出為Excel的具體實現(xiàn)

更新時間：2013年12月27日 10:44:54 作者：

如何將頁面表格導(dǎo)出為Excel，這在日常工作中很常見，下面為大家詳細(xì)的介紹下使用JavaScript是如何實現(xiàn)的

 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> 
<HTML> 
<HEAD> 
<TITLE>導(dǎo)出Excel</TITLE> 
<script type="text/javascript"> 
var idTmr = ""; 
function killExcelProcess(appExcel_){ 
appExcel_.Quit(); 
appExcel_ = null; 
idTmr = window.setInterval("Cleanup();",1); 
} 

//導(dǎo)出到excel，參數(shù)tableid為JSP頁面需要導(dǎo)出的table的id，需要更改IE的安全設(shè)置，ActiveX都打開，如果還是不能使用，再服務(wù)端運行“regsvr32 scrrun.dll” 
function exportToExcel(tableid,notitleandsearch){ 
try { 
clipboardData.setData('Text',''); 
var appExcel = new ActiveXObject("Excel.Application"); 

killExcelProcess(appExcel); 
appExcel.workbooks.add; 

//標(biāo)題 
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("請確認(rèn)IE安全設(shè)置，ActiveX都啟用！"); 
return false; 
} 
clipboardData.setData('text',''); 
} 
</script> 
</HEAD> 

<BODY> 
<button onclick="javascript:exportToExcel('testList','');">導(dǎo)出</button><br> 

<div id='div_title' > 
<font color='black' size='4'><strong>導(dǎo)出報表</strong></font> 
</div> 
<table id = "testList" bordercolor="#000000" border = "1"> 
<tr> 
<td>序列</td> 
<td>姓名</td> 
<td>數(shù)量</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> 