Springmvc 使用 AbstractExcelView 导出excel

 $("#exportBtn").click(function () {
            location.href = "${pageContext.request.contextPath}/report/export?" + $("form").serialize()
        });

1.新建类继承AbstractExcelView

 1 import java.io.OutputStream;  
 2 import java.util.Map;  
 3 import javacommon.util.MyUtils;  
 4 import javax.servlet.http.HttpServletRequest;  
 5 import javax.servlet.http.HttpServletResponse;  
 6 import org.apache.poi.hssf.usermodel.HSSFCell;  
 7 import org.apache.poi.hssf.usermodel.HSSFCellStyle;  
 8 import org.apache.poi.hssf.usermodel.HSSFRow;  
 9 import org.apache.poi.hssf.usermodel.HSSFSheet;  
10 import org.apache.poi.hssf.usermodel.HSSFWorkbook;  
11 import org.springframework.web.servlet.view.document.AbstractExcelView;  
12 public class ViewExcel extends AbstractExcelView {  
13     @Override  
14     protected void buildExcelDocument(Map<String, Object> obj,  
15             HSSFWorkbook workbook, HttpServletRequest request, HttpServletResponse response)  
16             throws Exception {  
17         HSSFSheet sheet = workbook.createSheet("list");    
18         sheet.setDefaultColumnWidth((short) 12);    
19         HSSFCell cell = getCell(sheet, 0, 0);    
20         setText(cell, "Spring Excel test");    
21         HSSFCellStyle dateStyle = workbook.createCellStyle();    
22         //dateStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("mm/dd/yyyy"));    
23         cell = getCell(sheet, 1, 0);    
24         cell.setCellValue("日期：2008-10-23");    
25         //cell.setCellStyle(dateStyle);    
26         getCell(sheet, 2, 0).setCellValue("测试1");    
27         getCell(sheet, 2, 1).setCellValue("测试2");  
28         HSSFRow sheetRow = sheet.createRow(3);    
29         for (short i = 0; i < 10; i++) {    
30             sheetRow.createCell(i).setCellValue(i * 10);    
31         }    
32         String filename = "测试.xls";//设置下载时客户端Excel的名称     
33         filename = MyUtils.encodeFilename(filename, request);//处理中文文件名  
34         response.setContentType("application/vnd.ms-excel");     
35         response.setHeader("Content-disposition", "attachment;filename=" + filename);     
36         OutputStream ouputStream = response.getOutputStream();     
37         workbook.write(ouputStream);     
38         ouputStream.flush();     
39         ouputStream.close();     
40     }  
41 }

处理中文文件名的方法：

 1 /**  
 2      * 设置下载文件中文件的名称  
 3      *   
 4      * @param filename  
 5      * @param request  
 6      * @return  
 7      */    
 8     public static String encodeFilename(String filename, HttpServletRequest request) {    
 9       /**  
10        * 获取客户端浏览器和操作系统信息  
11        * 在IE浏览器中得到的是：User-Agent=Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Maxthon; Alexa Toolbar)  
12        * 在Firefox中得到的是：User-Agent=Mozilla/5.0 (Windows; U; Windows NT 5.1; zh-CN; rv:1.7.10) Gecko/20050717 Firefox/1.0.6  
13        */    
14       String agent = request.getHeader("USER-AGENT");    
15       try {    
16         if ((agent != null) && (-1 != agent.indexOf("MSIE"))) {    
17           String newFileName = URLEncoder.encode(filename, "UTF-8");    
18           newFileName = StringUtils.replace(newFileName, "+", "%20");    
19           if (newFileName.length() > 150) {    
20             newFileName = new String(filename.getBytes("GB2312"), "ISO8859-1");    
21             newFileName = StringUtils.replace(newFileName, " ", "%20");    
22           }    
23           return newFileName;    
24         }    
25         if ((agent != null) && (-1 != agent.indexOf("Mozilla")))    
26           return MimeUtility.encodeText(filename, "UTF-8", "B");    
27       
28         return filename;    
29       } catch (Exception ex) {    
30         return filename;    
31       }    
32     }

2接下来在你的下载 Controller里面返回ModelAndView 即可

 1 /** 
 2     * 导出Excel 
 3     * @param model 
 4     * @param projectId 
 5     * @param request 
 6     * @return 
 7     */  
 8    @RequestMapping(value="/dcExcel",method=RequestMethod.GET)  
 9     public ModelAndView toDcExcel(ModelMap model, HttpServletRequest request){  
10        List list = new ArrayList();  //测试数据没有用到  
11        Map map = new HashMap();    
12        list.add("test1");    
13        list.add("test2");    
14        map.put("list", list);    
15        ViewExcel viewExcel = new ViewExcel();    
16        return new ModelAndView(viewExcel, model);   
17    }

代码很简单，只实现下载，关于Excel 格式数据方面请参考 poi 框架