解析表格的时候直接调用这个方法:
导包:
ExcelUtil:导包用package cn.hutool.poi.excel;
参数说明:
String uploadFileName:String uploadFileName = file.getOriginalFilename(),上传的文件名称;
MultipartFile file:表示文件二进制流;
int sheetNumber:解析哪个sheet,比如第一个sheet就是0;
返回参数List<String[]> excelList,比如excelList.get(0),就是获得第一行row的数据;
private List<String[]> decoderExcel(String uploadFileName, MultipartFile file, int sheetNumber) {
List<String[]> excelList = new ArrayList<>();
String nameExt = uploadFileName;
// 获得文件的后缀
String postFix = nameExt.substring(nameExt.lastIndexOf(".")).toLowerCase();
try {
if (".xlsx".equals(postFix) || ".xls".equals(postFix)) {
List<List<Object>> readAll = ExcelUtil.getReader(file.getInputStream(), 0).read();
int cols = 0;
for (int i = 0; i < readAll.size(); i++) {
List<Object> rowList = readAll.get(i);
if (i == 0) {
cols = rowList.size();
}
String[] row = new String[cols];
int rowSize = rowList.size() >= cols ? cols : rowList.size();
for (int j = 0; j < rowSize; j++) {
row[j] = rowList.get(j) == null ? "" : rowList.get(j).toString().trim();
}
excelList.add(row);
logger.debug("==第" + sheetNumber + "页 第 " + i + "行===" + readAll.get(i));
}
}
} catch (Exception e) {
throw new Exception("文件解析错误!");
}
return excelList;
}