/** * Set the color to use for the bottom border * @param color the index of the color definition * @see org.apache.poi.ss.usermodel.IndexedColors */ @Override public void setBottomBorderColor(short color) { XSSFColor clr = XSSFColor.from(CTColor.Factory.newInstance(), _stylesSource.getIndexedColors()); clr.setIndexed(color); setBottomBorderColor(clr); }
/** * Set the color to use for the selected border * * @param side - where to apply the color definition * @param color - the color to use */ public void setBorderColor(BorderSide side, XSSFColor color) { switch(side){ case BOTTOM: setBottomBorderColor(color); break; case RIGHT: setRightBorderColor(color); break; case TOP: setTopBorderColor(color); break; case LEFT: setLeftBorderColor(color); break; } }
XSSFCellStyle cellStyle = workbook.createCellStyle(); XSSFColor color = new XSSFColor(new java.awt.Color(128, 0, 128)); cellStyle.setBorderColor(XSSFCellBorder.BorderSide.BOTTOM, color); cellStyle.setBottomBorderColor(color);
/** * Set the color to use for the bottom border * @param color the index of the color definition * @see org.apache.poi.ss.usermodel.IndexedColors */ public void setBottomBorderColor(short color) { XSSFColor clr = new XSSFColor(); clr.setIndexed(color); setBottomBorderColor(clr); }
/** * Set the color to use for the selected border * * @param side - where to apply the color definition * @param color - the color to use */ public void setBorderColor(BorderSide side, XSSFColor color) { switch(side){ case BOTTOM: setBottomBorderColor(color); break; case RIGHT: setRightBorderColor(color); break; case TOP: setTopBorderColor(color); break; case LEFT: setLeftBorderColor(color); break; } }
/** * Set the color to use for the bottom border * @param color the index of the color definition * @see org.apache.poi.ss.usermodel.IndexedColors */ @Override public void setBottomBorderColor(short color) { XSSFColor clr = XSSFColor.from(CTColor.Factory.newInstance(), _stylesSource.getIndexedColors()); clr.setIndexed(color); setBottomBorderColor(clr); }
/** * Set the color to use for the selected border * * @param side - where to apply the color definition * @param color - the color to use */ public void setBorderColor(BorderSide side, XSSFColor color) { switch(side){ case BOTTOM: setBottomBorderColor(color); break; case RIGHT: setRightBorderColor(color); break; case TOP: setTopBorderColor(color); break; case LEFT: setLeftBorderColor(color); break; } } private int getFontId() {
BorderStyle borderStyle=getBorderStyle(bottomBorder); XSSFColor borderColor=buildXSSFColor(bottomBorder.getColor()); style.setBottomBorderColor(borderColor); style.setBorderBottom(borderStyle);
style.setLeftBorderColor(new XSSFColor(new java.awt.Color(39, 51, 89), wb.getStylesSource().getIndexedColors())); style.setBorderBottom(BorderStyle.THIN); style.setBottomBorderColor(new XSSFColor(new java.awt.Color(39, 51, 89), wb.getStylesSource().getIndexedColors())); style.setFont(dayFont); styles.put("weekend_left", style); style.setRightBorderColor(new XSSFColor(new java.awt.Color(39, 51, 89), wb.getStylesSource().getIndexedColors())); style.setBorderBottom(BorderStyle.THIN); style.setBottomBorderColor(new XSSFColor(new java.awt.Color(39, 51, 89), wb.getStylesSource().getIndexedColors())); styles.put("weekend_right", style); style.setLeftBorderColor(new XSSFColor(new java.awt.Color(39, 51, 89), wb.getStylesSource().getIndexedColors())); style.setBorderBottom(BorderStyle.THIN); style.setBottomBorderColor(new XSSFColor(new java.awt.Color(39, 51, 89), wb.getStylesSource().getIndexedColors())); style.setFont(dayFont); styles.put("workday_left", style); style.setRightBorderColor(new XSSFColor(new java.awt.Color(39, 51, 89), wb.getStylesSource().getIndexedColors())); style.setBorderBottom(BorderStyle.THIN); style.setBottomBorderColor(new XSSFColor(new java.awt.Color(39, 51, 89), wb.getStylesSource().getIndexedColors())); styles.put("workday_right", style); style.setFillPattern(FillPatternType.SOLID_FOREGROUND); style.setBorderBottom(BorderStyle.THIN); style.setBottomBorderColor(new XSSFColor(new java.awt.Color(39, 51, 89), wb.getStylesSource().getIndexedColors())); styles.put("grey_left", style); style.setRightBorderColor(new XSSFColor(new java.awt.Color(39, 51, 89), wb.getStylesSource().getIndexedColors())); style.setBorderBottom(BorderStyle.THIN);
XSSFCellStyle styleSubHeader = (XSSFCellStyle) wb.createCellStyle(); styleSubHeader.setFont(fontBold); styleSubHeader.setVerticalAlignment(CellStyle.VERTICAL_CENTER); styleSubHeader.setAlignment(CellStyle.ALIGN_CENTER); styleSubHeader.setFillForegroundColor(COLOR_ORANGE); styleSubHeader.setFillPattern(CellStyle.SOLID_FOREGROUND); styleSubHeader.setBorderBottom(CellStyle.BORDER_THIN); styleSubHeader.setBottomBorderColor(COLOR_GREY); styleSubHeader.setBorderLeft(CellStyle.BORDER_THIN); styleSubHeader.setLeftBorderColor(COLOR_GREY); styleSubHeader.setBorderRight(CellStyle.BORDER_THIN); styleSubHeader.setRightBorderColor(COLOR_GREY); styleSubHeader.setBorderTop(CellStyle.BORDER_THIN); styleSubHeader.setTopBorderColor(COLOR_GREY);
public static void setBorderColor(Workbook workbook, CellStyle cellStyle, Color[] color) { if (color == null) { return; } if (cellStyle instanceof XSSFCellStyle) { ((XSSFCellStyle) cellStyle).setTopBorderColor(new XSSFColor(color[0])); ((XSSFCellStyle) cellStyle).setRightBorderColor(new XSSFColor(color[1])); ((XSSFCellStyle) cellStyle).setBottomBorderColor(new XSSFColor(color[2])); ((XSSFCellStyle) cellStyle).setLeftBorderColor(new XSSFColor(color[3])); } else if (cellStyle instanceof HSSFCellStyle && workbook instanceof HSSFWorkbook) { cellStyle.setTopBorderColor(getSimilarColor((HSSFWorkbook) workbook, color[0]).getIndex()); cellStyle.setRightBorderColor(getSimilarColor((HSSFWorkbook) workbook, color[1]).getIndex()); cellStyle.setBottomBorderColor(getSimilarColor((HSSFWorkbook) workbook, color[2]).getIndex()); cellStyle.setLeftBorderColor(getSimilarColor((HSSFWorkbook) workbook, color[3]).getIndex()); } else { LOGGER.error("unknown font type"); } }
xssfStyle.setBottomBorderColor(getColor(colors[2], xssfWorkbook));
cellStyle.setBorderBottom(CellStyle.BORDER_THIN); if (cellStyle instanceof XSSFCellStyle) { ((XSSFCellStyle)cellStyle).setBottomBorderColor(new XSSFColor(toRgbByte(borderColor))); } else { cellStyle.setBottomBorderColor(borderColor.getIndex());
BorderStyle borderStyle=getBorderStyle(bottomBorder); XSSFColor borderColor=buildXSSFColor(bottomBorder.getColor()); style.setBottomBorderColor(borderColor); style.setBorderBottom(borderStyle);
cellStyle.setBottomBorderColor(HTMLToExcelStyleCoverter.getXSSFBottomBorderColor(style)); cellStyle.setLeftBorderColor(HTMLToExcelStyleCoverter.getXSSFLeftBorderColor(style));
cellStyle.setBottomBorderColor(HTMLToExcelStyleCoverter.getXSSFBottomBorderColor(style, xssfWorkbook)); cellStyle.setLeftBorderColor(HTMLToExcelStyleCoverter.getXSSFLeftBorderColor(style, xssfWorkbook));