//将输入放到数组中, 异步, 无法直接操作,从第三行开始识别数据 List<InStockImportExcelDTO> data = new ArrayList<>(); try (ExcelReader excelReader = EasyExcelFactory.read(file.getInputStream(), Object.class, new SimpleReadListener<Object>(data::addAll)) .headRowNumber(2).build()) { GlobalConfiguration globalConfiguration = excelReader.analysisContext().currentReadHolder().globalConfiguration(); globalConfiguration.setAutoTrim(false); excelReader.read(new ReadSheet()); excelReader.finish(); }
EazyExcel读取文件时,默认去除读取cell中的空格,关闭默认配置
于 2024-03-26 15:45:52 首次发布