jasperReport导出excel(springMvc)

代码

@RequestMapping(value="/exexcel")    public void exportExcel(HttpServletRequest request,HttpServletResponse response) throws JRException, IOException{          //打印程序当前路径        System.out.println(System.getProperty("user.dir"));          WebApplicationContext webApplicationContext = ContextLoader.getCurrentWebApplicationContext();           ServletContext servletContext = webApplicationContext.getServletContext();          String jasperPath = servletContext.getRealPath(                      "/WEB-INF/jasper/report13.jasper");           Map<String,Object> params  = new HashMap<String,Object>();             //UserJs.getUser()是List类型数据源            JRDataSource dataSource = new JRBeanCollectionDataSource(UserJs.getUser(), true);              //print文件              JasperPrint print =  JasperFillManager.fillReport(jasperPath, params, dataSource);             //以附件形式保存文件            String generateFileName = "My文件.xlsx";              response.setContentType("application/vnd.ms-excel");                          response.setHeader("Content-disposition", "attachment; filename="                                  + URLEncoder.encode(generateFileName,"utf8"));              //设置导出时参数              SimpleXlsxReportConfiguration conf = new SimpleXlsxReportConfiguration();              conf.setWhitePageBackground(false);              conf.setDetectCellType(true);              JRXlsxExporter exporter = new JRXlsxExporter();              exporter.setConfiguration(conf);              //设置输入项              ExporterInput exporterInput = new SimpleExporterInput(print);              exporter.setExporterInput(exporterInput);              //设置输出项              OutputStreamExporterOutput exporterOutput = new SimpleOutputStreamExporterOutput(response.getOutputStream());              exporter.setExporterOutput(exporterOutput);              exporter.exportReport();       }

UserJs.java

package com.xie.vo;import java.util.ArrayList;import java.util.HashMap;import java.util.List;import java.util.Map;/** * 用于测试jasperReport * @author xie * */public class UserJs {    private int id;    private String name;    private int age;    private String title;    public UserJs() {        super();    }    public UserJs(int id, String name, int age, String title) {        super();        this.id = id;        this.name = name;        this.age = age;        this.title=title;    }    public int getId() {        return id;    }    public void setId(int id) {        this.id = id;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public int getAge() {        return age;    }    public void setAge(int age) {        this.age = age;    }    public static List<UserJs> getUser(){        List<UserJs> listUserJs=new ArrayList<>();        listUserJs.add(new UserJs(0,"xx",20,"user表"));        listUserJs.add(new UserJs(1,"写好",23,"user表"));        listUserJs.add(new UserJs(2, "pp", 32,"user表"));        return listUserJs;    }    public static Map<String,Object> getUserMap(){        Map<String,Object> map=new HashMap<>();        map.put("id",0);        map.put("name","好啊");        map.put("age", 23);        map.put("title", "表格");        return map;    }    public String gettitle() {        return title;    }    public void settitle(String title) {        this.title = title;    }}

说明

参考（复制）了网上好多人的，比如：
http://blog.csdn.net/wangjun5159/article/details/51152403
http://blog.csdn.net/wangjun5159/article/details/51152403
http://blog.csdn.net/zhuhuiby/article/details/8569516