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

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

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

CellStyle.setBorderLeft介绍

[英]set the type of border to use for the left border of the cell
[中]设置用于单元格左边框的边框类型

代码示例

代码示例来源：origin: looly/hutool

/**
 * 设置cell的四个边框粗细和颜色
 * 
 * @param cellStyle {@link CellStyle}
 * @param borderSize 边框粗细{@link BorderStyle}枚举
 * @param colorIndex 颜色的short值
 * @return {@link CellStyle}
 */
public static CellStyle setBorder(CellStyle cellStyle, BorderStyle borderSize, IndexedColors colorIndex) {
  cellStyle.setBorderBottom(borderSize);
  cellStyle.setBottomBorderColor(colorIndex.index);
  cellStyle.setBorderLeft(borderSize);
  cellStyle.setLeftBorderColor(colorIndex.index);
  cellStyle.setBorderRight(borderSize);
  cellStyle.setRightBorderColor(colorIndex.index);
  cellStyle.setBorderTop(borderSize);
  cellStyle.setTopBorderColor(colorIndex.index);
  return cellStyle;
}

代码示例来源：origin: looly/hutool

/**
 * 设置cell的四个边框粗细和颜色
 * 
 * @param cellStyle {@link CellStyle}
 * @param borderSize 边框粗细{@link BorderStyle}枚举
 * @param colorIndex 颜色的short值
 * @return {@link CellStyle}
 */
public static CellStyle setBorder(CellStyle cellStyle, BorderStyle borderSize, IndexedColors colorIndex) {
  cellStyle.setBorderBottom(borderSize);
  cellStyle.setBottomBorderColor(colorIndex.index);
  cellStyle.setBorderLeft(borderSize);
  cellStyle.setLeftBorderColor(colorIndex.index);
  cellStyle.setBorderRight(borderSize);
  cellStyle.setRightBorderColor(colorIndex.index);
  cellStyle.setBorderTop(borderSize);
  cellStyle.setTopBorderColor(colorIndex.index);
  return cellStyle;
}

代码示例来源：origin: alibaba/easyexcel

/**
 *
 * @param workbook
 * @return
 */
public static CellStyle buildDefaultCellStyle(Workbook workbook) {
  CellStyle newCellStyle = workbook.createCellStyle();
  Font font = workbook.createFont();
  font.setFontName("宋体");
  font.setFontHeightInPoints((short)14);
  font.setBold(true);
  newCellStyle.setFont(font);
  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.setBorderBottom(BorderStyle.THIN);
  newCellStyle.setBorderLeft(BorderStyle.THIN);
  return newCellStyle;
}

代码示例来源：origin: wuyouzhuguli/FEBS-Shiro

@Override
public CellStyle headCellStyle(SXSSFWorkbook wb) {
  CellStyle cellStyle = wb.createCellStyle();
  Font font = wb.createFont();
  cellStyle.setFillForegroundColor((short) 12);
  cellStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);// 填充模式
  cellStyle.setBorderTop(CellStyle.BORDER_THIN);// 上边框为细边框
  cellStyle.setBorderRight(CellStyle.BORDER_THIN);// 右边框为细边框
  cellStyle.setBorderBottom(CellStyle.BORDER_THIN);// 下边框为细边框
  cellStyle.setBorderLeft(CellStyle.BORDER_THIN);// 左边框为细边框
  cellStyle.setAlignment(CellStyle.ALIGN_LEFT);// 对齐
  cellStyle.setFillForegroundColor(HSSFColor.GREEN.index);
  cellStyle.setFillBackgroundColor(HSSFColor.GREEN.index);
  font.setBoldweight(Font.BOLDWEIGHT_NORMAL);
  // font.setFontHeightInPoints((short) 12);// 字体大小
  font.setColor(HSSFColor.WHITE.index);
  // 应用标题字体到标题样式
  cellStyle.setFont(font);
  return cellStyle;
}

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

/**
 * Sets the format properties of the given style based on the given map.
 *
 * @param style cell style
 * @param workbook parent workbook
 * @param properties map of format properties (String -> Object)
 * @see #getFormatProperties(CellStyle)
 */
