package com.qianwen.smartman.modules.tool.util;
|
|
import org.apache.poi.ss.usermodel.BorderStyle;
|
import org.apache.poi.ss.usermodel.CellStyle;
|
import org.apache.poi.ss.usermodel.FillPatternType;
|
import org.apache.poi.ss.usermodel.HorizontalAlignment;
|
import org.apache.poi.ss.usermodel.IndexedColors;
|
import org.apache.poi.ss.usermodel.VerticalAlignment;
|
import org.apache.poi.ss.usermodel.Workbook;
|
|
public class CellStyleUtil {
|
public static CellStyle cellStyle(Workbook workbook) {
|
CellStyle cellStyle = workbook.createCellStyle();
|
cellStyle.setAlignment(HorizontalAlignment.LEFT);
|
cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
|
cellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
|
cellStyle.setFillForegroundColor(IndexedColors.WHITE.getIndex());
|
cellStyle.setBorderBottom(BorderStyle.THIN);
|
cellStyle.setBorderLeft(BorderStyle.THIN);
|
cellStyle.setBorderRight(BorderStyle.THIN);
|
cellStyle.setBorderTop(BorderStyle.THIN);
|
return cellStyle;
|
}
|
}
|
