SpringMVC使用AbstractExcelView导出Excel

poi

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>3.10-FINAL</version>
</dependency>

---

controller

@RequestMapping(value = "/exportExcel", method = RequestMethod.POST)  
public String exportExcel(HttpServletRequest request, Model model) {  
    try {  
        //查询导出数据
        List<Order> orderList = orderService.findListByParam(map);
        //设置名称、标题、数据一一对应
        DtExcelMap excel = DtExcelMap.getExcelMap("订单列表", 
            new String[] { "ID","编号","序列", "匿名", "状态", "姓名","手机号"},
            orderList,  
            new String[] { "id","orderNo","serialNumber", "anonymous", "statusView", "realName", "mobile"});  
        model.addAttribute("map", excel);
        //返回视图(xml中配置)
        return "excelView";
    } catch (Exception e) {  
        log.error("导出excel失败：" + e);  
    }  
    return null;  
}

---

ExcelView

import java.util.Date;  
import java.util.List;  
import java.util.Map;  
import javax.servlet.http.HttpServletRequest;  
import javax.servlet.http.HttpServletResponse;  
import org.apache.poi.hssf.usermodel.HSSFRow;  
impo