EasyExcel导出自动计算列宽

最新推荐文章于 2024-08-04 03:53:53 发布

Da白兔萘糖

最新推荐文章于 2024-08-04 03:53:53 发布

阅读量585

点赞数 6

文章标签： windows

本文链接：https://blog.youkuaiyun.com/Lyq2017901206/article/details/140268580

版权

Maven

<dependencies>
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>easyexcel</artifactId>
        <version>3.1.1</version>
    </dependency>
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <version>1.18.22</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>fastjson</artifactId>
        <version>1.2.47</version>
    </dependency>
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.12</version>
        <scope>test</scope>
    </dependency>
</dependencies>

excel导出处理模块

@Override
    public ResultMsg export(SatisfactionTemplateExportDTO search, HttpServletRequest request, HttpServletResponse response) {
        try {
        PageInfo<SatisfactionOrderPageResqVO> userList=hosSatisfactionOrderService.findPage(search);
        if (userList.getList().size()==0){
            return new ResultMsg(false,"没有数据导出");
        }
        HosSatisfactionQuestionExample example=new HosSatisfactionQuestionExample();
        example.createCriteria().andSatisfactionIdEqualTo(search.getId());
        List<HosSatisfactionQuestion> questionList=hosSatisfactionQuestionService.selectByExample(example);
        logger.info