通过反射excel导出，无论属性到少都可以，导出名可自定义

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

1.先写一个跟导出excel对应的字段的list

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

2.导出的方法

@RequestMapping(value = "export",method = RequestMethod.GET)
    public void export(HttpServletRequest request, HttpServletResponse response) throws IOException, InvalidFormatException, ParseException, NoSuchMethodException, InvocationTargetException, IllegalAccessException {
   
        String name= request.getParameter("name");
        User user= new user();
        if (StringUtils.isNotEmpty(name)) {
   
            user.setName(name);
        }
        List<User> users= userService.selectUserAll(name);//条件查询
        XSSFWorkbook excelbook = new XSSFWorkbook(); //创建workBook
        XSSFSheet excelSheet = excelbook.createSheet();//创建sheet表
        createExcelHeader(excelbook,excelSheet);
        XSSFCellStyle headerStyle = excelbook.createCellStyle();//设置 居中
        headerStyle.setAlignment(XSSFCellStyle.ALIGN_LEFT);

        for (int i = 0; i < users.size(); i++) {
   
            XSSFRow row = excelSheet.createRow(i+1);//创建行
            User user= Users.get(i);
            Field[] declaredFields = user.getClass().getDeclaredFields()