@NoArgsConstructor(access = AccessLevel.PRIVATE) @Slf4j public final class ExcelUtils { /** * 读取Excel表格的第一个sheet数据到list, 强制实体类成员变量声明顺序与Excel数据列数据一致 * @param file MultipartFile * @param clazz 数据类的class * @return list<T> */ public static <T> List<T> readFromExcel(MultipartFile file, Class<T> clazz) { // 排除掉被@FieldExclude 标记过的Field List<Field> fields = Arrays.stream(clazz.getDeclaredFields()) .filter(field -> field.getAnnotation(FieldExclude.class) == null) .collect(Collectors.toList()); List<T> result; Sheet sheet; try { InputStream stream = file.getInputStream(); Workbook workbook = new XSSFWorkbook(stream); // 读取Excel第一个sheet sheet = workbook.getSheetAt(0); } catch (IOException e) { log.error("Excel数据读取失败:
读取Excel文件,用对象接收数据
最新推荐文章于 2022-03-05 17:37:45 发布