JSP导出Excel表格的实例

response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition","attachment;filename=" + URLEncoder.encode("会员列表.xls", "UTF-8"));

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%
 response.setContentType("application/vnd.ms-excel");
 response.setHeader("Content-disposition","attachment;filename=" + java.net.URLEncoder.encode("会员列表.xls", "UTF-8"));
%>



 
 
 
 
 




  

 

 

  
序号
  
卡号
  
姓名
  
年龄

 
 
 

 

   
${model.id}
   
${model.cardNo}
   
${model.name}
   
${model.age}