easyexcel | 快速、简单避免OOM的java处理Excel工具 | Data Visualization library

public class AppStarter {

    public static void main(String[] args) {
        SparkUserExcelRequest request = new SparkUserExcelRequest();
        request.setNickname("test");
        String writePathName = "/Users/dolphin/source/dabai/microservice/soa-zhuolian-org/";
        String fullPathName = writePathName  + "a.xlsx";
        if (!new File(writePathName).exists()) {
            new File(writePathName).mkdirs();
        }
        ExcelWriterBuilder writerBuilder = EasyExcel.write(fullPathName, SparkUserExcelRequest.class);
        writerBuilder.excelType(ExcelTypeEnum.XLSX);
        writerBuilder.registerWriteHandler(new CellStyleWriteHandler());
        ExcelWriter writer = writerBuilder.build();
        WriteSheet writeSheet = new WriteSheet();
        writeSheet.setSheetName("mark");
        writer.write(Arrays.asList(request), writeSheet);
        writer.finish();
    }
}

public class CellStyleWriteHandler extends AbstractCellStyleStrategy {

    @Override
    protected void setContentCellStyle(Cell cell, Head head, Integer relativeRowIndex) {
        Workbook workbook = cell.getSheet().getWorkbook();
        CellStyle cellStyle = workbook.createCellStyle();
        cellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
        cellStyle.setFillForegroundColor(IndexedColors.LIGHT_BLUE.getIndex());
        cell.setCellStyle(cellStyle);
    }
}

@Data
@ExcelIgnoreUnannotated
public class SparkUserExcelRequest implements Serializable {

    @ExcelProperty("user name")
    private String nickname;
}