通过反射进行excel导入数据，无论实体类属性多少都可使用

本文章都是自创，如有类同纯属巧合，转发的朋友请写我的文章链接

excel的导入

1.接收方法

	@RequestMapping("imp")
    @ResponseBody
    public Result imp(MultipartFile file) throws IOException, InvalidFormatException, ParseException, NoSuchMethodException, IllegalAccessException, InvocationTargetException {
   	//接受file
        /*HSSFWorkbook workbook = new HSSFWorkbook(file.getInputStream());*/
        Workbook workbook = WorkbookFactory.create(file.getInputStream());//创建workbook
        Sheet sheet = workbook.getSheetAt(0);	//创建sheet
       	List<User> users = importData(sheet);  //将导入的具体操作独立成一个方法
		UserService.imp(users);//调用方法向数据库存储
        return result();
}

2. 写一个excel对应实体属性的list

//list为头一个字母大写的属性名
private ArrayList<String> list = new ArrayList<String>(Arrays.asList(
            "Name","Sex","ShenGao","TiZhong","Dept"
    ));

3.写将excel信息转换成实体类的方法

//导入的具体方法
private List<User> importData(Sheet sheet) throws ParseException, NoSuchMethodException, IllegalAccessException, InvocationTargetException {
   
        List<User> user= new ArrayList<>();
        int lastRowNum = sheet.getLastRowNum(); //excel的条数
        for (int i = 0; i < lastRowNum; i++) {
   
            User user= new User();	 //导入的实体类
            Field[] fields = user.getClass().getDeclaredFields(); //通过反射获取field数组
            Map<String, Integer> map = new HashMap<<