private static void setFormatProperties(CellStyle style, Workbook workbook, Map<String, Object> properties) {
  style.setAlignment(getHorizontalAlignment(properties, ALIGNMENT));
  style.setVerticalAlignment(getVerticalAlignment(properties, VERTICAL_ALIGNMENT));
  style.setBorderBottom(getBorderStyle(properties, BORDER_BOTTOM));
  style.setBorderLeft(getBorderStyle(properties, BORDER_LEFT));
  style.setBorderRight(getBorderStyle(properties, BORDER_RIGHT));
  style.setBorderTop(getBorderStyle(properties, BORDER_TOP));
  style.setBottomBorderColor(getShort(properties, BOTTOM_BORDER_COLOR));
  style.setDataFormat(getShort(properties, DATA_FORMAT));
  style.setFillPattern(getFillPattern(properties, FILL_PATTERN));
  style.setFillForegroundColor(getShort(properties, FILL_FOREGROUND_COLOR));
  style.setFillBackgroundColor(getShort(properties, FILL_BACKGROUND_COLOR));
  style.setFont(workbook.getFontAt(getInt(properties, FONT)));
  style.setHidden(getBoolean(properties, HIDDEN));
  style.setIndention(getShort(properties, INDENTION));
  style.setLeftBorderColor(getShort(properties, LEFT_BORDER_COLOR));
  style.setLocked(getBoolean(properties, LOCKED));
  style.setRightBorderColor(getShort(properties, RIGHT_BORDER_COLOR));
  style.setRotation(getShort(properties, ROTATION));
  style.setTopBorderColor(getShort(properties, TOP_BORDER_COLOR));
  style.setWrapText(getBoolean(properties, WRAP_TEXT));
}

代码示例来源：origin: stackoverflow.com

XSSFWorkbook wb = new XSSFWorkbook();
CellStyle borderStyle = wb.createCellStyle();
borderStyle.setBorderBottom(CellStyle.BORDER_THIN);
borderStyle.setBorderLeft(CellStyle.BORDER_THIN);
borderStyle.setBorderRight(CellStyle.BORDER_THIN);
borderStyle.setBorderTop(CellStyle.BORDER_THIN);
borderStyle.setAlignment(CellStyle.ALIGN_CENTER);
Sheet sheet = wb.createSheet("Test Sheet");
Row row = sheet.createRow(1);
for (int i = 1; i <= 5; ++i) {
  Cell cell = row.createCell(i);
  cell.setCellStyle(borderStyle);
  if (i == 1) {
    cell.setCellValue("Centred Text");
  } 
}
sheet.addMergedRegion(new CellRangeAddress(1, 1, 1, 5));

代码示例来源：origin: stackoverflow.com

private static CellStyle createBorderedStyle(Workbook wb) {
   CellStyle style = wb.createCellStyle();
   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;
 }

代码示例来源：origin: Vatavuk/excel-io

@Override
  public void accept(final CellStyle style) {
    style.setBorderLeft(this.value);
  }
}

代码示例来源：origin: stackoverflow.com

CellStyle cellStyle = workbook.createCellStyle();
cellStyle.setBorderLeft(CellStyle.BORDER_THIN);
cellStyle.setBorderRight(CellStyle.BORDER_THIN);
cellStyle.setBorderTop(CellStyle.BORDER_THIN);
cellStyle.setBorderBottom(CellStyle.BORDER_THIN);
for(int i=region.getFirstRow();i<region.getLastRow();i++){
  Row row = sheet.getRow(i);
  for(int j=region.getFirstColumn();j<region.getLastColumn();j++){
    Cell cell = row.getCell(j);
    cell.setCellStyle(cellStyle);
  }
}

代码示例来源：origin: subtlelib/poi

@Override
public void enrich(WorkbookContext workbookContext, org.apache.poi.ss.usermodel.CellStyle style) {
  style.setBorderTop(borderTop);
  style.setBorderRight(borderRight);
  style.setBorderBottom(borderBottom);
  style.setBorderLeft(borderLeft);
}

代码示例来源：origin: liaochong/html2excel

@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.setBorderLeft(BorderStyle.THIN);
    style.setBorderTop(BorderStyle.THIN);
    return style;
  }
}

代码示例来源：origin: org.jeecg/easypoi-base

@Override
public CellStyle getTitleStyle(short color) {
  CellStyle titleStyle = workbook.createCellStyle();
  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);
  titleStyle.setWrapText(true);
  return titleStyle;
}

代码示例来源：origin: cn.afterturn/easypoi-base

