SpringBoot读取Excel

通用方法

      String file ="Doc/批量导入模板.xls";
//得到路径
      String path=request.getRealPath(file);
//得到路径
      InputStream input=new FileInputStream(path);
      System.out.println(input);
      Workbook sheets= null;
      try {
          sheets = WorkbookFactory.create(input);
          Sheet sheet=sheets.getSheetAt(0);
	//得到列
          int rows=sheet.getPhysicalNumberOfRows();
          Row row=sheet.getRow(0);
	//得到行
          int cols=row.getPhysicalNumberOfCells();
          System.out.println("行："+rows);
          System.out.println("列："+cols);
          for(int i=0;i<rows;i++){
              /**
               * 取出第一行
               */
              row=sheet.getRow(i);
		//取出第1列
              String type=row.getCell(0).toString();
		//取出第2列
              String info=row.getCell(3).toString();
              System.out.println(type +"--"+info);
          }
      } catch (InvalidFormatException e) {
          e.printStackTrace();
      }

xss 类型execl

String file="doc/hello.xlsx";
      String realpath=req.getRealPath(file);
      InputStream input=new FileInputStream(realpath);
      System.out.println(realpath);
      System.out.println(input);
      XSSFWorkbook sheets=new XSSFWorkbook(input);
      //XSSFSheet sheet=sheets.getSheet("Sheet1");//根据标签取
      XSSFSheet sheet=sheets.getSheetAt(0);
      //获取行数
      int rows=sheet.getPhysicalNumberOfRows();
      XSSFRow row=sheet.getRow(0);
      int cols=row.getPhysicalNumberOfCells();
      System.out.println("文件多少行:"+rows);
      System.out.println("文件多少列:"+cols);
      for(int i=0;i<rows;i++){
          row=sheet.getRow(i);//取出第一行
          String type=row.getCell(0).toString();
          String info=row.getCell(3).toString();
          System.out.println(type +"--"+info);
      }

HSSF 类型execl

String file="doc/hello.xlsx";
      String realpath=req.getRealPath(file);
      InputStream input=new FileInputStream(realpath);
      System.out.println(realpath);
      System.out.println(input);

      HSSFWorkbook sheets = new HSSFWorkbook(input);
     // XSSFWorkbook sheets=new XSSFWorkbook(input);
      //XSSFSheet sheet=sheets.getSheet("Sheet1");//根据标签取
//      XSSFSheet sheet=sheets.getSheetAt(0);
      HSSFSheet sheet =sheets.getSheetAt(0);

      //获取行数
      int rows=sheet.getPhysicalNumberOfRows();
      HSSFRow row=sheet.getRow(0);
      int cols=row.getPhysicalNumberOfCells();
      System.out.println("文件多少行:"+rows);
      System.out.println("文件多少列:"+cols);
      for(int i=0;i<rows;i++){
          row=sheet.getRow(i);//取出第一行
          String type=row.getCell(0).toString();
          String info=row.getCell(3).toString();
          System.out.println(type +"--"+info);
      }