excel:导入快速版

		<!-- excel导出的包 -->
		<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi</artifactId>
			<version>4.1.1</version>
		</dependency>
		<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi-ooxml</artifactId>
			<version>4.1.1</version>
		</dependency>

代码：

public void getUser() throws Exception {
        //获取文件
        FileInputStream inputStream = new FileInputStream("D:\\excel\\test1.xlsx");
        //Xlsx使用XSSFWorkbook ，需要导上述第二个包，执行报错就把上面两个包都升级版本
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        XSSFSheet sheet1 = workbook.getSheet("Sheet1");//名字注意区分大小写
        //xls使用HSSFWorkbook 
//        HSSFWorkbook wb = new HSSFWorkbook(inputStream);
//        HSSFSheet sheet1 = wb.getSheet("Sheet1");

        //读取数据
        int rows = sheet1.getPhysicalNumberOfRows();
        for(int i = 1 ;i< rows ;i++){//第0行为标题，这里直接从第一行读取
            User user = new User();
//            HSSFRow row = sheet1.getRow(i);//某一行
            XSSFRow row = sheet1.getRow(i);//某一行
            int column = row.getPhysicalNumberOfCells();//获取列
            for(int j = 0;j < column ; j++){
                String cell = row.getCell(j).toString();//获取某一个单元格，单元格是从0开始的
                switch (j){
                    case 0:
                        user.setPsid(cell);
                    break;
                    case 1:
                        user.setUsername(cell);
                        break;
                    case 2:
                        user.setFullName(cell);
                        break;
                    case 4:
                        user.setEmail(cell);
                        break;
                    default:
                        break;
                }
            }
            System.out.println(JSON.toJSONString(user));
            userService.save(user);
        }
    }