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

x33g5p2x  于2022-01-19 转载在 其他  
字(8.0k)|赞(0)|评价(0)|浏览(227)

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

Font.setUnderline介绍

[英]set type of text underlining to use
[中]设置要使用的文本下划线类型

代码示例

代码示例来源:origin: pentaho/pentaho-kettle

hlink_font.setTypeOffset( origFont.getTypeOffset() );
hlink_font.setUnderline( Font.U_SINGLE );
hlink_font.setColor( IndexedColors.BLUE.getIndex() );
CellStyle style = cell.getCellStyle();

代码示例来源:origin: apache/tika

@Override
public void reset(XSSFWorkbook workbook) {
  this.workbook = workbook;
  style = workbook.createCellStyle();
  Font hlinkFont = workbook.createFont();
  hlinkFont.setUnderline(Font.U_SINGLE);
  hlinkFont.setColor(IndexedColors.BLUE.getIndex());
  style.setFont(hlinkFont);
  links = 0;
}

代码示例来源:origin: br.com.objectos/way-io

@Override
 void apachePOI(Font font) {
  font.setUnderline(Font.U_SINGLE);
 }
};

代码示例来源:origin: br.com.objectos/xls

@Override
 void apachePOI(Font font) {
  font.setUnderline(Font.U_SINGLE);
 }
};

代码示例来源:origin: br.com.objectos/xls-core

@Override
 void apachePOI(Font font) {
  font.setUnderline(Font.U_SINGLE);
 }
};

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

CellStyle hlink_style = wb.createCellStyle();
Font hlink_font = wb.createFont();
hlink_font.setUnderline(Font.U_SINGLE);
hlink_font.setColor(IndexedColors.BLUE.getIndex());
hlink_style.setFont(hlink_font);

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

/**
 * Font underline.
 * Usage example:
 * withUnderline(FontUnderline.SINGLE.getByteValue())
 * @param underline Underline
 * @return FontStyle Font style
 */
public FontStyle withUnderline(final byte underline) {
  return new FontStyle(
    this.props.with(font -> font.setUnderline(underline))
  );
}

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

XSSFCellStyle hLinkStyle = getWorkbook().createCellStyle();
Font hLinkFont = getWorkbook().createFont();
hLinkFont.setFontName("Ariel");
hLinkFont.setUnderline(Font.U_SINGLE);
hLinkFont.setColor(IndexedColors.BLUE.getIndex() );
hLinkStyle.setFont(hLinkFont);

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

CellStyle hlink_style = workbook.createCellStyle();
Font hlink_font = workbook.createFont();
hlink_font.setUnderline(Font.U_SINGLE);
hlink_font.setColor(Font.COLOR_RED);
hlink_style.setFont(hlink_font);
Hyperlink link = createHelper.createHyperlink(Hyperlink.LINK_FILE);
Cell cell = null;     
cell=row.createCell((short) 1);
cell.setCellValue("Go to Result");
path_f="D://Result.xls";
link.setAddress(path_f);        
cell.setHyperlink(link);    
cell.setCellStyle(hlink_style);

代码示例来源:origin: net.paissad.tools.reqcoco/reqcoco-core

private void configureHyperlinkCell(final Cell cell, final Font cellFont, final CreationHelper creationHelper, String cellContent) {
  cellFont.setUnderline(Font.U_SINGLE);
  cellFont.setColor(IndexedColors.BLUE.getIndex());
  final Hyperlink link = creationHelper.createHyperlink(HyperlinkType.URL);
  link.setAddress(cellContent);
  cell.setHyperlink(link);
}

代码示例来源:origin: org.jxls/jxls-poi

private CellStyle createLinkStyle(Workbook workbook) {
  linkStyle = workbook.createCellStyle();
  Font hlink_font = workbook.createFont();
  hlink_font.setUnderline(Font.U_SINGLE);
  hlink_font.setColor(IndexedColors.BLUE.getIndex());
  linkStyle.setFont(hlink_font);
  return linkStyle;
}

代码示例来源:origin: org.rapidpm.modul/cdi-tablemodel

private CellStyle createHyperLinkStyle(final XSSFWorkbook workbook) {
    final CellStyle hlink_style = workbook.createCellStyle();
    final Font hlink_font = workbook.createFont();
    hlink_font.setUnderline(Font.U_SINGLE);
    hlink_font.setColor(IndexedColors.BLUE.getIndex());
    hlink_style.setFont(hlink_font);
    return hlink_style;
  }
}

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

Cell cell = row.createCell(1);
 RichTextString rt = new XSSFRichTextString("The quick brown fox");
 Font font1 = wb.createFont();
 font1.setBoldWeight(Font.BOLDWEIGHT_BOLD);
 rt.applyFont(0, 10, font1);
 Font font2 = wb.createFont();
 font2.setItalic(true);
 font2.setUnderline(XSSFFont.U_DOUBLE);
 rt.applyFont(10, 19, font2);
 Font font3 = wb.createFont();
 font3.setBoldWeight(Font.BOLDWEIGHT_NORMAL);
 rt.append(" Jumped over the lazy dog", font3);
 cell.setCellValue(rt);

代码示例来源:origin: com.sap.cloud.servicesdk.prov/odata2.core