@Override
public CellStyle getTitleStyle(short color) {
  CellStyle titleStyle = workbook.createCellStyle();
  titleStyle.setBorderLeft(BorderStyle.THIN);
  titleStyle.setBorderRight(BorderStyle.THIN);
  titleStyle.setBorderBottom(BorderStyle.THIN);
  titleStyle.setBorderTop(BorderStyle.THIN);
  titleStyle.setAlignment(HorizontalAlignment.CENTER);
  titleStyle.setVerticalAlignment(VerticalAlignment.CENTER);
  titleStyle.setWrapText(true);
  return titleStyle;
}

代码示例来源：origin: xiaolanglang/easypoi

@Override
public CellStyle getTitleStyle(short color) {
  CellStyle titleStyle = workbook.createCellStyle();
  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);
  titleStyle.setWrapText(true);
  return titleStyle;
}

代码示例来源：origin: zhangdaiscott/jeasypoi

@Override
public CellStyle getTitleStyle(short color) {
  CellStyle titleStyle = workbook.createCellStyle();
  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);
  titleStyle.setWrapText(true);
  return titleStyle;
}

代码示例来源：origin: stackoverflow.com

CellStyle backgroundStyle = workbook.createCellStyle();
 backgroundStyle.setFillBackgroundColor(IndexedColors.GREY_50_PERCENT.getIndex());
 backgroundStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
 backgroundStyle.setBorderBottom(CellStyle.BORDER_THIN);
 backgroundStyle.setBottomBorderColor(IndexedColors.BLACK.getIndex());
 backgroundStyle.setBorderLeft(CellStyle.BORDER_THIN);
 backgroundStyle.setLeftBorderColor(IndexedColors.BLACK.getIndex());
 backgroundStyle.setBorderRight(CellStyle.BORDER_THIN);
 backgroundStyle.setRightBorderColor(IndexedColors.BLACK.getIndex());
 backgroundStyle.setBorderTop(CellStyle.BORDER_THIN);
 backgroundStyle.setTopBorderColor(IndexedColors.BLACK.getIndex());

代码示例来源：origin: stackoverflow.com

CellStyle backgroundStyle = workbook.createCellStyle();
 backgroundStyle.setFillBackgroundColor(IndexedColors.GREY_50_PERCENT.getIndex());
 backgroundStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
 CellStyle borderStyle = workbook.createCellStyle();
 borderStyle.setBorderBottom(CellStyle.BORDER_THIN);
 borderStyle.setBottomBorderColor(IndexedColors.BLACK.getIndex());
 borderStyle.setBorderLeft(CellStyle.BORDER_THIN);
 borderStyle.setLeftBorderColor(IndexedColors.BLACK.getIndex());
 borderStyle.setBorderRight(CellStyle.BORDER_THIN);
 borderStyle.setRightBorderColor(IndexedColors.BLACK.getIndex());
 borderStyle.setBorderTop(CellStyle.BORDER_THIN);
 borderStyle.setTopBorderColor(IndexedColors.BLACK.getIndex());

代码示例来源：origin: xiaolanglang/easypoi

@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;
}

代码示例来源：origin: cn.afterturn/easypoi-base

@Override
public CellStyle getHeaderStyle(short color) {
  CellStyle titleStyle = workbook.createCellStyle();
  Font font = workbook.createFont();
  font.setFontHeightInPoints((short) 12);
  titleStyle.setFont(font);
  titleStyle.setBorderLeft(BorderStyle.THIN);
  titleStyle.setBorderRight(BorderStyle.THIN);
  titleStyle.setBorderBottom(BorderStyle.THIN);
  titleStyle.setBorderTop(BorderStyle.THIN);
  titleStyle.setAlignment(HorizontalAlignment.CENTER);
  titleStyle.setVerticalAlignment(VerticalAlignment.CENTER);
  return titleStyle;
}

代码示例来源：origin: tobyweston/simple-excel

private void applyBorderTo(CellStyle style) {
  if (border != null) {
    style.setBorderBottom(border.getBottom().value().getPoiStyle());
    style.setBorderTop(border.getTop().value().getPoiStyle());
    style.setBorderRight(border.getRight().value().getPoiStyle());
    style.setBorderLeft(border.getLeft().value().getPoiStyle());
  }
}

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

CellStyle

相关文章

    查看更多
    微信公众号

    热门标签

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

    最新文章

    更多

    CellStyle类方法

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