easyexcel 设置标题_easyexcel设置单元格格式为文本

导出时注册registerWriteHandler(new RowWriteHandlerImpl())

/**

* @author jamin

* @date 2020/7/29 15:18

*/

public class RowWriteHandlerImpl implements CellWriteHandler {

@Override

public void beforeCellCreate(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, Row row, Head head, Integer integer, Integer integer1, Boolean aBoolean) {

}

@Override

public void afterCellCreate(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, Cell cell, Head head, Integer integer, Boolean aBoolean) {

//设置单元格格式为文本

Workbook workbook = writeSheetHolder.getSheet().getWorkbook();

CellStyle cellStyle = workbook.createCellStyle();

DataFormat dataFormat = workbook.createDataFormat();

cellStyle.setDataFormat(dataFormat.getFormat("@"));

cell.setCe