使用poi读取上传的excel文件内容

使用poi读取上传的excel文件内容

	/**
	 * 保存excel数据
	 */
	public void saveTypeExcel() {
		UploadFile files = this.getFile("files", DateUtil.getNowDateShort());
		// 获取文件
		File file = files.getFile();
		// 获取上传的文件名称
		String fileName=files.getOriginalFileName();
		//文件后缀
		String hz = fileName.substring(fileName.lastIndexOf(".")+1);
		List<List<String>> list = null;
		try {
			list = ExcelUtil.excelToList(file,hz);
		} catch (IOException e) {
			e.printStackTrace();
		}
		for (List<String> strings : list) {
			System.out.println(strings);
		}

	}

这里xls格式需要用HSSFWorkbook;xlsx则需要XSSFWorkbook

public class ExcelUtil {
	@SuppressWarnings("resource")
	public static List<List<String>> excelToList(File filePath,String hz) throws IOException{
		List<List<String>> result = new ArrayList<List<String>>();
        // 读取，全部sheet表及数据
		Workbook workbook = null;
        if (hz.toLowerCase().endsWith("xls")) {
            workbook = new HSSFWorkbook(new BufferedInputStream(new FileInputStream(filePath)));
        } else {
            workbook = new XSSFWorkbook(new BufferedInputStream(new FileInputStream(filePath)));
        }
        Sheet sheet = workbook.getSheetAt(0);
        int maxRowNum = sheet.getLastRowNum()+1;
        for (int j = 0; j < maxRowNum; j++) {// 循环所有行
        	List<String> rowList = new ArrayList<>();
            Row row = sheet.getRow(j);//读取行
            if (row != null) {
                for (int k = 0; k < row.getLastCellNum(); k++) {// getLastCellNum，是获取最后一个不为空的列是第几个
                	String cellStr = row.getCell(k) != null?DbImportExcelUtils.getCellStringValue(row.getCell(k)):"";
                	rowList.add(cellStr);
                }
            }
            result.add(rowList);
        }
        return result;
	}
}

所需要的jar包：

点击下载所需jar包链接。