EasyExcel
EasyExcel-排除展示字段
测试实体类
package entry;import com.alibaba.excel.annotation.ExcelProperty;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;import java.util.Date;/*** Created by jdx on 2022/6/17 上午12:10*/
/*相当于实体类中的get set方法*/
@Data
/*相当于有参构造*/
@AllArgsConstructor
/*相当于无参构造*/
@NoArgsConstructor
public class Student {/*@ExcelProperty* 1、详相当于表头定义* 2、实体别名* */@ExcelProperty("姓名")private String name;@ExcelProperty("入学时间")private String admissionATime;@ExcelProperty("性别")private Boolean sex;@ExcelProperty("联系方式")private String contactDetails;@ExcelProperty("班级")private String className;@ExcelProperty("成绩")private String score;@ExcelProperty("邮箱")private String e_mail;
}
测试实例
public void Test03() {/*新建一个存放输出流对象的list*/ArrayList<Student> students = new ArrayList<Student>();/*新建一个Student对象*/Student student01 = new Student("宫本武藏", "2016-03", true, "12345678911", "九年级十一班", "A", "12345612@qq.com");Student student02 = new Student("娜可露露", "2016-03", false, "12345678912", "九年级十一班", "A", "123452336@qq.com");Student student03 = new Student("不知火舞", "2016-03", false, "12345678913", "九年级十一班", "A", "12332e456@qq.com");Student student04 = new Student("橘右京", "2016-03", true, "12345678914", "九年级十一班", "A", "12ew3456@qq.com");Student student05 = new Student("孙悟空", "2016-03", true, "12345678915", "九年级十一班", "A", "12341256@qq.com");Student student06 = new Student("三藏法师", "2016-03", true, "12345678916", "九年级十一班", "A", "123432156@qq.com");Student student07 = new Student("猪八戒", "2016-03", true, "12345678917", "九年级十一班", "A", "12342156@qq.com");Student student08 = new Student("耀", "2016-03", true, "12345678918", "九年级十一班", "A", "12324456@qq.com");Student student09 = new Student("李逍遥", "2016-03", true, "12345678919", "九年级十一班", "A", "123434456@qq.com");Student student10 = new Student("赵琳儿", "2016-03", false, "12345678910", "九年级十一班", "A", "12343456@qq.com");Student student11 = new Student("李白a", "2016-03", true, "12345678922", "九年级十一班", "A", "123343456@qq.com");/*添加数据*/students.add(student01);students.add(student02);students.add(student03);students.add(student04);students.add(student05);students.add(student06);students.add(student07);students.add(student08);students.add(student09);students.add(student10);students.add(student11);/*指定输出对象*/HashSet<String> hashSet = new HashSet<String>();hashSet.add("className");hashSet.add("score");/*excludeColumnFiledNames --> 输出指定字段*/EasyExcel.write("筛选花名册.xlsx",Student.class).excludeColumnFiledNames(hashSet).sheet("筛选花名册").doWrite(students);}
测试结果对比
EasyExcel
EasyExcel-排除展示字段
测试实体类
package entry;import com.alibaba.excel.annotation.ExcelProperty;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;import java.util.Date;/*** Created by jdx on 2022/6/17 上午12:10*/
/*相当于实体类中的get set方法*/
@Data
/*相当于有参构造*/
@AllArgsConstructor
/*相当于无参构造*/
@NoArgsConstructor
public class Student {/*@ExcelProperty* 1、详相当于表头定义* 2、实体别名* */@ExcelProperty("姓名")private String name;@ExcelProperty("入学时间")private String admissionATime;@ExcelProperty("性别")private Boolean sex;@ExcelProperty("联系方式")private String contactDetails;@ExcelProperty("班级")private String className;@ExcelProperty("成绩")private String score;@ExcelProperty("邮箱")private String e_mail;
}
测试实例
public void Test03() {/*新建一个存放输出流对象的list*/ArrayList<Student> students = new ArrayList<Student>();/*新建一个Student对象*/Student student01 = new Student("宫本武藏", "2016-03", true, "12345678911", "九年级十一班", "A", "12345612@qq.com");Student student02 = new Student("娜可露露", "2016-03", false, "12345678912", "九年级十一班", "A", "123452336@qq.com");Student student03 = new Student("不知火舞", "2016-03", false, "12345678913", "九年级十一班", "A", "12332e456@qq.com");Student student04 = new Student("橘右京", "2016-03", true, "12345678914", "九年级十一班", "A", "12ew3456@qq.com");Student student05 = new Student("孙悟空", "2016-03", true, "12345678915", "九年级十一班", "A", "12341256@qq.com");Student student06 = new Student("三藏法师", "2016-03", true, "12345678916", "九年级十一班", "A", "123432156@qq.com");Student student07 = new Student("猪八戒", "2016-03", true, "12345678917", "九年级十一班", "A", "12342156@qq.com");Student student08 = new Student("耀", "2016-03", true, "12345678918", "九年级十一班", "A", "12324456@qq.com");Student student09 = new Student("李逍遥", "2016-03", true, "12345678919", "九年级十一班", "A", "123434456@qq.com");Student student10 = new Student("赵琳儿", "2016-03", false, "12345678910", "九年级十一班", "A", "12343456@qq.com");Student student11 = new Student("李白a", "2016-03", true, "12345678922", "九年级十一班", "A", "123343456@qq.com");/*添加数据*/students.add(student01);students.add(student02);students.add(student03);students.add(student04);students.add(student05);students.add(student06);students.add(student07);students.add(student08);students.add(student09);students.add(student10);students.add(student11);/*指定输出对象*/HashSet<String> hashSet = new HashSet<String>();hashSet.add("className");hashSet.add("score");/*excludeColumnFiledNames --> 输出指定字段*/EasyExcel.write("筛选花名册.xlsx",Student.class).excludeColumnFiledNames(hashSet).sheet("筛选花名册").doWrite(students);}
测试结果对比