private void createCellHyperLink(Cell cell, EntityInfo eInfo, Object val, XSSFWorkbook workbook) {
  CellStyle style = workbook.createCellStyle();
  Font font = workbook.createFont();
  font.setUnderline(Font.U_SINGLE);
  font.setColor(HSSFColor.BLUE.index);
  style.setFont(font);
  
  XSSFHyperlink hLink = null;
  if(EMAIL.equals(eInfo.getSemantics())){
    hLink = workbook.getCreationHelper().createHyperlink(HyperlinkType.EMAIL);
    hLink.setAddress("mailto:"+String.valueOf(val));
  }else if(URL.equals(eInfo.getSemantics())){
    hLink = workbook.getCreationHelper().createHyperlink(HyperlinkType.URL);
    hLink.setAddress(String.valueOf(val));
  }
  if(hLink != null){
    cell.setHyperlink(hLink);
    cell.setCellStyle(style);
  }
}

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

public static void hyperlinkScreenshot(XSSFCell cell, String FileAddress){
  XSSFWorkbook wb=cell.getRow().getSheet().getWorkbook();
  CreationHelper createHelper = wb.getCreationHelper();
  CellStyle hlink_style = wb.createCellStyle();
  Font hlink_font = wb.createFont();
  hlink_font.setUnderline(Font.U_SINGLE);
  hlink_font.setColor(IndexedColors.BLUE.getIndex());
  hlink_style.setFont(hlink_font);
  Hyperlink hp = createHelper.createHyperlink(Hyperlink.LINK_FILE);
  FileAddress=FileAddress.replace("\\", "/");
  hp.setAddress(FileAddress);
  cell.setHyperlink(hp);
  cell.setCellStyle(hlink_style);
}

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

public static void differentFontTypeInSameCell(){
  Workbook wb = new HSSFWorkbook();
  Sheet sheet = wb.createSheet("TestSheet");
  Cell cell = sheet.createRow(0).createCell(0);
  Font underlineFont = wb.createFont();
  underlineFont.setUnderline(HSSFFont.U_DOUBLE);
  Font boldFont = wb.createFont();
  boldFont.setBoldweight(Font.BOLDWEIGHT_BOLD);
  Font italicFont = wb.createFont();
  italicFont.setItalic(true);
  CellStyle style = wb.createCellStyle();
  style.setFont(underlineFont);
  cell.setCellStyle(style);
  RichTextString richString = new HSSFRichTextString("Underline, Bold, Italic");
  richString.applyFont(11, 15, boldFont);
  richString.applyFont(17, 23, italicFont);
  cell.setCellValue(richString);
}

代码示例来源:origin: Appendium/objectlabkit

private void addFontFormat(ExcelCell cell, CellStyle cellStyle) {
  if (bold || italic || underline || header || fontColour != null || strikeout) {
    Font f = cell.workbook().createFont();
    f.setBold(bold || header);
    if (underline) {
      f.setUnderline(Font.U_SINGLE);
    }
    if (fontColour != null) {
      f.setColor(fontColour.getIndex());
    }
    f.setItalic(italic);
    f.setStrikeout(strikeout);
    cellStyle.setFont(f);
  }
}

代码示例来源:origin: eu.ralph-schuster/csv

/**
 * Returns the font to be used for hyperlinks.
 * This implementation returns the font defined by {@link #getDefaultFontName()},
 * {@link #getDefaultFontSize()} and {@link #getDefaultHyperlinkColor()}. This font will
 * be underlined with normal weight.
 * @param workbook the workbook for creation
 * @return font object for hyperlinks
 */
public Font getDefaultHyperlinkFont(Workbook workbook) {
  if (defaultHyperlinkFont == null) {
    defaultHyperlinkFont = workbook.createFont();
    defaultHyperlinkFont.setBoldweight(Font.BOLDWEIGHT_NORMAL);
    defaultHyperlinkFont.setColor(getDefaultHyperlinkColor());
    defaultHyperlinkFont.setFontHeightInPoints(getDefaultFontSize());
    defaultHyperlinkFont.setFontName(getDefaultFontName());
    defaultHyperlinkFont.setUnderline(Font.U_SINGLE);
  }
  return defaultHyperlinkFont;
}

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

@Override
public void enrich(WorkbookContext workbookContext, org.apache.poi.ss.usermodel.CellStyle style) {
  Font font = workbookContext.toNativeWorkbook().createFont();
  font.setFontName(workbookContext.getDefaultFontName());
  font.setFontHeightInPoints(height);
  font.setBold(boldWeight);
  font.setUnderline(underline);
  font.setItalic(italic);
  style.setFont(font);
  style.setAlignment(horizontalAlignment);
  style.setVerticalAlignment(verticalAlignment);
}

代码示例来源:origin: br.com.tecsinapse/tecsinapse-data-io

private void configFont(Font font) {
  font.setBold(isBold());
  font.setItalic(isItalic());
  font.setStrikeout(isStrikeout());
  font.setUnderline(isUnderline() ? Font.U_SINGLE : Font.U_NONE);
  if (getFontSize() != null) {
    font.setFontHeightInPoints(fontSize.shortValue());
  }
  if (getFontColor() != null) {
    if (font instanceof XSSFFont) {
      ((XSSFFont)font).setColor(new XSSFColor(toRgbByte(fontColor)));
    } else {
      font.setColor(fontColor.getIndex());
    }
  }
}

相关文章