public static List<List<String>> getExcelRowList(MultipartFile multipartFile) throws IOException {
//行List,也是最终要返回的List
List<List<String>> rowList=new ArrayList<>();
Workbook workbook=getExcelWorkBook(multipartFile);
Sheet sheet = workbook.getSheetAt(0);
if (sheet == null) {
throw new IOException("创建Sheet失败!");
}
//开始遍历行
for (int i=sheet.getFirstRowNum();i<= sheet.getLastRowNum();i++){
Row row = sheet.getRow(i);
//列List
List<String> cellList=new ArrayList<>();
//转换为List数组
for (int cellNum=1;cellNum<= row.getLastCellNum();cellNum++){
cellList.add(row.getCell(cellNum));
}
rowList.add(cellList);
}
workbook.close();
return rowList;
}
//获取WorkBook对象
private static Workbook getExcelWorkBook(MultipartFile multipartFile) throws IOException {
InputStream inputStream=multipartFile.getInputStream();
String originalFileName=multipartFile.getOriginalFilename();
String fileType=originalFileName.substring(originalFileName.lastIndexOf(".")+1);
if (fileType.equalsIgnoreCase("xls")) {
//xls格式
return new HSSFWorkbook(inputStream);
} else {
//xlsx格式
return new XSSFWorkbook(inputStream);
}
}
java将Excel数据转换为List数据
最新推荐文章于 2023-06-14 11:16:36 发布