hutool 自定义excel_利用Hutool工具类下载Excel

`

cn.hutool

hutool-all

5.3.5

org.apache.poi

poi-ooxml

4.1.1

`

`

package com.yoyo.excel.vo;

import cn.hutool.core.annotation.Alias;

import java.io.Serializable;

public class StudentVo implements Serializable {

/**

* @Alias("")

* 此注解为hutool用注解，效果是生成表头

* 但是请注意！

* 此注解于ExcelWriter.addHeaderAlias("sex", "性别 ");冲突只能选用其一

*/

private String name;

/**

* @Alias("年龄")

*/

private Integer age;

private String sex;

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 String getSex() {

return sex;

}

public void setSex(String sex) {

this.sex = sex;

}

@Override

/**

* 为了测试效果，线上可以不加

*/

public String toString() {

return "StudentVo{" +

"name='" + name + '\'' +

", age=" + age +

", sex='" + sex + '\'' +

'}';

}

/**

* 下面全部为建造者模式代码

* @param builder

*/

public StudentVo(Builder builder) {

this.name = builder.name;

this.age = builder.age;

this.sex = builder.sex;

}

public static Builder newBuilder () {

return new Builder();

}

public static final class Builder {

private String name;

private Integer age;

private String sex;

private Builder() {

}

public Builder name(String val) {

this.name = val;

return this;

}

public Builder age(Integer val) {

this.age = val;

return this;

}

public Builder sex(String val) {

this.sex = val;

return this;

}

publi