导入xlsx文件

@PostMapping(“/importExcel”)
@ApiOperation(value = “用户导入”,notes = “导入创客数据,手机号不重复”)
// @Transactional(rollbackFor = Exception.class)
public Result importUser(MultipartFile file)
{

    try {
        // 创建文件输入流
        InputStream inputStream = file.getInputStream();
        // 创建工作簿对象
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        // 获取第一个工作表
        XSSFSheet sheet = workbook.getSheetAt(0);
        if(sheet != null)
        {
         
            // 遍历工作表的每一行
            for (int row = 1; row < sheet.getPhysicalNumberOfRows(); row++) 
            {
                XSSFRow currentRow = sheet.getRow(row);
                  /**遍历每列*/
                    for (int cell = 1; cell < currentRow.getPhysicalNumberOfCells(); cell++)
                    {  
                        XSSFCell cellValue = sheet.getRow(row).getCell(cell);
                    	                            System.out.println("输出值"+cellValue );
                    }
              
            }

        }

        // 关闭工作簿和文件输入流
        workbook.close();
        inputStream.close();
    } catch (IOException e) {
        e.printStackTrace();
    }
 

    return Result.OK();
}