org.apache.poi.ss.usermodel.CellStyle.getBorderTop()方法的使用及代码示例

x33g5p2x  于2022-01-18 转载在 其他  
字(9.9k)|赞(0)|评价(0)|浏览(704)

本文整理了Java中org.apache.poi.ss.usermodel.CellStyle.getBorderTop()方法的一些代码示例，展示了CellStyle.getBorderTop()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。CellStyle.getBorderTop()方法的具体详情如下：
包路径：org.apache.poi.ss.usermodel.CellStyle
类名称：CellStyle
方法名：getBorderTop

CellStyle.getBorderTop介绍

[英]get the type of border to use for the top border of the cell
[中]获取用于单元格顶部边框的边框类型

代码示例

代码示例来源：origin: org.apache.poi/poi

put(properties, BORDER_LEFT, style.getBorderLeft());
put(properties, BORDER_RIGHT, style.getBorderRight());
put(properties, BORDER_TOP, style.getBorderTop());
put(properties, BOTTOM_BORDER_COLOR, style.getBottomBorderColor());
put(properties, DATA_FORMAT, style.getDataFormat());

代码示例来源：origin: openl-tablets/openl-tablets

public static BorderStyle[] getCellBorderStyles(CellStyle style) {
  BorderStyle[] styles = new BorderStyle[4];
  styles[0] = style.getBorderTop();
  styles[1] = style.getBorderRight();
  styles[2] = style.getBorderBottom();
  styles[3] = style.getBorderLeft();
  return styles;
}

代码示例来源：origin: takezoe/xlsbeans

public WBorderLineStyle getBorder(WBorder border) {
 if (cellStyle == null) {
  return WBorderLineStyle.NONE;
 }
 WBorderLineStyle style = null;
 if (WBorder.BOTTOM.equals(border)) {
  style = XssfBorderLineStyleResolver.resolve(cellStyle.getBorderBottom());
 } else if (WBorder.LEFT.equals(border)) {
  style = XssfBorderLineStyleResolver.resolve(cellStyle.getBorderLeft());
 } else if (WBorder.RIGHT.equals(border)) {
  style = XssfBorderLineStyleResolver.resolve(cellStyle.getBorderRight());
 } else if (WBorder.TOP.equals(border)) {
  style = XssfBorderLineStyleResolver.resolve(cellStyle.getBorderTop());
 } else {
  // FIXME Correct strictly? XLSBeans don't use this style, except TOP, LEFT.
  style = WBorderLineStyle.NONE;
 }
 return style;
}

代码示例来源：origin: org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi

/**
 * Returns <tt>false</tt> if cell style by itself (without text, i.e.
 * borders, fill, etc.) worth a mention, <tt>true</tt> otherwise
 * 
 * @return <tt>false</tt> if cell style by itself (without text, i.e.
 *         borders, fill, etc.) worth a mention, <tt>true</tt> otherwise
 */
protected boolean isEmptyStyle( CellStyle cellStyle ) {
  return cellStyle == null || (
      cellStyle.getFillPattern() == FillPatternType.NO_FILL
    && cellStyle.getBorderTop() == BorderStyle.NONE
    && cellStyle.getBorderRight() == BorderStyle.NONE
    && cellStyle.getBorderBottom() == BorderStyle.NONE
    && cellStyle.getBorderLeft() == BorderStyle.NONE
  );
}

代码示例来源：origin: org.openl.rules/org.openl.lib.poi.dev

/**
 * Returns <tt>false</tt> if cell style by itself (without text, i.e.
 * borders, fill, etc.) worth a mention, <tt>true</tt> otherwise
 * 
 * @return <tt>false</tt> if cell style by itself (without text, i.e.
 *         borders, fill, etc.) worth a mention, <tt>true</tt> otherwise
 */
protected boolean isEmptyStyle( CellStyle cellStyle )
{
  return cellStyle.getFillPattern() == 0 //
      && cellStyle.getBorderTop() == HSSFCellStyle.BORDER_NONE //
      && cellStyle.getBorderRight() == HSSFCellStyle.BORDER_NONE //
      && cellStyle.getBorderBottom() == HSSFCellStyle.BORDER_NONE //
      && cellStyle.getBorderLeft() == HSSFCellStyle.BORDER_NONE; //
}

