Skip to main content

Simple Writing

This chapter introduces how to use FastExcel to perform simple Excel writing operations.

Overview​

Use FastExcel for simple Excel data writing to quickly write entity objects to Excel files. This is the most basic and commonly used writing approach.

Code Examples​

POJO Class​

The DemoData POJO class corresponding to the Excel structure:

@Getter
@Setter
@EqualsAndHashCode
public class DemoData {
    @ExcelProperty("字符串标题")
    private String string;
    @ExcelProperty("日期标题")
    private Date date;
    @ExcelProperty("数字标题")
    private Double doubleData;
    @ExcelIgnore
    private String ignore; // Ignored field
}

Data List​

private List<DemoData> data() {
    List<DemoData> list = ListUtils.newArrayList();
    for (int i = 0; i < 10; i++) {
        DemoData data = new DemoData();
        data.setString("String" + i);
        data.setDate(new Date());
        data.setDoubleData(0.56);
        list.add(data);
    }
    return list;
}

Writing Methods​

FastExcel provides multiple writing methods, including Lambda expressions, data lists, ExcelWriter objects, etc.

Lambda Expression​

@Test
public void simpleWrite() {
    String fileName = "simpleWrite" + System.currentTimeMillis() + ".xlsx";

    FastExcel.write(fileName, DemoData.class)
        .sheet("Sheet1")
        .doWrite(() -> data());
}

Data List​

@Test
public void simpleWrite() {
    String fileName = "simpleWrite" + System.currentTimeMillis() + ".xlsx";

    FastExcel.write(fileName, DemoData.class)
        .sheet("Sheet1")
        .doWrite(data());
}

ExcelWriter Object​

@Test
public void simpleWrite() {
    String fileName = "simpleWrite" + System.currentTimeMillis() + ".xlsx";

    try (ExcelWriter excelWriter = FastExcel.write(fileName, DemoData.class).build()) {
        WriteSheet writeSheet = FastExcel.writerSheet("Sheet1").build();
        excelWriter.write(data(), writeSheet);
    }
}