jsp导出到excel
各位高手,我想实现吧jsp页面上的数据导出到excel上,该如何实现<下面是我jsp 页面的简单设置,一个是table,一个是div>
我想,如何才能能把table或div中的数据,完全按照jsp上的排列导出到excel里面,希望高手们能给我点思路!~~
如果有好的代码的话,希望也能发点!~~
先谢谢了!~~
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>无标题文档</title><style type="text/css"><!--#apDiv1 { position:absolute; left:12px; top:159px; width:88px; height:65px; z-index:1;}#apDiv2 { position:absolute; left:100px; top:159px; width:100px; height:22px; z-index:2;}#apDiv3 { position:absolute; left:100px; top:181px; width:100px; height:19px; z-index:3;}#apDiv4 { position:absolute; left:100px; top:200px; width:100px; height:24px; z-index:4;}div { border: 1px solid #333333;}--></style></head><body><div id="apDiv1" align="center"> <br /> 问题</div><div id="apDiv2">回答一</div><div id="apDiv3">回答二</div><div id="apDiv4">回答三</div><table width="244" border="1"> <tr> <td width="69" rowspan="4">问题题目</td> <td width="88">回答一</td> <td width="65">修改</td> </tr> <tr> <td>回答二</td> <td>修改</td> </tr> <tr> <td>回答三</td> <td>修改</td> </tr> <tr> <td>回答四</td> <td>修改</td> </tr></table><p> </p><p> </p></body></html>
function isSava(Id){
var mStr;
mStr = window.document.body.innerHTML ;
var mWindow = window;
window.document.body.innerHTML =Id.innerHTML;
document.write(window.document.body.innerHTML);
document.execCommand("saveAs","true","allPaiming.xls");
window.document.body.innerHTML = mStr;
history.back();
}
</script>
<div align="right">
<input type="button" value="导出Excel" onClick="isSava(EXCEL)" >
</div>
这个就行了,不用太麻烦
[解决办法]
这个肯定行的,我试过了
<%@ page language="java" contentType="application/vnd.ms-excel;" pageEncoding="GBK"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html> <head><style type="text/css"><!--#apDiv1 { position:absolute; left:12px; top:159px; width:88px; height:65px; z-index:1;}#apDiv2 { position:absolute; left:100px; top:159px; width:100px; height:22px; z-index:2;}#apDiv3 { position:absolute; left:100px; top:181px; width:100px; height:19px; z-index:3;}#apDiv4 { position:absolute; left:100px; top:200px; width:100px; height:24px; z-index:4;}div { border: 1px solid #333333;}--></style></head><body><div id="apDiv1" align="center"> <br /> 问题</div><div id="apDiv2">回答一</div><div id="apDiv3">回答二</div><div id="apDiv4">回答三</div><table width="244" border="1"> <tr> <td width="69" rowspan="4">问题题目</td> <td width="88">回答一</td> <td width="65">修改</td> </tr> <tr> <td>回答二</td> <td>修改</td> </tr> <tr> <td>回答三</td> <td>修改</td> </tr> <tr> <td>回答四</td> <td>修改</td> </tr></table><p> </p><p> </p></body></html>
[解决办法]
这是一个JSP 文件,
上面要设置 contentType="application/vnd.ms-excel;"
[解决办法]
xuexi
[解决办法]