JSP直接输出EXCLE:<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.lang.*"%>
<%
try{
response.setContentType("Application/msexcel");
response.setHeader("Content-Disposition", "attachment;filename=trainlist.xls");
StringBuffer cont=new StringBuffer("");
%>
<HTML>
<HEAD>
<META http-equiv="Content-Style-Type" content="text/css">
</HEAD>
<BODY>
<br/><br/><br/>
<%
cont.append("<html><head><META content=\'text/html; charset=gb2312\' http-equiv=Content-Type></head><body>\r\n");
cont.append("<h1>这是什么</h1>");
cont.append("<table width='100%' border='1'>\r\n");
cont.append("<tr>\r\n");
cont.append("<td height='19'>可以</td>\r\n");
cont.append("<td height='19'>我靠,这也行</td>\r\n");
cont.append("<td height='19'>哈哈,我是天才</td>\r\n");
cont.append("<td height='19'>呵呵</td>\r\n");
cont.append("</tr>\r\n");
cont.append("<tr>\r\n");
cont.append("<td>"+"xxxxxxxxxxxxxxxxxxxxxxxx" +" </td>\r\n");
cont.append("<td>"+"xxxxxxxxxxxxxxxxxxxxxxxx" +" </td>\r\n");
cont.append("<td>"+"xxxxxxxxxxxxxxxxxxxxxxxx" +" </td>\r\n");
cont.append("<td>"+"xxxxxxxxxxxxxxxxxxxxxxxx" +" </td>\r\n");
cont.append("</tr>\r\n");
cont.append("<tr>\r\n");
cont.append("<td>"+"xxxxxxxxxxxxxxxxxxxxxxxx" +" </td>\r\n");
cont.append("<td>"+"xxxxxxxxxxxxxxxxxxxxxxxx" +" </td>\r\n");
cont.append("<td>"+"xxxxxxxxxxxxxxxxxxxxxxxx" +" </td>\r\n");
cont.append("<td>"+"xxxxxxxxxxxxxxxxxxxxxxxx" +" </td>\r\n"); cont.append("</table>\r\n");
cont.append("</body></html>\r\n");
response.getWriter().println(cont.toString());
response.getWriter().close(); }
catch (Exception e){
out.println(e.toString());
}
%>
</BODY>
</HTML> 具体应用以这为基础自己试试吧。
<%@ page import="java.lang.*"%>
<%
try{
response.setContentType("Application/msexcel");
response.setHeader("Content-Disposition", "attachment;filename=trainlist.xls");
StringBuffer cont=new StringBuffer("");
%>
<HTML>
<HEAD>
<META http-equiv="Content-Style-Type" content="text/css">
</HEAD>
<BODY>
<br/><br/><br/>
<%
cont.append("<html><head><META content=\'text/html; charset=gb2312\' http-equiv=Content-Type></head><body>\r\n");
cont.append("<h1>这是什么</h1>");
cont.append("<table width='100%' border='1'>\r\n");
cont.append("<tr>\r\n");
cont.append("<td height='19'>可以</td>\r\n");
cont.append("<td height='19'>我靠,这也行</td>\r\n");
cont.append("<td height='19'>哈哈,我是天才</td>\r\n");
cont.append("<td height='19'>呵呵</td>\r\n");
cont.append("</tr>\r\n");
cont.append("<tr>\r\n");
cont.append("<td>"+"xxxxxxxxxxxxxxxxxxxxxxxx" +" </td>\r\n");
cont.append("<td>"+"xxxxxxxxxxxxxxxxxxxxxxxx" +" </td>\r\n");
cont.append("<td>"+"xxxxxxxxxxxxxxxxxxxxxxxx" +" </td>\r\n");
cont.append("<td>"+"xxxxxxxxxxxxxxxxxxxxxxxx" +" </td>\r\n");
cont.append("</tr>\r\n");
cont.append("<tr>\r\n");
cont.append("<td>"+"xxxxxxxxxxxxxxxxxxxxxxxx" +" </td>\r\n");
cont.append("<td>"+"xxxxxxxxxxxxxxxxxxxxxxxx" +" </td>\r\n");
cont.append("<td>"+"xxxxxxxxxxxxxxxxxxxxxxxx" +" </td>\r\n");
cont.append("<td>"+"xxxxxxxxxxxxxxxxxxxxxxxx" +" </td>\r\n"); cont.append("</table>\r\n");
cont.append("</body></html>\r\n");
response.getWriter().println(cont.toString());
response.getWriter().close(); }
catch (Exception e){
out.println(e.toString());
}
%>
</BODY>
</HTML> 具体应用以这为基础自己试试吧。
解决方案 »
- 这两天研究web service发现的问题
- 在Struts2中如何在一个EL表达式中取出两个变量进行大小比较?
- hibernate 怎么通过代码得到实体类中的哪个字段对映表的主键名
- pet store2.0在NetBeans6.0+glassfish下启动报错,各大虾进来看一下
- form 里加上 ENCTYPE='multipart/form-data' 其它接受的值都是 null 了?
- JSP乱码问题高手指点一下
- 另类:如果在我们公司的服务器上运行jsp网站,需那些软件,是否会有版权问题?
- 关于document.write的问题
- 请各位大侠一起讨论,文件(上传的附件)是用数据库保存方便呢,还是用文件夹管理方便,各自有什么好处?
- java怎么返回一个记录集的记录数?
- jsp中一个很奇怪的初级问题
- ApplicationResources.properties出错信息,怎么找不到呢?
function importExcel()
{
var hwnd=window.open('','','');
hwnd.document.write("<object classid='clsid:0002E510-0000-0000-C000-000000000046' id='Spreadsheet' codebase='msowc.cab' width='576' height='288'><param name='HTMLURL' value='"+window.location.pathname+"'><param name='DataType' value='HTMLURL'><param name='AutoFit' value='0'><param name='DisplayColHeaders' value='-1'><param name='DisplayGridlines' value='-1'><param name='DisplayHorizontalScrollBar' value='-1'><param name='DisplayRowHeaders' value='-1'><param name='DisplayTitleBar' value='-1'><param name='DisplayToolbar' value='-1'><param name='DisplayVerticalScrollBar' value='-1'><param name='EnableAutoCalculate' value='-1'><param name='EnableEvents' value='-1'><param name='MoveAfterReturn' value='-1'><param name='MoveAfterReturnDirection' value='0'><param name='RightToLeft' value='0'><param name='ViewableRange' value='1:65536'></object>");
}
</script>
<table border="1" cellpadding="3" cellspacing="0" width="95%" bgcolor="#EEEEEE" bordercolordark="#FFFFFF" bordercolorlight="#999999">
<tr>
<td width="50%">一行一列</td>
<td width="50%">一行二列</td>
</tr>
<tr>
<td width="50%">二行一列</td>
<td width="50%">二行二列</td>
</tr>
</table>
<input type=button value="导出Excel" onclick="this.style.visibility='hidden';importExcel()">
已经给你贴出完整的代码了~xls不是EXCEL格式文档吗?