JSP导出Excel文件

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib prefix="ai" uri="/WEB-INF/tag/ai-tags.tld"%>
<%@ taglib uri="/WEB-INF/tag/ElTag.tld" prefix="el"%>
<%@ page import="java.text.SimpleDateFormat" %>
<%@ page import="java.util.Date" %>
<%
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String dateStr = format.format(new Date());
response.setContentType("Application/msexcel; charset=UTF-8");
System.out.println("dateStr="+dateStr);
String fileName = "促销费"+dateStr;
fileName = new String(fileName.getBytes("GBK"),"iso-8859-1");
response.setHeader("Content-disposition","attachment; filename="+fileName+".xls");
%>
<div class="big_main" id="sos_list_div" style="width: 1400px; overflow: hidden">
   <div class="query_table">
     <table width="100%" border="1" cellspacing="1">
       <tr align="center" valign="middle">
         <td height="35" colspan="14" align="center" style="border-bottom: 2px #ddd solid"><span class="STYLE4 STYLE6">${title}促销费</span></td>
       </tr>
       <tr align="center" valign="middle">
         <td  height="35" colspan="2">统计时间：${sj }</td>
         <td  width="20%" colspan="10">&nbsp;</td>
         <td  width="7%"  colspan="2"><span class="STYLE4">促销费合计：${totalAmount } 元</td>
       </tr>
   </div>
  <div class="query_table" style=" margin-top:0px">
    <table width="100%" border="0" cellspacing="1">
      <tr align="center" valign="middle" bgcolor="#e3f0f6" style=" border-top:1px solid #d1d3d5;">
        <td width="6%" height="35">促销费月份</td>
        <td width="6%" height="35">受理日期</td>
        <td width="7%">活动编码</td>
        <td width="6%" height="35">活动名称</td>
        <td width="6%" height="35">销售数量</td>
        <td width="9%" height="35">促销费金额（元）</td>
        <td width="7%" height="35">营业员代码</td>
        <td width="7%" height="35">营业员</td>
        <td width="6%" height="35">发展人编号</td>
        <td width="7%" height="35">发展人姓名</td>
        <td width="6%" height="35">门店代码 </td>
        <td width="10%">门店名称</td>
        <td width="6%" height="35"><span class="STYLE4">公司代码</span></td>
        <td width="8%" height="35"><span class="lan_zi">公司名称</span></td>
      </tr>
      
      <!-- 循环显示数据 -->
      <c:forEach items="${pageInfo.result}" var="v" varStatus="vs" begin="0" step="1">
      <tr>
        <td height="35" align="center" valign="middle">${v.protoMonth}</td>
        <td height="35" align="center" valign="middle">${v.dealTime}</td>
        <td align="center" valign="middle">${v.productId}</td>
        <td height="35" align="center" valign="middle">${v.productName}</td>
        <td height="35" align="center" valign="middle">${v.sellNum}</td>
        <td height="35" align="center" valign="middle">${v.protoFee}</td>
        <td height="35" align="center" valign="middle">${v.optOperId}</td>
        <td height="35" align="center" valign="middle">${v.optOperName}</td>
        <td height="35" align="center" valign="middle">${v.devId}</td>
        <td height="35" align="center" valign="middle">${v.devName}</td>
        <td height="35" align="center" valign="middle">${v.storeId}</td>
        <td align="center" valign="middle">${v.storeName}</td>
        <td height="35" align="center" valign="middle">${v.componentId }</td>
        <td height="35" align="center" valign="middle">${v.componentName}</td>
      </tr>
      </c:forEach>
    </table>
  </div>
<!-------查询table区结束-------->
</div>

JSP导出Excel文件,古老的榕树,5-wow.com