Java-easy Excel监听器

最新推荐文章于 2025-03-05 22:53:03 发布

UID_UUID

最新推荐文章于 2025-03-05 22:53:03 发布

阅读量1k

点赞数

文章标签： java excel

本文链接：https://blog.youkuaiyun.com/UID_UUID/article/details/121648867

版权

实现层：

返回成功失败条数，原因

    public String inportExcel(MultipartFile file) {

        ImportExcelListener excelListener = new ImportExcelListener(budgetIssuedService, budgetIssuedRepository, year);
        try {
            EasyExcel.read(multipartFileToFile(file), AnnualBudgetExport.class, excelListener).headRowNumber(5).doReadAll();
        } catch (Exception exception) {
            return "数据格式异常";
        }

        return excelListener.message();
    }

监听器：

@Data
public class ImportExcelListener extends AnalysisEventListener<AnnualBudgetExport> {
    private final Logger log = LoggerFactory.getLogger(AnnualBudgetExport.class);
    @Autowired
    BudgetIssuedRepository budgetIssuedRepository;
    List<AnnualBudgetExport> list = new ArrayList<>();

    String type = "1";
    int empty = 0;
    int success