easypoi导入校验跳过空行_EasyPoi导入验证功能

@Controller

@RequestMapping("/import")

public class ImportController extends BaseController {

@Autowired

private IEmployeeService employeeService;

@Autowired

private IDepartmentService departmentService;

@Autowired

private EmployeeExcelVerifyHandler employeeExcelVerifyHandler;

@RequestMapping("/index")

public String index(){

return "import";

}

@RequestMapping("/employeeXlsx")

public String employeeXlsx(MultipartFile empFile, HttpServletResponse response) throws Exception {

//一.使用EasyPoi获取文件数据

ImportParams params = new ImportParams();

params.setHeadRows(1);

params.setNeedVerfiy(true); //设置验证支持

params.setVerifyHandler(employeeExcelVerifyHandler); //设置一个验证处理器

//二.获取excel中的数据，封装成了一个结果对