代码示例来源：origin: org.apache.poi/poi-examples

private void borderStyles(CellStyle style) {
  styleOut("border-left", style.getBorderLeft(), BORDER);
  styleOut("border-right", style.getBorderRight(), BORDER);
  styleOut("border-top", style.getBorderTop(), BORDER);
  styleOut("border-bottom", style.getBorderBottom(), BORDER);
}

代码示例来源：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, BORDER_LEFT, style.getBorderLeft());
putShort(properties, BORDER_RIGHT, style.getBorderRight());
putShort(properties, BORDER_TOP, style.getBorderTop());
putShort(properties, BOTTOM_BORDER_COLOR, style.getBottomBorderColor());
putShort(properties, DATA_FORMAT, style.getDataFormat());

代码示例来源：origin: org.apache.poi/poi-contrib

putShort(properties, BORDER_LEFT, style.getBorderLeft());
putShort(properties, BORDER_RIGHT, style.getBorderRight());
putShort(properties, BORDER_TOP, style.getBorderTop());
putShort(properties, BOTTOM_BORDER_COLOR, style.getBottomBorderColor());
putShort(properties, DATA_FORMAT, style.getDataFormat());

代码示例来源：origin: org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi

put(properties, BORDER_LEFT, style.getBorderLeft());
put(properties, BORDER_RIGHT, style.getBorderRight());
put(properties, BORDER_TOP, style.getBorderTop());
put(properties, BOTTOM_BORDER_COLOR, style.getBottomBorderColor());
put(properties, DATA_FORMAT, style.getDataFormat());

代码示例来源：origin: com.haulmont.thirdparty/poi

putShort(properties, BORDER_LEFT, style.getBorderLeft());
putShort(properties, BORDER_RIGHT, style.getBorderRight());
putShort(properties, BORDER_TOP, style.getBorderTop());
putShort(properties, BOTTOM_BORDER_COLOR, style.getBottomBorderColor());
putShort(properties, DATA_FORMAT, style.getDataFormat());

代码示例来源：origin: org.openl.rules/org.openl.lib.poi.dev

putShort(properties, BORDER_LEFT, style.getBorderLeft());
putShort(properties, BORDER_RIGHT, style.getBorderRight());
putShort(properties, BORDER_TOP, style.getBorderTop());
putShort(properties, BOTTOM_BORDER_COLOR, style.getBottomBorderColor());
putShort(properties, DATA_FORMAT, style.getDataFormat());

代码示例来源：origin: caryyu/excel2pdf

short top = getBorderWidth(style.getBorderTop());
short bottom = getBorderWidth(style.getBorderBottom());
if (left > 0)

代码示例来源：origin: SheetJS/jxls

newStyle.setBorderLeft(style.getBorderLeft());
newStyle.setBorderRight(style.getBorderRight());
newStyle.setBorderTop(style.getBorderTop());
newStyle.setBottomBorderColor(style.getBottomBorderColor());
newStyle.setDataFormat(style.getDataFormat());

代码示例来源：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: net.sf.jxls/jxls-core

newStyle.setBorderLeft(style.getBorderLeft());
newStyle.setBorderRight(style.getBorderRight());
newStyle.setBorderTop(style.getBorderTop());
newStyle.setBottomBorderColor(style.getBottomBorderColor());
newStyle.setDataFormat(style.getDataFormat());

代码示例来源：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.setBorderLeft(fromStyle.getBorderLeft());
toStyle.setBorderRight(fromStyle.getBorderRight());
toStyle.setBorderTop(fromStyle.getBorderTop());
toStyle.setTopBorderColor(fromStyle.getTopBorderColor());
toStyle.setBottomBorderColor(fromStyle.getBottomBorderColor());

内容来源于网络，如有侵权，请联系作者删除！

CellStyle

相关文章

    查看更多
    微信公众号

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多

    CellStyle类方法

    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com