easyexcel 导出设置标题_EasyPoi设置Excel导出样式(边框,背景色,字体)

**导出样式如下图**

**使用方式**

创建一个样式工具类、工具类如下:

import cn.afterturn.easypoi.excel.entity.params.ExcelExportEntity;

import cn.afterturn.easypoi.excel.entity.params.ExcelForEachParams;

import cn.afterturn.easypoi.excel.export.styler.IExcelExportStyler;

import org.apache.poi.ss.usermodel.*;

/**

* @author wxlbobo

* @date 2018/9/12

*/

public class ExcelStyleUtil implements IExcelExportStyler {

private static final short STRING_FORMAT = (short) BuiltinFormats.getBuiltinFormat("TEXT");

private static final short FONT_SIZE_TEN = 10;

private static final short FONT_SIZE_ELEVEN = 11;

private static final short FONT_SIZE_TWELVE = 12;

/**

* 大标题样式

*/

private CellStyle headerStyle;

/**

* 每列标题样式

*