1.导入jar包

<!--      解析  导出excel-->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>3.15</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>3.15</version>
        </dependency>

2.解析工具类

public static String getContent(File file, int page, int i, int j){
        String s = null;
        try {
            Workbook workbook = Workbook.getWorkbook(new File(String.valueOf(file)));
            Sheet sheet = workbook.getSheet(page);

            int rows = sheet.getRows(); //行
            int cols = sheet.getColumns(); //列
            Cell[] cells = sheet.getColumn(j); // j 代表第几列
            s = cells[i].getContents();  //i代表第几行
//            System.out.print(cells[i].getContents());//获取一行
        }catch (Exception e){
            e.printStackTrace();
        }
        return s;
    }
3.接收上传的文件,并解析

@RequestMapping("UpdateInvestmentLeasing")
    String UpdateInvestmentLeasing(@RequestParam("file") MultipartFile file) throws IOException {
//        try {
//          获取文件的名字
            String fileName = file.getOriginalFilename();
            String dir=System.getProperty("user.dir");
//          指定文件存储路径  File.separator 代表/或者\   跨平台
            String destFileName=dir+ File.separator+"src"+File.separator+"main"+File.separator+"resources"+File.separator + "imports" +File.separator+ fileName;

        System.out.println(ExcelTool.getContent(new File(destFileName),0,0,0));

        return "修改成功";
    }