java实现EasyExcel导出隐藏或显示某一列_easyexcel工具类隐藏部分列

java实现EasyExcel导出隐藏或显示某一列

最近在做导出功能，遇到了很多问题，专门记录一下，有其他导出问题的可以自行查看历史文章。
实际开发中会遇到客户的各种需求，今天主要说一下关于隐藏列的实现
如果只需要隐藏的话，直接在字段上面加一个注解：@ExcelIgnore

如果需要自定义隐藏或显示的话使用下面方法
excludeColumnFiledNames(Arrays.asList(“field3”))

案例一：
参考链接：https://blog.csdn.net/qq_24265439/article/details/129378438?fromshare=blogdetail

 public static void main(String[] args) {
        // 生成文件路径
        writeExcel("/Users/file/A.xlsx");
    }
    public static void writeExcel(String filePath) {
        try {
            // 写入数据
            List<DataDemo> dataList = new ArrayList<>();
            for (int i = 0; i < 10; i++) {
                DataDemo data = new DataDemo();
                data.setField1("A"+i);
                data.setField2("B"+i);
                data.setField3("C"+i);
                dataList.add(data);
            }
            // excludeColumnFiledNames 依据列忽略
            // excludeColumnIndexes 指定删除列index
            // 还支持 includeColumnFiledNames 定义导出列
            EasyExcel.write(filePath, DataDemo.class).excludeColumnFiledNames(Arrays.asList("field3")).sheet("用户").doWrite(dataList);
 
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    @Data
    static
    class DataDemo {
        @ExcelProperty("标题 1")
        String field1;
        @ExcelProperty("标题 2")
        String field2;
        @ExcelProperty("标题 3")
        String field3;
    }
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

案例二：
需要导出的实体类，比如现在要隐藏图片那一列

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.converters.url.UrlImageConverter;
import lombok.Data;

import java.net.URL;

@Data
@ContentRowHeight(40)
@ColumnWidth(25)
public class ExportExcel {
    @ExcelProperty(value = "Event Photo", converter = UrlImageConverter.class)
    private URL imagePath;
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

导出方法：

 public static void export(String exportType, String filename, List<?> dataResult, Class<?> clazz, HttpServletResponse response) {
        response.setStatus(200);
        OutputStream outputStream = null;
        ExcelWriter excelWriter = null;
        try {
            if (StringUtils.isBlank(filename)) {
                throw new RuntimeException("'filename' not null");
            }
            String fileName = filename.concat(".xlsx");
            response.setHeader("Content-Disposition", URLEncoder.encode(fileName, "utf-8"));
            outputStream = response.getOutputStream();
            excelWriter = getExportExcelWriter(outputStream);

            WriteTable writeTable = EasyExcel.writerTable(0).head(clazz).needHead(true).build();
            WriteSheet writeSheet = EasyExcel.writerSheet(fileName).build();
            // 导出时隐藏图片列
            if ("1".equals(exportType)) {
            	String[] str = {"registerPhoto", "realTimePhoto"};
                List<String> list = Arrays.asList(str);
                writeSheet.setExcludeColumnFieldNames(list);
            }
            // 写出数据
            excelWriter.write(dataResult, writeSheet, writeTable);
        } catch (Exception e) {
            log.error("导出excel数据异常：", e);
            throw new RuntimeException(e);
        } finally {
            if (excelWriter != null) {
                excelWriter.finish();
            }
            if (outputStream != null) {
                try {
                    outputStream.flush();
                    outputStream.close();
                } catch (IOException e) {
                    log.error("导出数据关闭流异常", e);
                }
            }
        }
    }
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