easyexcel 输出指定列

最新推荐文章于 2024-06-05 15:45:30 发布

o_瓜田李下_o

最新推荐文章于 2024-06-05 15:45:30 发布

阅读量5.4k

点赞数

分类专栏： easyexcel

本文链接：https://blog.csdn.net/weixin_43931625/article/details/107580864

版权

easyexcel 专栏收录该内容

18 篇文章 2 订阅

订阅专栏

easyexcel 输出指定列

*********************

示例

**************

header 类

Product

@Data
public class Product {

    private Integer id;

    private String productName;

    private Double price;

    @ExcelIgnore
    private String desc;
}

Product2

@Data
public class Product2 {

    private Integer id;
    private String productName;
    private Double price;
    private String desc;
}

**************

测试类

Test

public class Test4 {

    private static final String file_path="e:"+ File.separator+"java"+File.separator+"easyexcel"+File.separator+"write_test8.xlsx";

    private static List<Product> data(){
        List<Product> list=new ArrayList<>();

        for (int i=0;i<5;i++){
            Product product=new Product();
            product.setId(i);
            product.setProductName("海贼王"+i);
            product.setPrice((double)(i+10));
            product.setDesc("动漫");

            list.add(product);
        }

        return list;
    }

    public static void main(String[] args){
        ExcelWriter excelWriter=null;

        Set<String> excludeColumns=new HashSet<>();
        excludeColumns.add("id");

        try {
            excelWriter=EasyExcel.write(file_path).build();

            WriteSheet writeSheet=EasyExcel.writerSheet(0,"sheet").head(Product.class).build();
            WriteSheet writeSheet2=EasyExcel.writerSheet(1,"sheet2").head(Product2.class)
                    .excludeColumnFiledNames(excludeColumns).build();

            excelWriter.write(data(),writeSheet);
            excelWriter.write(data(),writeSheet2);
        }finally {
            if (excelWriter!=null){
                excelWriter.finish();
            }
        }
    }
}