本文整理了Java中org.apache.poi.ss.usermodel.CellStyle.getTopBorderColor()
方法的一些代码示例,展示了CellStyle.getTopBorderColor()
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。CellStyle.getTopBorderColor()
方法的具体详情如下:
包路径:org.apache.poi.ss.usermodel.CellStyle
类名称:CellStyle
方法名:getTopBorderColor
[英]get the color to use for the top border
[中]获取用于上边框的颜色
代码示例来源:origin: org.apache.poi/poi
put(properties, RIGHT_BORDER_COLOR, style.getRightBorderColor());
put(properties, ROTATION, style.getRotation());
put(properties, TOP_BORDER_COLOR, style.getTopBorderColor());
put(properties, WRAP_TEXT, style.getWrapText());
return properties;
代码示例来源:origin: openl-tablets/openl-tablets
private void initWorkbookColors() {
if (!(getWorkbook() instanceof HSSFWorkbook)) {
return;
}
Workbook workbook = getWorkbook();
int numStyles = workbook.getNumCellStyles();
for (int i = 0; i < numStyles; i++) {
CellStyle cellStyle = workbook.getCellStyleAt(i);
wbColors.add(cellStyle.getFillForegroundColor());
wbColors.add(cellStyle.getFillBackgroundColor());
wbColors.add(cellStyle.getTopBorderColor());
wbColors.add(cellStyle.getBottomBorderColor());
wbColors.add(cellStyle.getLeftBorderColor());
wbColors.add(cellStyle.getRightBorderColor());
}
int numFonts = workbook.getNumberOfFontsAsInt();
for (int i = 0; i < numFonts; i++) {
Font font = workbook.getFontAt(i);
wbColors.add(font.getColor());
}
}
代码示例来源:origin: openl-tablets/openl-tablets
@Override
public short[][] getBorderRGB() {
short[][] colors = new short[4][];
colors[0] = toRgb(palette, getXlsStyle().getTopBorderColor());
colors[1] = toRgb(palette, getXlsStyle().getRightBorderColor());
colors[2] = toRgb(palette, getXlsStyle().getBottomBorderColor());
colors[3] = toRgb(palette, getXlsStyle().getLeftBorderColor());
return colors;
}
代码示例来源:origin: pentaho/pentaho-reporting
protected HSSFCellStyleKey( final CellStyle style ) {
this.color = style.getFillForegroundColor();
this.colorTop = style.getTopBorderColor();
this.colorLeft = style.getLeftBorderColor();
this.colorBottom = style.getBottomBorderColor();
this.colorRight = style.getRightBorderColor();
this.borderStrokeTop = style.getBorderTopEnum();
this.borderStrokeLeft = style.getBorderLeftEnum();
this.borderStrokeBottom = style.getBorderBottomEnum();
this.borderStrokeRight = style.getBorderRightEnum();
this.dataStyle = style.getDataFormat();
this.font = style.getFontIndex();
this.horizontalAlignment = style.getAlignmentEnum();
this.verticalAlignment = style.getVerticalAlignmentEnum();
this.wrapText = style.getWrapText();
this.textRotation = TextRotation.getInstance( style.getRotation() );
}
代码示例来源:origin: openl-tablets/openl-tablets
public static short[][] getCellBorderColors(CellStyle style, Workbook workbook) {
short[][] colors = new short[4][];
if (style instanceof HSSFCellStyle) {
HSSFWorkbook hssfWorkbook = (HSSFWorkbook) workbook;
colors[0] = toRgb(style.getTopBorderColor(), hssfWorkbook);
colors[1] = toRgb(style.getRightBorderColor(), hssfWorkbook);
colors[2] = toRgb(style.getBottomBorderColor(), hssfWorkbook);
colors[3] = toRgb(style.getLeftBorderColor(), hssfWorkbook);
} else if(style instanceof XSSFCellStyle) {
XSSFCellStyle xssfStyle = (XSSFCellStyle) style;
colors[0] = toRgb(xssfStyle.getTopBorderXSSFColor());
colors[1] = toRgb(xssfStyle.getRightBorderXSSFColor());
colors[2] = toRgb(xssfStyle.getBottomBorderXSSFColor());
colors[3] = toRgb(xssfStyle.getLeftBorderXSSFColor());
}
return colors;
}
代码示例来源:origin: openl-tablets/openl-tablets
private boolean equalsStyle(CellStyle cs1, CellStyle cs2) {
return (cs1.getAlignment() == cs2.getAlignment() && cs1.getHidden() == cs2.getHidden() && cs1.getLocked() == cs2.getLocked() && cs1.getWrapText() == cs2.getWrapText() && cs1.getBorderBottom() == cs2.getBorderBottom() && cs1.getBorderLeft() == cs2.getBorderLeft() && cs1.getBorderRight() == cs2.getBorderRight() && cs1.getBorderTop() == cs2.getBorderTop() && cs1.getBottomBorderColor() == cs2.getBottomBorderColor() && cs1.getFillBackgroundColor() == cs2.getFillBackgroundColor() && cs1.getFillForegroundColor() == cs2.getFillForegroundColor() && cs1.getFillPattern() == cs2.getFillPattern() && cs1.getIndention() == cs2.getIndention() && cs1.getLeftBorderColor() == cs2.getLeftBorderColor() && cs1.getRightBorderColor() == cs2.getRightBorderColor() && cs1.getRotation() == cs2.getRotation() && cs1.getTopBorderColor() == cs2.getTopBorderColor() && cs1.getVerticalAlignment() == cs2.getVerticalAlignment()) && cs1.getDataFormat() == cs2.getDataFormat();
}
代码示例来源:origin: org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi
putShort(properties, RIGHT_BORDER_COLOR, style.getRightBorderColor());
putShort(properties, ROTATION, style.getRotation());
putShort(properties, TOP_BORDER_COLOR, style.getTopBorderColor());
putShort(properties, VERTICAL_ALIGNMENT, style.getVerticalAlignment());
putBoolean(properties, WRAP_TEXT, style.getWrapText());
代码示例来源:origin: org.apache.poi/poi-contrib
putShort(properties, RIGHT_BORDER_COLOR, style.getRightBorderColor());
putShort(properties, ROTATION, style.getRotation());
putShort(properties, TOP_BORDER_COLOR, style.getTopBorderColor());
putShort(properties, VERTICAL_ALIGNMENT, style.getVerticalAlignment());
putBoolean(properties, WRAP_TEXT, style.getWrapText());
代码示例来源:origin: org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi
put(properties, RIGHT_BORDER_COLOR, style.getRightBorderColor());
put(properties, ROTATION, style.getRotation());
put(properties, TOP_BORDER_COLOR, style.getTopBorderColor());
put(properties, WRAP_TEXT, style.getWrapText());
return properties;
代码示例来源:origin: com.haulmont.thirdparty/poi
putShort(properties, RIGHT_BORDER_COLOR, style.getRightBorderColor());
putShort(properties, ROTATION, style.getRotation());
putShort(properties, TOP_BORDER_COLOR, style.getTopBorderColor());
putShort(properties, VERTICAL_ALIGNMENT, style.getVerticalAlignment());
putBoolean(properties, WRAP_TEXT, style.getWrapText());
代码示例来源:origin: org.openl.rules/org.openl.lib.poi.dev
putShort(properties, RIGHT_BORDER_COLOR, style.getRightBorderColor());
putShort(properties, ROTATION, style.getRotation());
putShort(properties, TOP_BORDER_COLOR, style.getTopBorderColor());
putShort(properties, VERTICAL_ALIGNMENT, style.getVerticalAlignment());
putBoolean(properties, WRAP_TEXT, style.getWrapText());
代码示例来源:origin: caryyu/excel2pdf
cell.setBorderColorLeft(new BaseColor(POIUtil.getBorderRBG(wb, style.getLeftBorderColor())));
cell.setBorderColorRight(new BaseColor(POIUtil.getBorderRBG(wb, style.getRightBorderColor())));
cell.setBorderColorTop(new BaseColor(POIUtil.getBorderRBG(wb, style.getTopBorderColor())));
cell.setBorderColorBottom(new BaseColor(POIUtil.getBorderRBG(wb, style.getBottomBorderColor())));
代码示例来源:origin: net.sf.jxls/jxls-core
newStyle.setLocked(style.getLocked());
newStyle.setRightBorderColor(style.getRightBorderColor());
newStyle.setTopBorderColor(style.getTopBorderColor());
newStyle.setVerticalAlignment(style.getVerticalAlignment());
newStyle.setWrapText(style.getWrapText());
代码示例来源:origin: SheetJS/jxls
newStyle.setLocked(style.getLocked());
newStyle.setRightBorderColor(style.getRightBorderColor());
newStyle.setTopBorderColor(style.getTopBorderColor());
newStyle.setVerticalAlignment(style.getVerticalAlignment());
newStyle.setWrapText(style.getWrapText());
代码示例来源:origin: com.eas.platypus/platypus-js-reports
private void copyStyle(Workbook workbook, Cell fromCell, Cell toCell) {
CellStyle toStyle = toCell.getCellStyle();
CellStyle fromStyle = fromCell.getCellStyle();
CellStyle newStyle = workbook.createCellStyle();
newStyle.setAlignment(fromStyle.getAlignment());
newStyle.setBorderBottom(fromStyle.getBorderBottom());
newStyle.setBorderLeft(fromStyle.getBorderLeft());
newStyle.setBorderRight(fromStyle.getBorderRight());
newStyle.setBorderTop(fromStyle.getBorderTop());
newStyle.setBottomBorderColor(fromStyle.getBottomBorderColor());
newStyle.setFillBackgroundColor(fromStyle.getFillBackgroundColor());
newStyle.setFillForegroundColor(fromStyle.getFillForegroundColor());
newStyle.setFillPattern(fromStyle.getFillPattern());
newStyle.setFont(workbook.getFontAt(fromStyle.getFontIndex()));
newStyle.setHidden(fromStyle.getHidden());
newStyle.setIndention(fromStyle.getIndention());
newStyle.setLeftBorderColor(fromStyle.getLeftBorderColor());
newStyle.setLocked(fromStyle.getLocked());
newStyle.setRightBorderColor(fromStyle.getRightBorderColor());
newStyle.setTopBorderColor(fromStyle.getTopBorderColor());
newStyle.setVerticalAlignment(fromStyle.getVerticalAlignment());
newStyle.setWrapText(fromStyle.getWrapText());
newStyle.setDataFormat(toStyle.getDataFormat());
toCell.setCellStyle(newStyle);
}
}
代码示例来源:origin: SheetJS/jxls
private void copyStyle(Workbook workbook, org.apache.poi.ss.usermodel.Cell fromCell, org.apache.poi.ss.usermodel.Cell toCell){
CellStyle toStyle = toCell.getCellStyle();
CellStyle fromStyle = fromCell.getCellStyle();
if( fromStyle.getDataFormat() == toStyle.getDataFormat() ){
toCell.setCellStyle( fromStyle );
}else{
CellStyle newStyle = workbook.createCellStyle();
newStyle.setAlignment( toStyle.getAlignment() );
newStyle.setBorderBottom( toStyle.getBorderBottom() );
newStyle.setBorderLeft( toStyle.getBorderLeft() );
newStyle.setBorderRight( toStyle.getBorderRight() );
newStyle.setBorderTop( toStyle.getBorderTop() );
newStyle.setBottomBorderColor( toStyle.getBottomBorderColor() );
newStyle.setDataFormat( toStyle.getDataFormat() );
newStyle.setFillBackgroundColor( fromStyle.getFillBackgroundColor() );
newStyle.setFillForegroundColor( fromStyle.getFillForegroundColor() );
newStyle.setFillPattern( fromStyle.getFillPattern() );
newStyle.setFont( workbook.getFontAt( fromStyle.getFontIndex() ) );
newStyle.setHidden( toStyle.getHidden() );
newStyle.setIndention( toStyle.getIndention() );
newStyle.setLeftBorderColor( toStyle.getLeftBorderColor() );
newStyle.setLocked( toStyle.getLocked() );
newStyle.setRightBorderColor( toStyle.getRightBorderColor() );
newStyle.setTopBorderColor( toStyle.getTopBorderColor() );
newStyle.setVerticalAlignment( toStyle.getVerticalAlignment() );
newStyle.setWrapText( toStyle.getWrapText() );
toCell.setCellStyle( newStyle );
}
}
}
代码示例来源:origin: com.github.nic-luo/rober-office
toStyle.setBorderRight(fromStyle.getBorderRight());
toStyle.setBorderTop(fromStyle.getBorderTop());
toStyle.setTopBorderColor(fromStyle.getTopBorderColor());
toStyle.setBottomBorderColor(fromStyle.getBottomBorderColor());
toStyle.setRightBorderColor(fromStyle.getRightBorderColor());
内容来源于网络,如有侵权,请联系作者删除!