jsp中导出excel方法 displaytag

最新推荐文章于 2024-07-08 18:08:11 发布

鸡腿0452

最新推荐文章于 2024-07-08 18:08:11 发布

阅读量711

点赞数

分类专栏：学到的JSP技术汇总文章标签： excel jsp string iterator hashmap class

本文链接：https://blog.csdn.net/a54034079/article/details/7210862

版权

学到的JSP技术汇总专栏收录该内容

1 篇文章 0 订阅

订阅专栏

<%@ page language="java" import="java.util.*"  pageEncoding="UTF-8" contentType="text/html;charset=utf-8"%>

<%@ taglib uri="http://displaytag.sf.net" prefix="display" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
 <style>
.div_hide
{
   display:none;
}
</style>
  </head>
  
  <body>
  <% 
		  String key1=""; 
		  String value1=""; 
		  HashMap ownlist1=(HashMap)request.getAttribute("ownlist1"); 
		  if(ownlist1.isEmpty())
		  {%>您还没有申请任何表<%}
		  Iterator it=ownlist1.keySet().iterator(); 
		  while(it.hasNext()) 
		  {  
		   key1=(String)it.next(); 
		   value1=(String)ownlist1.get(key1); 
		%><H4>
		<li>
	       <a href="existservlet?id=<%= key1 %>"><span><%=value1%></span></a>
		</li></H4>
		<%	
		}
		%>
	<%
		  String key="";
		  String value="";
		  LinkedHashMap xmmc_map=(LinkedHashMap)request.getAttribute("xmmc");		  
		  LinkedHashMap jhlb_map=(LinkedHashMap)request.getAttribute("jhlb");
		  LinkedHashMap szdw_map=(LinkedHashMap)request.getAttribute("szdw");
		  LinkedHashMap fzrxm_map=(LinkedHashMap)request.getAttribute("fzrxm");
		  Iterator i_xmmc=xmmc_map.keySet().iterator(); 
		  Iterator i_jhlb=jhlb_map.keySet().iterator(); 
		  Iterator i_szdw=szdw_map.keySet().iterator(); 
		  Iterator i_fzrxm=fzrxm_map.keySet().iterator(); 	
	 %>	

<display:table name="<%=xmmc_map%>" 
			   name="<%=jhlb_map%>" 
			   name="<%=szdw_map%>" 
			   name="<%=fzrxm_map%>"//此处最关键，你想要在excel中显示什么，name中就是获得此数据的源
			   export="true" id="currentRowObject" requestURI="selectionservlet?id=2">
<display:setProperty name="export.xml" value="false" />
<display:setProperty name="export.rtf" value="false" />  
<display:setProperty name="export.pdf" value="false" />
<display:setProperty name="export.csv" value="false" />
<display:setProperty name="export.excel.filename" value="已有项目申请列表.xls"/> 

<display:column class="div_hide">//第一列
<% 
key=(String)i_xmmc.next(); 
value=(String)xmmc_map.get(key);%>
<%=value %>
</display:column>

<display:column class="div_hide">//第二列
<%
key=(String)i_jhlb.next(); 
value=(String)jhlb_map.get(key);%>
<%=value %>
</display:column>

<display:column class="div_hide">
<%
key=(String)i_szdw.next(); 
value=(String)szdw_map.get(key);%>
<%=value %>
</display:column>

<display:column class="div_hide">
<%
key=(String)i_fzrxm.next(); 
value=(String)fzrxm_map.get(key);%>
<%=value %>
</display:column>
</display:table>
		  
</body>
</html>

鸡腿0452

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
jsp中导出excel方法 displaytag

.div_hide{ display:none;} <% String key1=""; String value1=""; HashMap ownlist1=(HashMap)request.getAttribute("ownlist1"); if(ownlist1.isEmpty()) {%>您还没有申请任何表<
复制链接

扫一扫