Java Code Examples for org.apache.poi.ss.usermodel.CellStyle#setBorderLeft()
The following examples show how to use
org.apache.poi.ss.usermodel.CellStyle#setBorderLeft() .
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
| Source File: UKExcelUtil.java From youkefu with Apache License 2.0 | 8 votes |
|
@SuppressWarnings("deprecation")
private CellStyle baseCellStyle(){
CellStyle cellStyle = wb.createCellStyle();
cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
cellStyle.setWrapText(true);
cellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);
cellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
cellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);
cellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);
Font font = wb.createFont();
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
font.setFontName("宋体");
font.setFontHeight((short) 200);
cellStyle.setFont(font);
return cellStyle;
}
Example 2
| Source File: ExportTimetableXLS.java From unitime with Apache License 2.0 | 6 votes |
|
protected CellStyle getGridNameStyle(P p) {
String styleId = "grid-name";
CellStyle style = iStyles.get(styleId);
if (style == null) {
style = iWorkbook.createCellStyle();
style.setBorderLeft(BorderStyle.THIN);
style.setLeftBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
style.setBorderTop(BorderStyle.THIN);
style.setTopBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
style.setFont(getFont(p));
style.setAlignment(HorizontalAlignment.CENTER);
style.setVerticalAlignment(VerticalAlignment.TOP);
style.setWrapText(true);
iStyles.put(styleId, style);
}
return style;
}
Example 3
| Source File: StyleConfiguration.java From excel-rw-annotation with Apache License 2.0 | 6 votes |
|
/**
* 设置通用的对齐居中、边框等
*
* @param style 样式
*/
private void setCommonStyle(CellStyle style) {
// 设置单元格居中对齐、自动换行
style.setAlignment(CellStyle.ALIGN_CENTER);
style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
style.setWrapText(true);
//设置单元格字体
if (!buildInFontMap.containsKey(FONT_KEY)) {
Font font = workbook.createFont();
//通用字体
font.setBoldweight(Font.BOLDWEIGHT_BOLD);
font.setFontName("宋体");
font.setFontHeight((short) 200);
buildInFontMap.put(FONT_KEY, font);
}
style.setFont(buildInFontMap.get(FONT_KEY));
// 设置单元格边框为细线条
style.setBorderLeft(CellStyle.BORDER_THIN);
style.setBorderBottom(CellStyle.BORDER_THIN);
style.setBorderRight(CellStyle.BORDER_THIN);
style.setBorderTop(CellStyle.BORDER_THIN);
}
Example 4
| Source File: ExcelExportStylerColorImpl.java From easypoi with Apache License 2.0 | 6 votes |
|
@Override
public CellStyle stringSeptailStyle(Workbook workbook, boolean isWarp) {
CellStyle style = workbook.createCellStyle();
style.setBorderLeft((short) 1); // 左边框
style.setBorderRight((short) 1); // 右边框
style.setBorderBottom((short) 1);
style.setBorderTop((short) 1);
style.setFillForegroundColor((short) 41); // 填充的背景颜色
style.setFillPattern(CellStyle.SOLID_FOREGROUND); // 填充图案
style.setAlignment(CellStyle.ALIGN_CENTER);
style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
style.setDataFormat(STRING_FORMAT);
if (isWarp) {
style.setWrapText(true);
}
return style;
}
Example 5
| Source File: ExportTimetableXLS.java From unitime with Apache License 2.0 | 6 votes |
|
protected CellStyle getHeaderIntervalStyle(P p) {
String styleId = "header-interval";
CellStyle style = iStyles.get(styleId);
if (style == null) {
style = iWorkbook.createCellStyle();
style.setBorderLeft(BorderStyle.THIN);
style.setLeftBorderColor(IndexedColors.GREY_80_PERCENT.getIndex());
style.setBorderTop(BorderStyle.THIN);
style.setTopBorderColor(IndexedColors.GREY_80_PERCENT.getIndex());
if (p.getWidth() == 1) {
style.setBorderRight(BorderStyle.THIN);
style.setRightBorderColor(IndexedColors.GREY_80_PERCENT.getIndex());
}
style.setFont(getFont(p));
style.setAlignment(HorizontalAlignment.CENTER);
style.setVerticalAlignment(VerticalAlignment.TOP);
style.setWrapText(true);
iStyles.put(styleId, style);
}
return style;
}
Example 6
| Source File: WorkbookContext.java From Octopus with MIT License | 6 votes |
|
private void setStyleBorder(CellStyle style, BorderStyle[] border) {
if (border != null) {
if (border[0] != null) {
style.setBorderTop(border[0]);
}
if (border[1] != null) {
style.setBorderRight(border[1]);
}
if (border[2] != null) {
style.setBorderBottom(border[2]);
}
if (border[3] != null) {
style.setBorderLeft(border[3]);
}
}
}
Example 7
| Source File: CrosstabXLSExporter.java From Knowage-Server with GNU Affero General Public License v3.0 | 5 votes |
|
public CellStyle buildDimensionCellStyle(Sheet sheet) {
CellStyle cellStyle = sheet.getWorkbook().createCellStyle();
cellStyle.setAlignment(CellStyle.ALIGN_CENTER);
cellStyle.setVerticalAlignment(CellStyle.ALIGN_CENTER);
String headerBGColor = (String) this.getProperty(PROPERTY_DIMENSION_NAME_BACKGROUND_COLOR);
logger.debug("Header background color : " + headerBGColor);
short backgroundColorIndex = headerBGColor != null ? IndexedColors.valueOf(headerBGColor).getIndex() : IndexedColors.valueOf(
DEFAULT_DIMENSION_NAME_BACKGROUND_COLOR).getIndex();
cellStyle.setFillForegroundColor(backgroundColorIndex);
cellStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
cellStyle.setBorderBottom(CellStyle.BORDER_THIN);
cellStyle.setBorderLeft(CellStyle.BORDER_THIN);
cellStyle.setBorderRight(CellStyle.BORDER_THIN);
cellStyle.setBorderTop(CellStyle.BORDER_THIN);
String bordeBorderColor = (String) this.getProperty(PROPERTY_HEADER_BORDER_COLOR);
logger.debug("Header border color : " + bordeBorderColor);
short borderColorIndex = bordeBorderColor != null ? IndexedColors.valueOf(bordeBorderColor).getIndex() : IndexedColors.valueOf(
DEFAULT_HEADER_BORDER_COLOR).getIndex();
cellStyle.setLeftBorderColor(borderColorIndex);
cellStyle.setRightBorderColor(borderColorIndex);
cellStyle.setBottomBorderColor(borderColorIndex);
cellStyle.setTopBorderColor(borderColorIndex);
Font font = sheet.getWorkbook().createFont();
Short headerFontSize = (Short) this.getProperty(PROPERTY_HEADER_FONT_SIZE);
logger.debug("Header font size : " + headerFontSize);
short headerFontSizeShort = headerFontSize != null ? headerFontSize.shortValue() : DEFAULT_HEADER_FONT_SIZE;
font.setFontHeightInPoints(headerFontSizeShort);
String fontName = (String) this.getProperty(PROPERTY_FONT_NAME);
logger.debug("Font name : " + fontName);
fontName = fontName != null ? fontName : DEFAULT_FONT_NAME;
font.setFontName(fontName);
String color = (String) this.getProperty(PROPERTY_DIMENSION_NAME_COLOR);
logger.debug("Dimension color : " + color);
short colorIndex = bordeBorderColor != null ? IndexedColors.valueOf(color).getIndex() : IndexedColors.valueOf(DEFAULT_DIMENSION_NAME_COLOR).getIndex();
font.setColor(colorIndex);
font.setBoldweight(Font.BOLDWEIGHT_BOLD);
font.setItalic(true);
cellStyle.setFont(font);
return cellStyle;
}
Example 8
| Source File: StyleUtil.java From easyexcel with Apache License 2.0 | 5 votes |
|
/**
* @param workbook
* @return
*/
public static CellStyle buildDefaultCellStyle(Workbook workbook) {
CellStyle newCellStyle = workbook.createCellStyle();
newCellStyle.setWrapText(true);
newCellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
newCellStyle.setAlignment(HorizontalAlignment.CENTER);
newCellStyle.setLocked(true);
newCellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
newCellStyle.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex());
newCellStyle.setBorderTop(BorderStyle.THIN);
newCellStyle.setBorderBottom(BorderStyle.THIN);
newCellStyle.setBorderLeft(BorderStyle.THIN);
newCellStyle.setBorderRight(BorderStyle.THIN);
return newCellStyle;
}
Example 9
| Source File: ExcelExportStylerBorderImpl.java From easypoi with Apache License 2.0 | 5 votes |
|
@Override
public CellStyle getHeaderStyle(short color) {
CellStyle titleStyle = workbook.createCellStyle();
Font font = workbook.createFont();
font.setFontHeightInPoints((short) 12);
titleStyle.setFont(font);
titleStyle.setBorderLeft((short) 1); // 左边框
titleStyle.setBorderRight((short) 1); // 右边框
titleStyle.setBorderBottom((short) 1);
titleStyle.setBorderTop((short) 1);
titleStyle.setAlignment(CellStyle.ALIGN_CENTER);
titleStyle.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
return titleStyle;
}
Example 10
| Source File: ExportTimetableXLS.java From unitime with Apache License 2.0 | 5 votes |
|
protected CellStyle getMeetingHeaderStyle(P p, P parent, Color bgColor) {
if (bgColor == null) bgColor = Color.WHITE;
String styleId = "meeting-header-" + Integer.toHexString(bgColor.getRGB()) + (p.iItalics ? "-italics" : "");
CellStyle style = iStyles.get(styleId);
if (style == null) {
style = iWorkbook.createCellStyle();
style.setBorderTop(BorderStyle.THICK);
style.setTopBorderColor(IndexedColors.BLACK.getIndex());
style.setBorderLeft(BorderStyle.THICK);
style.setLeftBorderColor(IndexedColors.BLACK.getIndex());
style.setBorderRight(BorderStyle.THICK);
style.setRightBorderColor(IndexedColors.BLACK.getIndex());
style.setAlignment(HorizontalAlignment.CENTER);
style.setVerticalAlignment(VerticalAlignment.TOP);
style.setFont(getFont(parent));
String colorId = Integer.toHexString(bgColor.getRGB());
Short color = iColors.get(colorId);
if (color == null) {
HSSFPalette palette = ((HSSFWorkbook)iWorkbook).getCustomPalette();
HSSFColor clr = palette.findSimilarColor(bgColor.getRed(), bgColor.getGreen(), bgColor.getBlue());
color = (clr == null ? IndexedColors.BLACK.getIndex() : clr.getIndex());
iColors.put(colorId, color);
}
style.setFillForegroundColor(color);
style.setFillPattern(FillPatternType.SOLID_FOREGROUND);
style.setWrapText(true);
iStyles.put(styleId, style);
}
return style;
}
Example 11
| Source File: ExcelExportStylerBorderImpl.java From autopoi with Apache License 2.0 | 5 votes |
|
@Override
public CellStyle stringNoneStyle(Workbook workbook, boolean isWarp) {
CellStyle style = workbook.createCellStyle();
style.setBorderLeft((short) 1); // 左边框
style.setBorderRight((short) 1); // 右边框
style.setBorderBottom((short) 1);
style.setBorderTop((short) 1);
style.setAlignment(CellStyle.ALIGN_CENTER);
style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
style.setDataFormat(STRING_FORMAT);
if (isWarp) {
style.setWrapText(true);
}
return style;
}
Example 12
| Source File: ExcelExportStylerBorderImpl.java From autopoi with Apache License 2.0 | 5 votes |
|
@Override
public CellStyle getHeaderStyle(short color) {
CellStyle titleStyle = workbook.createCellStyle();
Font font = workbook.createFont();
font.setFontHeightInPoints((short) 12);
titleStyle.setFont(font);
titleStyle.setBorderLeft((short) 1); // 左边框
titleStyle.setBorderRight((short) 1); // 右边框
titleStyle.setBorderBottom((short) 1);
titleStyle.setBorderTop((short) 1);
titleStyle.setAlignment(CellStyle.ALIGN_CENTER);
titleStyle.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
return titleStyle;
}
Example 13
| Source File: AbstractStyleBuilder.java From bdf3 with Apache License 2.0 | 5 votes |
|
public CellStyle createBorderCellStyle(Workbook workbook, boolean showBorder) {
CellStyle style = workbook.createCellStyle();
if (showBorder) {
style.setBorderRight(CellStyle.BORDER_THIN);
style.setRightBorderColor(IndexedColors.BLACK.getIndex());
style.setBorderBottom(CellStyle.BORDER_THIN);
style.setBottomBorderColor(IndexedColors.BLACK.getIndex());
style.setBorderLeft(CellStyle.BORDER_THIN);
style.setLeftBorderColor(IndexedColors.BLACK.getIndex());
style.setBorderTop(CellStyle.BORDER_THIN);
style.setTopBorderColor(IndexedColors.BLACK.getIndex());
}
return style;
}
Example 14
| Source File: ExcelExportStylerBorderImpl.java From easypoi with Apache License 2.0 | 5 votes |
|
@Override
public CellStyle stringNoneStyle(Workbook workbook, boolean isWarp) {
CellStyle style = workbook.createCellStyle();
style.setBorderLeft((short) 1); // 左边框
style.setBorderRight((short) 1); // 右边框
style.setBorderBottom((short) 1);
style.setBorderTop((short) 1);
style.setAlignment(CellStyle.ALIGN_CENTER);
style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
style.setDataFormat(STRING_FORMAT);
if (isWarp) {
style.setWrapText(true);
}
return style;
}
Example 15
| Source File: XLSXWriter.java From org.hl7.fhir.core with Apache License 2.0 | 5 votes |
|
private static CellStyle createBorderedStyle(Workbook wb){
BorderStyle thin = BorderStyle.THIN;
short black = IndexedColors.GREY_50_PERCENT.getIndex();
CellStyle style = wb.createCellStyle();
style.setBorderRight(thin);
style.setRightBorderColor(black);
style.setBorderBottom(thin);
style.setBottomBorderColor(black);
style.setBorderLeft(thin);
style.setLeftBorderColor(black);
style.setBorderTop(thin);
style.setTopBorderColor(black);
return style;
}
Example 16
| Source File: XLSXWriter.java From org.hl7.fhir.core with Apache License 2.0 | 5 votes |
|
private static CellStyle createBorderedStyle(Workbook wb){
BorderStyle thin = BorderStyle.THIN;
short black = IndexedColors.GREY_50_PERCENT.getIndex();
CellStyle style = wb.createCellStyle();
style.setBorderRight(thin);
style.setRightBorderColor(black);
style.setBorderBottom(thin);
style.setBottomBorderColor(black);
style.setBorderLeft(thin);
style.setLeftBorderColor(black);
style.setBorderTop(thin);
style.setTopBorderColor(black);
return style;
}
Example 17
| Source File: ExportTimetableXLS.java From unitime with Apache License 2.0 | 5 votes |
|
protected CellStyle getMeetingFooterStyle(P p, P parent, Color bgColor) {
if (bgColor == null) bgColor = Color.WHITE;
String styleId = "meeting-footer-" + Integer.toHexString(bgColor.getRGB());
CellStyle style = iStyles.get(styleId);
if (style == null) {
style = iWorkbook.createCellStyle();
style.setBorderBottom(BorderStyle.THICK);
style.setBottomBorderColor(IndexedColors.BLACK.getIndex());
style.setBorderLeft(BorderStyle.THICK);
style.setLeftBorderColor(IndexedColors.BLACK.getIndex());
style.setBorderRight(BorderStyle.THICK);
style.setRightBorderColor(IndexedColors.BLACK.getIndex());
style.setAlignment(HorizontalAlignment.CENTER);
style.setVerticalAlignment(VerticalAlignment.TOP);
style.setFont(getFont(parent));
String colorId = Integer.toHexString(bgColor.getRGB());
Short color = iColors.get(colorId);
if (color == null) {
HSSFPalette palette = ((HSSFWorkbook)iWorkbook).getCustomPalette();
HSSFColor clr = palette.findSimilarColor(bgColor.getRed(), bgColor.getGreen(), bgColor.getBlue());
color = (clr == null ? IndexedColors.WHITE.getIndex() : clr.getIndex());
iColors.put(colorId, color);
}
style.setFillForegroundColor(color);
style.setFillPattern(FillPatternType.SOLID_FOREGROUND);
style.setWrapText(true);
iStyles.put(styleId, style);
}
return style;
}
Example 18
| Source File: ThDefaultCellStyle.java From myexcel with Apache License 2.0 | 5 votes |
|
@Override
public CellStyle supply(Workbook workbook) {
CellStyle style = workbook.createCellStyle();
style.setAlignment(HorizontalAlignment.CENTER);
style.setVerticalAlignment(VerticalAlignment.CENTER);
style.setBorderBottom(BorderStyle.THIN);
style.setBorderRight(BorderStyle.THIN);
style.setBorderTop(BorderStyle.THIN);
style.setBorderLeft(BorderStyle.THIN);
Font font = workbook.createFont();
font.setBold(true);
style.setFont(font);
return style;
}
Example 19
| Source File: CrosstabXLSExporter.java From Knowage-Server with GNU Affero General Public License v3.0 | 4 votes |
|
public CellStyle buildHeaderCellStyle(Sheet sheet) {
CellStyle cellStyle = sheet.getWorkbook().createCellStyle();
cellStyle.setAlignment(CellStyle.ALIGN_LEFT);
cellStyle.setVerticalAlignment(CellStyle.ALIGN_CENTER);
String headerBGColor = (String) this.getProperty(PROPERTY_HEADER_BACKGROUND_COLOR);
logger.debug("Header background color : " + headerBGColor);
short backgroundColorIndex = headerBGColor != null ? IndexedColors.valueOf(headerBGColor).getIndex() : IndexedColors.valueOf(
DEFAULT_HEADER_BACKGROUND_COLOR).getIndex();
cellStyle.setFillForegroundColor(backgroundColorIndex);
cellStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
cellStyle.setBorderBottom(CellStyle.BORDER_THIN);
cellStyle.setBorderLeft(CellStyle.BORDER_THIN);
cellStyle.setBorderRight(CellStyle.BORDER_THIN);
cellStyle.setBorderTop(CellStyle.BORDER_THIN);
String bordeBorderColor = (String) this.getProperty(PROPERTY_HEADER_BORDER_COLOR);
logger.debug("Header border color : " + bordeBorderColor);
short borderColorIndex = bordeBorderColor != null ? IndexedColors.valueOf(bordeBorderColor).getIndex() : IndexedColors.valueOf(
DEFAULT_HEADER_BORDER_COLOR).getIndex();
cellStyle.setLeftBorderColor(borderColorIndex);
cellStyle.setRightBorderColor(borderColorIndex);
cellStyle.setBottomBorderColor(borderColorIndex);
cellStyle.setTopBorderColor(borderColorIndex);
Font font = sheet.getWorkbook().createFont();
Short headerFontSize = (Short) this.getProperty(PROPERTY_HEADER_FONT_SIZE);
logger.debug("Header font size : " + headerFontSize);
short headerFontSizeShort = headerFontSize != null ? headerFontSize.shortValue() : DEFAULT_HEADER_FONT_SIZE;
font.setFontHeightInPoints(headerFontSizeShort);
String fontName = (String) this.getProperty(PROPERTY_FONT_NAME);
logger.debug("Font name : " + fontName);
fontName = fontName != null ? fontName : DEFAULT_FONT_NAME;
font.setFontName(fontName);
String headerColor = (String) this.getProperty(PROPERTY_HEADER_COLOR);
logger.debug("Header color : " + headerColor);
short headerColorIndex = bordeBorderColor != null ? IndexedColors.valueOf(headerColor).getIndex() : IndexedColors.valueOf(DEFAULT_HEADER_COLOR)
.getIndex();
font.setColor(headerColorIndex);
font.setBoldweight(Font.BOLDWEIGHT_BOLD);
cellStyle.setFont(font);
return cellStyle;
}
Example 20
| Source File: QbeXLSExporter.java From Knowage-Server with GNU Affero General Public License v3.0 | 4 votes |
|
public CellStyle buildCellStyle(Sheet sheet) {
CellStyle cellStyle = sheet.getWorkbook().createCellStyle();
cellStyle.setAlignment(CellStyle.ALIGN_RIGHT);
cellStyle.setVerticalAlignment(CellStyle.ALIGN_CENTER);
String cellBGColor = (String) this.getProperty(PROPERTY_CELL_BACKGROUND_COLOR);
logger.debug("Cell background color : " + cellBGColor);
short backgroundColorIndex = cellBGColor != null ? IndexedColors.valueOf(cellBGColor).getIndex()
: IndexedColors.valueOf(DEFAULT_CELL_BACKGROUND_COLOR).getIndex();
cellStyle.setFillForegroundColor(backgroundColorIndex);
cellStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
cellStyle.setBorderBottom(CellStyle.BORDER_THIN);
cellStyle.setBorderLeft(CellStyle.BORDER_THIN);
cellStyle.setBorderRight(CellStyle.BORDER_THIN);
cellStyle.setBorderTop(CellStyle.BORDER_THIN);
String bordeBorderColor = (String) this.getProperty(PROPERTY_CELL_BORDER_COLOR);
logger.debug("Cell border color : " + bordeBorderColor);
short borderColorIndex = bordeBorderColor != null ? IndexedColors.valueOf(bordeBorderColor).getIndex()
: IndexedColors.valueOf(DEFAULT_CELL_BORDER_COLOR).getIndex();
cellStyle.setLeftBorderColor(borderColorIndex);
cellStyle.setRightBorderColor(borderColorIndex);
cellStyle.setBottomBorderColor(borderColorIndex);
cellStyle.setTopBorderColor(borderColorIndex);
Font font = sheet.getWorkbook().createFont();
Short cellFontSize = (Short) this.getProperty(PROPERTY_CELL_FONT_SIZE);
logger.debug("Cell font size : " + cellFontSize);
short cellFontSizeShort = cellFontSize != null ? cellFontSize.shortValue() : DEFAULT_CELL_FONT_SIZE;
font.setFontHeightInPoints(cellFontSizeShort);
String fontName = (String) this.getProperty(PROPERTY_FONT_NAME);
logger.debug("Font name : " + fontName);
fontName = fontName != null ? fontName : DEFAULT_FONT_NAME;
font.setFontName(fontName);
String cellColor = (String) this.getProperty(PROPERTY_CELL_COLOR);
logger.debug("Cell color : " + cellColor);
short cellColorIndex = cellColor != null ? IndexedColors.valueOf(cellColor).getIndex() : IndexedColors.valueOf(DEFAULT_CELL_COLOR).getIndex();
font.setColor(cellColorIndex);
cellStyle.setFont(font);
return cellStyle;
}
