[置顶] Jsp中的table多表头导出excel文件

首先引入两份JS:copyhtmltoexcel.js以及 tableToExcel.js

copyhtmltoexcel.js

//elTalbeOut 这个为导出内容的外层表格，主要是设置border之类的样式，elDiv则是整个导出的html部分

function onhtmlToExcel(elTableOut,elDiv){

	try{

		//设置导出前的数据，为导出后返回格式而设置

		var elDivStrBak = elDiv.innerHTML;

		//设置table的border=1，这样到excel中就有表格线 ps:感谢双面提醒

		elTableOut.border=1;

		//过滤elDiv内容

		var elDivStr = elDiv.innerHTML;

		elDivStr = replaceHtml(elDivStr,"<A",">");

		elDivStr = replaceHtml(elDivStr,"</A",">");

		elDiv.innerHTML=elDivStr;	
		var oRangeRef = document.body.createTextRange();

		oRangeRef.moveToElementText( elDiv );

		oRangeRef.execCommand("Copy");
		//返回格式变换以前的内容

		elDiv.innerHTML = elDivStrBak;

		//内容数据可能很大，所以赋空

		elDivStrBak = "";

		elDivStr = "";
		var oXL = new ActiveXObject("Excel.Application")

		var oWB = oXL.Workbooks.Add ;

		var oSheet = oWB.ActiveSheet ;

		oSheet.Paste();

		oSheet.Cells.NumberFormatLocal = "@";

		oSheet.Columns("D:D").Select

		oXL.Selection.ColumnWidth = 20

		oXL.Visible = true;

		oSheet = null;

		oWB = null;

		appExcel = null;

	}catch(e){

		alert(e.description)

	}

}
function replaceHtml(replacedStr,repStr,endStr){

  var replacedStrF = "";

  var replacedStrB = "";

  var repStrIndex = replacedStr.indexOf(repStr);

  while(repStrIndex != -1){

      replacedStrF = replacedStr.substring(0,repStrIndex);

      replacedStrB = replacedStr.substring(repStrIndex,replacedStr.length);

      replacedStrB = replacedStrB.substring(replacedStrB.indexOf(endStr)+1,replacedStrB.length);

      replacedStr = replacedStrF + replacedStrB;

      repStrIndex = replacedStr.indexOf(repStr);

  }

  return replacedStr;

}

在JSP页面中写JS方法//生成Excel
  function onTableToExcel(){
   var elTableOut = document.getElementById("elTableOut");
   var elDiv = document.getElementById("elDiv");
   onhtmlToExcel(elTableOut,elDiv);
  }

注意事项：使用JS导出excel需要设置IE的active。注意最佳的是IE8浏览器。至于在java后台实现excel还没去研究，希望各位大神指教。