package com.yuanchu.mom.utils;
|
|
import com.alibaba.excel.write.metadata.style.WriteCellStyle;
|
import com.alibaba.excel.write.metadata.style.WriteFont;
|
import org.apache.poi.ss.usermodel.*;
|
|
public class StyleYearUtils {
|
/**
|
* 标题样式
|
* @return
|
*/
|
public static WriteCellStyle getHeadStyle(){
|
// 头的策略
|
WriteCellStyle headWriteCellStyle = new WriteCellStyle();
|
// 背景颜色
|
headWriteCellStyle.setFillForegroundColor(IndexedColors.GREEN.getIndex());
|
headWriteCellStyle.setFillPatternType(FillPatternType.SOLID_FOREGROUND);
|
|
// 字体
|
WriteFont headWriteFont = new WriteFont();
|
headWriteFont.setFontName("仿宋");//设置字体名字
|
headWriteFont.setFontHeightInPoints((short)9);//设置字体大小
|
headWriteFont.setBold(true);//字体加粗
|
headWriteFont.setColor((short) 1);
|
headWriteCellStyle.setWriteFont(headWriteFont); //在样式用应用设置的字体;
|
|
// 样式
|
headWriteCellStyle.setBorderBottom(BorderStyle.THIN);//设置底边框;
|
headWriteCellStyle.setBottomBorderColor((short) 1);//设置底边框颜色;
|
headWriteCellStyle.setBorderLeft(BorderStyle.THIN); //设置左边框;
|
headWriteCellStyle.setLeftBorderColor((short) 1);//设置左边框颜色;
|
headWriteCellStyle.setBorderRight(BorderStyle.THIN);//设置右边框;
|
headWriteCellStyle.setRightBorderColor((short) 1);//设置右边框颜色;
|
headWriteCellStyle.setBorderTop(BorderStyle.THIN);//设置顶边框;
|
headWriteCellStyle.setTopBorderColor((short) 1); //设置顶边框颜色;
|
|
headWriteCellStyle.setWrapped(false); //设置自动换行;
|
|
headWriteCellStyle.setHorizontalAlignment(HorizontalAlignment.CENTER);//设置水平对齐的样式为居中对齐;
|
headWriteCellStyle.setVerticalAlignment(VerticalAlignment.CENTER); //设置垂直对齐的样式为居中对齐;
|
headWriteCellStyle.setShrinkToFit(true);//设置文本收缩至合适
|
|
return headWriteCellStyle;
|
}
|
|
|
/**
|
* 内容样式
|
* @return
|
*/
|
public static WriteCellStyle getContentStyle(){
|
// 内容的策略
|
WriteCellStyle contentWriteCellStyle = new WriteCellStyle();
|
|
// 这里需要指定 FillPatternType 为FillPatternType.SOLID_FOREGROUND 不然无法显示背景颜色.头默认了 FillPatternType所以可以不指定
|
// contentWriteCellStyle.setFillForegroundColor(IndexedColors.LIGHT_GREEN.getIndex());
|
contentWriteCellStyle.setFillPatternType(FillPatternType.SOLID_FOREGROUND);
|
|
// 设置字体
|
WriteFont contentWriteFont = new WriteFont();
|
contentWriteFont.setFontHeightInPoints((short) 9);//设置字体大小
|
contentWriteFont.setFontName("仿宋"); //设置字体名字
|
contentWriteCellStyle.setWriteFont(contentWriteFont);//在样式用应用设置的字体;
|
|
//设置样式;
|
// contentWriteCellStyle.setBorderBottom(BorderStyle.THIN);//设置底边框;
|
// contentWriteCellStyle.setBottomBorderColor((short) 1);//设置底边框颜色;
|
contentWriteCellStyle.setBorderLeft(BorderStyle.THIN); //设置左边框;
|
contentWriteCellStyle.setLeftBorderColor((short) 1);//设置左边框颜色;
|
contentWriteCellStyle.setBorderRight(BorderStyle.THIN);//设置右边框;
|
contentWriteCellStyle.setRightBorderColor((short) 1);//设置右边框颜色;
|
contentWriteCellStyle.setBorderTop(BorderStyle.THIN);//设置顶边框;
|
contentWriteCellStyle.setTopBorderColor((short) 1); ///设置顶边框颜色;
|
|
contentWriteCellStyle.setHorizontalAlignment(HorizontalAlignment.CENTER);// 水平居中
|
contentWriteCellStyle.setVerticalAlignment(VerticalAlignment.CENTER);// 垂直居中
|
contentWriteCellStyle.setWrapped(false); //设置自动换行;
|
|
// contentWriteCellStyle.setShrinkToFit(true);//设置文本收缩至合适
|
|
return contentWriteCellStyle;
|
}
|
}
|
