fact-excel

<dependency>

<groupId>com.woter.fact</groupId>

<artifactId>fact-excel</artifactId>

<version>1.0.0-SNAPSHOT</version>

</dependency>

public class User {
    
    private String name;
    
    private Integer age;
    
    private Date brithday;

    public String getName() {
        return name;
    }
    
    public void setName(String name) {
        this.name = name;
    }

    public Integer getAge() {
        return age;
    }
    
    public void setAge(Integer age) {
        this.age = age;
    }

    public Date getBrithday() {
        return brithday;
    }

    public void setBrithday(Date brithday) {
        this.brithday = brithday;
    }
 
}

@Controller
@RequestMapping("/demo")
public void DemoController{
    
    @RequestMapping("/export")
    public void exportExcel(HttpServletResponse response){
        
        List<User> userList = userService.selectSignaturePagingListByParam(userSearchParam);
        
        List<ExcelField<?>> fieldList = Lists.newArrayList();
        fieldList.add(new ExcelField<String>("姓名", "name"));
        fieldList.add(new ExcelField<Integer>("年龄", "age"));
        fieldList.add(new ExcelField<Object>("生日",FieldTranslationFacade.dateFieldTranslation("brithday")));
        try {
            ExcelOperationFacade.exportExcel("用户列表", fieldList, (List<?>) userList, response, "用户列表");
        } catch (Exception e) {
            logger.error("导出用户列表异常",e);
        }
    }

}