java导出内容excel（poi）

１.业务处理类（exportExcel.jsp）

<%@ page language="java" import="java.util.*,java.io.OutputStream,jxl.Workbook" pageEncoding="utf-8"%>
<%@page import="java.sql.*,java.io.PrintWriter"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFSheet"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFCellStyle"%>
<%@page import="org.apache.poi.hssf.util.HSSFColor"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFFont"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFRow"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFCell"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFRichTextString"%>
<%
response.setContentType("text/html;charSet=UTF-8");
request.setCharacterEncoding("UTF-8");

response.setContentType("octets/stream");  
//response.addHeader("Content-Disposition", "attachment;filename=test.xls");  
String excelName = "公告列表";
//转码防止乱码  
response.addHeader("Content-Disposition", "attachment;filename="+new String(excelName.getBytes("gb2312"), "ISO8859-1" )+".xls");  
String[] headers = new String[]{"编号","姓名","年龄","性别"};//表头信息列
try {
    OutputStream ou = response.getOutputStream();  
    exportExcel(excelName,headers, getList(), ou,"yyyy-MM-dd");  
    ou.close();
    out.clear();
    out = pageContext.pushBody();
    System.out.println("excel导出成功！");  
} catch (Exception e) {
        e.printStackTrace();  
}
%>

<%!
/** 
 *  
 * @Description: 模拟从数据库中查询出来的数据，一般是数据表中的几列 
 */  
public List<Map<String,Object>> getList(){
    List<Map<String,Object>> list = new ArrayList<Map<String,Object>>();  
    for(int i = 0; i<100;i++){
        Map<String,Object> map = new HashMap<String, Object>();  
        map.put("number",1000+i);  
        map.put("name", "张三"+i);  
        int age = (int)(Math.random()*100);  
        do{  
            age = (int)(Math.random()*100);  
        }while(age<10||age>15);  
        map.put("age", age);  
        map.put("sex", age%2==0?0:1);//获得随机性别  
        list.add(map);  
    }  
    return list;  
}
%>
<%!
/** 
 *  
 * @Description: 生成excel并导出到客户端（本地） 
 */  
protected void exportExcel(String title,String[] headers,List mapList,OutputStream ou,String pattern){  
    //声明一个工作簿  
    HSSFWorkbook workbook = new HSSFWorkbook();  
    //生成一个表格  
    HSSFSheet sheet = workbook.createSheet(title);  
    //设置表格默认列宽度为20个字符  
    sheet.setDefaultColumnWidth(20);  
    //生成一个样式，用来设置标题样式  
    HSSFCellStyle style = workbook.createCellStyle();  
    //设置这些样式  
    style.setFillForegroundColor(HSSFColor.SKY_BLUE.index);  
    style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);  
    style.setBorderBottom(HSSFCellStyle.BORDER_THIN);  
    style.setBorderLeft(HSSFCellStyle.BORDER_THIN);  
    style.setBorderRight(HSSFCellStyle.BORDER_THIN);  
    style.setBorderTop(HSSFCellStyle.BORDER_THIN);  
    style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
    //生成一个字体  
    HSSFFont font = workbook.createFont();  
    font.setColor(HSSFColor.VIOLET.index);  
    font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);  
    //把字体应用到当前的样式  
    style.setFont(font);  
    // 生成并设置另一个样式,用于设置内容样式  
    HSSFCellStyle style2 = workbook.createCellStyle();  
    style2.setFillForegroundColor(HSSFColor.LIGHT_YELLOW.index);  
    style2.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);  
    style2.setBorderBottom(HSSFCellStyle.BORDER_THIN);  
    style2.setBorderLeft(HSSFCellStyle.BORDER_THIN);  
    style2.setBorderRight(HSSFCellStyle.BORDER_THIN);  
    style2.setBorderTop(HSSFCellStyle.BORDER_THIN);  
    style2.setAlignment(HSSFCellStyle.ALIGN_CENTER);  
    style2.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);  
    // 生成另一个字体  
    HSSFFont font2 = workbook.createFont();  
    font2.setBoldweight(HSSFFont.BOLDWEIGHT_NORMAL);  
    // 把字体应用到当前的样式  
    style2.setFont(font2);  
    //产生表格标题行  
    HSSFRow row = sheet.createRow(0);  
    //for(int i = 0; i<headers.length;i++){
    	Map<String,Object> map1 = (Map<String, Object>) mapList.get(0);
    	int num=0;
    	for(String key:map1.keySet()){
    		HSSFCell cell = row.createCell(num++);  
            cell.setCellStyle(style);  
            HSSFRichTextString text = new HSSFRichTextString(key);  
            cell.setCellValue(text);
    	}
   // }
    for (int i=0;i<mapList.size();i++) {  
        Map<String,Object> map = (Map<String, Object>) mapList.get(i);  
        row = sheet.createRow(i+1);  
        int j = 0;
        Object value = null;  
        for(String key:map.keySet()){
        	row.createCell(j++).setCellValue(map.get(key).toString());//内容
        }
    }  
    try {  
        workbook.write(ou);  
    } catch (Exception e) {  
        e.printStackTrace();  
    }
}  

%>

２.测试导出类（execl.jsp）

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    <title>导出</title>
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<script type="text/javascript" src="js/jquery-1.8.0.min.js"></script>
  </head>
  <script type="text/javascript">
    
    
  </script>
  <body>
    <form action="exceleport/exportExcel.jsp" method="post">
     <input  type="submit" value="导出"/>
    </form>
    
  </body>
</html>

ps:如果用ajax调用导出弹出框不会弹出，无法实现导出保存。所以建议不要用ajax方式调用导出