EasyExcel--基础--4.1--写Excel--简单写

EasyExcel–基础–4.1–写Excel–简单写

---

代码位置

https://gitee.com/DanShenGuiZu/learnDemo/tree/master/easyExcel_learn

---

1、简单–写Excel

1.1、代码结构

1.2、代码

Student

package fei.zhou.easyexcel_learn.business.demo2;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.util.Date;


@Data
@NoArgsConstructor
@AllArgsConstructor
public class Student {


    /**
     * 忽略 id 字段，也就是说id不会写到excel
     */
    @ExcelIgnore
    private String id;
    /**
     * 设置 excel 第1列名称 为 学生姓名
     * 让 name 字段 和 excel 第1列 形成映射关系
     */
    @ExcelProperty(value = "学生姓名", index = 0)
    @ColumnWidth(30)//设置列宽度
    private String name;

    /**
     * 学生出生日期
     */
    @ExcelProperty(value = "学生出生日期", index = 1)
    private Date birthday;

    /**
     * 学生性别，
     */
    @ExcelProperty(value = "学生性别", index = 2)
    private String gender;


}

Test

package fei.zhou.easyexcel_learn.business.demo2;


import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.read.builder.ExcelReaderBuilder;
import com.alibaba.excel.read.builder.ExcelReaderSheetBuilder;
import com.alibaba.excel.write.builder.ExcelWriterBuilder;

import java.io.FileNotFoundException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class Test {


    public static void main(String[] args) throws FileNotFoundException {


        List<Student> students = initData();
        /*
            String pathName 写入文件的路径
            Class head      写入文件的对象类型
            默认写入到07的xlsx中，如果想要写入xls，可以指定类型
         */
        String filePath = "D:\\java\\workSpace-learn\\learnDemo\\easyExcel_learn\\src\\main\\java\\fei\\zhou\\easyexcel_learn\\business\\demo2\\02.xlsx";
        ExcelWriterBuilder workBook = EasyExcel.write(filePath, Student.class);

        // sheet方法参数： 工作表的顺序号（从0开始）或者工作表的名字
        workBook.sheet().doWrite(students);
    }

    private static List<Student> initData() {
        ArrayList<Student> students = new ArrayList<>();
        for (int i = 0; i < 5; i++) {
            Student data = new Student();
            data.setName("李四" + i);
            data.setBirthday(new Date());
            data.setGender("男");
            students.add(data);
        }
        return students;
    }
}

1.3、测试