/** * Set the color to use for the top border * * @param color the index of the color definition * @see org.apache.poi.ss.usermodel.IndexedColors */ @Override public void setTopBorderColor(short color) { XSSFColor clr = XSSFColor.from(CTColor.Factory.newInstance(), _stylesSource.getIndexedColors()); clr.setIndexed(color); setTopBorderColor(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 top border * * @param color the index of the color definition * @see org.apache.poi.ss.usermodel.IndexedColors */ public void setTopBorderColor(short color) { XSSFColor clr = new XSSFColor(); clr.setIndexed(color); setTopBorderColor(clr); }
/** * Set the color to use for the top border * * @param color the index of the color definition * @see org.apache.poi.ss.usermodel.IndexedColors */ @Override public void setTopBorderColor(short color) { XSSFColor clr = XSSFColor.from(CTColor.Factory.newInstance(), _stylesSource.getIndexedColors()); clr.setIndexed(color); setTopBorderColor(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 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(topBorder); XSSFColor borderColor=buildXSSFColor(topBorder.getColor()); style.setTopBorderColor(borderColor); style.setBorderTop(borderStyle);
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"); } }
XSSFCellStyle xssfStyle = (XSSFCellStyle) style; if (colors[0] != null) { xssfStyle.setTopBorderColor(getColor(colors[0], xssfWorkbook));
cellStyle.setBorderTop(CellStyle.BORDER_THIN); if (cellStyle instanceof XSSFCellStyle) { ((XSSFCellStyle)cellStyle).setTopBorderColor(new XSSFColor(toRgbByte(borderColor))); } else { cellStyle.setTopBorderColor(borderColor.getIndex());
BorderStyle borderStyle=getBorderStyle(topBorder); XSSFColor borderColor=buildXSSFColor(topBorder.getColor()); style.setTopBorderColor(borderColor); style.setBorderTop(borderStyle);
cellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND); cellStyle.setTopBorderColor(HTMLToExcelStyleCoverter.getXSSFTopBorderColor(style)); cellStyle.setRightBorderColor(HTMLToExcelStyleCoverter.getXSSFRightBorderColor(style)); cellStyle.setBottomBorderColor(HTMLToExcelStyleCoverter.getXSSFBottomBorderColor(style));
cellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND); cellStyle.setTopBorderColor(HTMLToExcelStyleCoverter.getXSSFTopBorderColor(style, xssfWorkbook)); cellStyle.setRightBorderColor(HTMLToExcelStyleCoverter.getXSSFRightBorderColor(style, xssfWorkbook)); cellStyle.setBottomBorderColor(HTMLToExcelStyleCoverter.getXSSFBottomBorderColor(style, xssfWorkbook));