1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
///**
// * Copyright (c) 2018 人人开源 All rights reserved.
// *
// * https://www.renren.io
// *
// * 版权所有，侵权必究！
// */
//
//package com.iailab.common.utils;
//
//import cn.afterturn.easypoi.excel.ExcelExportUtil;
//import cn.afterturn.easypoi.excel.entity.ExportParams;
//import org.apache.commons.lang3.StringUtils;
//import org.apache.poi.ss.usermodel.Workbook;
//import org.springframework.beans.BeanUtils;
//
//import javax.servlet.ServletOutputStream;
//import javax.servlet.http.HttpServletResponse;
//import java.io.IOException;
//import java.net.URLEncoder;
//import java.util.ArrayList;
//import java.util.Collection;
//import java.util.Date;
//import java.util.List;
//
///**
// * excel工具类
// *
// * @author Mark sunlightcs@gmail.com
// */
//public class ExcelUtils {
//
//    /**
//     * Excel导出
//     *
//     * @param response      response
//     * @param fileName      文件名
//     * @param list          数据List
//     * @param pojoClass     对象Class
//     */
//    public static void exportExcel(HttpServletResponse response, String fileName, Collection<?> list,
//                                     Class<?> pojoClass) throws IOException {
//        if(StringUtils.isBlank(fileName)){
//            //当前日期
//            fileName = DateUtils.format(new Date());
//        }
//
//        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), pojoClass, list);
//        response.setCharacterEncoding("UTF-8");
//        response.setHeader("content-Type", "application/vnd.ms-excel");
//        response.setHeader("Content-Disposition",
//                "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8") + ".xls");
//        ServletOutputStream out = response.getOutputStream();
//        workbook.write(out);
//        out.flush();
//    }
//
//    /**
//     * Excel导出，先sourceList转换成List<targetClass>，再导出
//     *
//     * @param response      response
//     * @param fileName      文件名
//     * @param sourceList    原数据List
//     * @param targetClass   目标对象Class
//     */
//    public static void exportExcelToTarget(HttpServletResponse response, String fileName, Collection<?> sourceList,
//                                     Class<?> targetClass) throws Exception {
//        List targetList = new ArrayList<>(sourceList.size());
//        for(Object source : sourceList){
//            Object target = targetClass.newInstance();
//            BeanUtils.copyProperties(source, target);
//            targetList.add(target);
//        }
//
//        exportExcel(response, fileName, targetList, targetClass);
//    }
//}