java解析excel表格

解析表格的时候直接调用这个方法:
导包:
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;
	}