选中列表中数据，使用java实现导出功能

一:首先pom.xml文件的包

 <!-- poi -->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>3.17</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>3.17</version>
        </dependency>

二:写一个注解类

//用于描述Annotation所修饰的对象返范围
@Target(ElementType.FIELD)
//表明ExcelExport是一个注解
@Retention(RetentionPolicy.RUNTIME)
public @interface ExcelExport {

    /**
    * 列
    **/
    int cell() default 0;

    String title() default "";
    String dateFormat() default  "yyyy-MM-dd";
    ExcelDateType dataType() default ExcelDateType.STRING;
}

三:写一个枚举类

public enum ExcelDateType {

    STRING("string"),
    AMOUNT("amount"),
    DATE("date");
    private String type;

    //构造方法
    ExcelDateType(String type) {
        this.type = type;
    }
}

四:在返回的实体类的属性上添加自定义的注解类

public class OrderBaselineListDTO implements Serializable {
    private static final long serialVersionUID = 1L;

 
    /**
     * 用户昵称
     */
    @ExcelExport(cell = 0,title = "用户昵称")
    private String nickName;

    /**
     * 手机号
     */
    @ExcelExport(cell = 1,title = "手机号")
    private String telephone;

    /**
     * 实付价格
     */
    @ExcelExport(cell = 2,title = "实付价格",dataType= ExcelDateType.AMOUNT)
    private Integer actuallyPay;


    /**
     * 创建时间
     */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    @ExcelExport(cell = 3,title = "创建时间",dataType= ExcelDateType.DATE)
    private Date createTime;

}

五:开始写导出功能

public class ExcelUtil {
    public static void main(String[] args) {

    }

    public static Logger logger = LoggerFactory.getLogger(ExcelUtil.class);

    public static <T> void exportExcel(HttpServletResponse response, List<T> list, String filename, String sheetName) {
        HSSFWorkbook workBook = getWorkBook(list, sheetName);
        try {
            response.setHeader("Content_Disposition", "attachment; filename=" + URLEncoder.encode(filename, "UTF-8") + ".xls");
            response.setContentType("application/vnd.ms-excel; charset=UTF-8");
            OutputStream out = response.getOutputStream();
            workBook.write(out);
            out.flush();
            out.close();
        } catch (IOException e) {
            logger.error(e.getMessage());
            e.printStackTrace();
        }
    }

 
    private static <T> HSSFWorkbook getWorkBook(List<T> list, String sheetName) {
        HSSFWorkbook w = new HSSFWorkbook();
        //创建sheet
        HSSFSheet sheet = w.createSheet(sheetName);
        //创建行
        HSSFRow row = sheet.createRow(0);
        //创建列
        HSSFCell cell;
        //将查询出来的数据判空
        if (CollectionUtils.isEmpty(list)) {
            return w;
        }
        //list里面存的是对象,getDeclaredFields()利用反射得到对象里面的所有的变量,getFields()得到被public修饰的变量
        Field[] declaredFields = list.get(0).getClass().getDeclaredFields();
        for (Field field : declaredFields) {
            //得到该注解作用在某对象的变量上的改注解的属性值,如果该对象的变量都没有使用该注解,则返回null
            /**
             * 某个对象的变量名 name
             * @ExcelExport(cell=0,title="名字")
             *  private String name;
             *  只是获取属性name,并没有获取name的值
             *  此时的annotion={cell=0,title="名字"}
             **/
            ExcelExport annotation = field.getAnnotation(ExcelExport.class);
            //写表头
            if (annotation != null) {
                //第一行第某列
                cell = row.createCell(annotation.cell());
                //给第一行第某列赋值
                cell.setCellValue(annotation.title());
            }
        }
        //写数据
        for (int i = 0; i < list.size(); i++) {
            //第一行是标题,所以数据是从第二行开始
            row = sheet.createRow(i + 1);
            T obj = list.get(i);
            Field[] fileds = obj.getClass().getDeclaredFields();
            for (Field filed : fileds) {
                ExcelExport annotation = filed.getAnnotation(ExcelExport.class);
                //另一种,只是判断该变量是否有ExcelExport注解修饰,返回布尔类型
                // boolean annotationPresent = filed.isAnnotationPresent(ExcelExport.class);
                if (annotation != null) {
                    //想要获取变量的值,需要设置对象的访问权限,保证对private的属性的访问
                    filed.setAccessible(true);

                    //创建单元格,并设置值
                    String value = "";
                    try {
                        //得到变量的值,就是这么写的,变量.get(对象)得到变量的值
                        if (null != filed.get(obj)) {
                            switch (annotation.dataType()) {
                                case DATE:
                                    value = new SimpleDateFormat(annotation.dateFormat()).format(filed.get(obj));
                                    break;
                                case AMOUNT:

                                    value = new BigDecimal(filed.get(obj).toString()).divide(new BigDecimal("100")).toPlainString();

                                    break;
                                default:
                                    value = filed.get(obj) == null ? "" : filed.get(obj).toString();
                                    break;
                            }
                        }
                        row.createCell(annotation.cell()).setCellValue(value);
                    } catch (IllegalAccessException e) {
                        e.printStackTrace();
                    }

                }
            }
        }
        return w;
    }
}

六控制层(controller)

    @GetMapping("/getOrderList/v1")
    public void  getOrderList(@RequestParam(value = "pageSize",defaultValue = "20") Integer pageSize,
                                      @RequestParam(value = "currentPage" ,defaultValue = "1")Integer currentPage,
                                      OrderListRequestParam param, HttpServletResponse response) {

       Map map =orderService.getOrderList(currentPage, pageSize, param);
        List list = (List) map.get("list");
        ExcelUtil.exportExcel(response,list ,"订单列表","sheet1");

    }

七:使用postMan测试如图:

然后选择要下载的地方就好了

如果直接选择send会出现如下情况