org.apache.poi.hssf.usermodel.HSSFFont.setFontName()方法的使用及代码示例

x33g5p2x  于2022-01-20 转载在 其他  
字(10.3k)|赞(0)|评价(0)|浏览(176)

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

HSSFFont.setFontName介绍

[英]set the name for the font (i.e. Arial)
[中]设置字体的名称(即Arial)

代码示例

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

  1. private HSSFFont matchFont( Font matchFont )
  2. {
  3. HSSFColor hssfColor = workbook.getCustomPalette()
  4. .findColor((byte)foreground.getRed(), (byte)foreground.getGreen(), (byte)foreground.getBlue());
  5. if (hssfColor == null)
  6. hssfColor = workbook.getCustomPalette().findSimilarColor((byte)foreground.getRed(), (byte)foreground.getGreen(), (byte)foreground.getBlue());
  7. boolean bold = (matchFont.getStyle() & Font.BOLD) != 0;
  8. boolean italic = (matchFont.getStyle() & Font.ITALIC) != 0;
  9. HSSFFont hssfFont = workbook.findFont(bold,
  10. hssfColor.getIndex(),
  11. (short)(matchFont.getSize() * 20),
  12. matchFont.getName(),
  13. italic,
  14. false,
  15. (short)0,
  16. (byte)0);
  17. if (hssfFont == null)
  18. {
  19. hssfFont = workbook.createFont();
  20. hssfFont.setBold(bold);
  21. hssfFont.setColor(hssfColor.getIndex());
  22. hssfFont.setFontHeight((short)(matchFont.getSize() * 20));
  23. hssfFont.setFontName(matchFont.getName());
  24. hssfFont.setItalic(italic);
  25. hssfFont.setStrikeout(false);
  26. hssfFont.setTypeOffset((short) 0);
  27. hssfFont.setUnderline((byte) 0);
  28. }
  29. return hssfFont;
  30. }

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

  1. HSSFFont hSSFFont = (HSSFFont) workbook.createFont();
  2. hSSFFont.setFontName(HSSFFont.FONT_ARIAL);
  3. hSSFFont.setCharSet(HSSFFont.ANSI_CHARSET);

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

  1. HSSFCellStyle cellStyle = workBook.createCellStyle();
  2. HSSFFont font = wb.createFont();
  3. font.setFontName(XSSFFont.DEFAULT_FONT_NAME);
  4. font.setFontHeightInPoints((short)10);
  5. font.setColor(IndexedColors.BLUE.getIndex());
  6. cellStyle.setFont(font);
  7. //the version i am using is poi-3.8

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

  1. private HSSFFont createAndSetFontStyle(HSSFWorkbook wb) {
  2. HSSFFont font = wb.createFont();
  3. font.setFontName(XSSFFont.DEFAULT_FONT_NAME);
  4. font.setBoldweight(XSSFFont.BOLDWEIGHT_BOLD);
  5. font.setFontHeightInPoints((short)10);
  6. return font;
  7. }
  8. HSSFCellStyle cellStyle = workBook.createCellStyle();
  9. HSSFFont createfont = createAndSetFontStyle(workBook);
  10. cellStyle.setFont(createfont);
  11. cell.setCellStyle(cellStyle);

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

  1. private HSSFFont matchFont( Font font )
  2. {
  3. HSSFColor hssfColor = workbook.getCustomPalette()
  4. .findColor((byte)foreground.getRed(), (byte)foreground.getGreen(), (byte)foreground.getBlue());
  5. if (hssfColor == null)
  6. hssfColor = workbook.getCustomPalette().findSimilarColor((byte)foreground.getRed(), (byte)foreground.getGreen(), (byte)foreground.getBlue());
  7. boolean bold = (font.getStyle() & Font.BOLD) != 0;
  8. boolean italic = (font.getStyle() & Font.ITALIC) != 0;
  9. HSSFFont hssfFont = workbook.findFont(bold ? HSSFFont.BOLDWEIGHT_BOLD : 0,
  10. hssfColor.getIndex(),
  11. (short)(font.getSize() * 20),
  12. font.getName(),
  13. italic,
  14. false,
  15. (short)0,
  16. (byte)0);
  17. if (hssfFont == null)
  18. {
  19. hssfFont = workbook.createFont();
  20. hssfFont.setBoldweight(bold ? HSSFFont.BOLDWEIGHT_BOLD : 0);
  21. hssfFont.setColor(hssfColor.getIndex());
  22. hssfFont.setFontHeight((short)(font.getSize() * 20));
  23. hssfFont.setFontName(font.getName());
  24. hssfFont.setItalic(italic);
  25. hssfFont.setStrikeout(false);
  26. hssfFont.setTypeOffset((short) 0);
  27. hssfFont.setUnderline((byte) 0);
  28. }
  29. return hssfFont;
  30. }

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

  1. my_font.setFontName("Verdana");

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

  1. private HSSFFont matchFont( Font matchFont )
  2. {
  3. HSSFColor hssfColor = workbook.getCustomPalette()
  4. .findColor((byte)foreground.getRed(), (byte)foreground.getGreen(), (byte)foreground.getBlue());
  5. if (hssfColor == null)
  6. hssfColor = workbook.getCustomPalette().findSimilarColor((byte)foreground.getRed(), (byte)foreground.getGreen(), (byte)foreground.getBlue());
  7. boolean bold = (matchFont.getStyle() & Font.BOLD) != 0;
  8. boolean italic = (matchFont.getStyle() & Font.ITALIC) != 0;
  9. HSSFFont hssfFont = workbook.findFont(bold,
  10. hssfColor.getIndex(),
  11. (short)(matchFont.getSize() * 20),
  12. matchFont.getName(),
  13. italic,
  14. false,
  15. (short)0,
  16. (byte)0);
  17. if (hssfFont == null)
  18. {
  19. hssfFont = workbook.createFont();
  20. hssfFont.setBold(bold);
  21. hssfFont.setColor(hssfColor.getIndex());
  22. hssfFont.setFontHeight((short)(matchFont.getSize() * 20));
  23. hssfFont.setFontName(matchFont.getName());
  24. hssfFont.setItalic(italic);
  25. hssfFont.setStrikeout(false);
  26. hssfFont.setTypeOffset((short) 0);
  27. hssfFont.setUnderline((byte) 0);
  28. }
  29. return hssfFont;
  30. }

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

  1. private HSSFFont matchFont( Font font )
  2. {
  3. HSSFColor hssfColor = workbook.getCustomPalette()
  4. .findColor((byte)foreground.getRed(), (byte)foreground.getGreen(), (byte)foreground.getBlue());
  5. if (hssfColor == null)
  6. hssfColor = workbook.getCustomPalette().findSimilarColor((byte)foreground.getRed(), (byte)foreground.getGreen(), (byte)foreground.getBlue());
  7. boolean bold = (font.getStyle() & Font.BOLD) != 0;
  8. boolean italic = (font.getStyle() & Font.ITALIC) != 0;
  9. HSSFFont hssfFont = workbook.findFont(bold ? HSSFFont.BOLDWEIGHT_BOLD : 0,
  10. hssfColor.getIndex(),
  11. (short)(font.getSize() * 20),
  12. font.getName(),
  13. italic,
  14. false,
  15. (short)0,
  16. (byte)0);
  17. if (hssfFont == null)
  18. {
  19. hssfFont = workbook.createFont();
  20. hssfFont.setBoldweight(bold ? HSSFFont.BOLDWEIGHT_BOLD : 0);
  21. hssfFont.setColor(hssfColor.getIndex());
  22. hssfFont.setFontHeight((short)(font.getSize() * 20));
  23. hssfFont.setFontName(font.getName());
  24. hssfFont.setItalic(italic);
  25. hssfFont.setStrikeout(false);
  26. hssfFont.setTypeOffset((short) 0);
  27. hssfFont.setUnderline((byte) 0);
  28. }
  29. return hssfFont;
  30. }

代码示例来源:origin: paypal/SeLion

  1. private static HSSFFont createCustomFont(short colorIndex, Byte underlineWeight) {
  2. HSSFFont font = wb1.createFont();
  3. font.setFontName(HSSFFont.FONT_ARIAL);
  4. font.setFontHeightInPoints((short) 10);
  5. font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
  6. font.setColor(colorIndex);
  7. font.setUnderline(underlineWeight);
  8. return font;
  9. }

代码示例来源:origin: org.sakaiproject.assignment/sakai-assignment-impl

  1. private HSSFCellStyle createHeaderStyle(){
  2. //TO-DO read style information from sakai.properties
  3. HSSFFont font = gradesWorkbook.createFont();
  4. font.setFontName(HSSFFont.FONT_ARIAL);
  5. font.setColor(IndexedColors.PLUM.getIndex());
  6. font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
  7. HSSFCellStyle cellStyle = gradesWorkbook.createCellStyle();
  8. cellStyle.setFont(font);
  9. return cellStyle;
  10. }

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

  1. HSSFWorkbook wb = new HSSFWorkbook();
  2. HSSFSheet sheet = wb.createSheet("New sheet");
  3. HSSFFont font = wb.createFont();
  4. font.setFontName("Arial Unicode MS");
  5. HSSFCellStyle style = wb.createCellStyle();
  6. style.setFont(font);
  7. HSSFRow row = sheet.createRow((short) 0);
  8. HSSFCell cell = row.createCell((short) 0);
  9. cell.setEncoding(HSSFCell.ENCODING_UTF_16);
  10. cell.setCellStyle(style);
  11. cell.setCellValue("\u53f8");

代码示例来源:origin: youseries/ureport

  1. font.setFontName(fontFamily);

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

  1. font.setFontName(HSSFFont.FONT_ARIAL);
  2. font.setFontHeightInPoints((short) 20);
  3. font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);

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

  1. //////////////////////Excel Header Style/////////////////////////
  2. HSSFCellStyle headerlabelcs = wb.createCellStyle();
  3. headerlabelcs.setFillForegroundColor(HSSFColor.PALE_BLUE.index);
  4. headerlabelcs.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
  5. headerlabelcs.setBorderLeft((short)1);
  6. headerlabelcs.setBorderRight((short)1);
  7. HSSFFont headerlabelfont = wb.createFont();
  8. headerlabelfont.setFontHeightInPoints((short)12);
  9. headerlabelfont.setFontName("Calibri");
  10. headerlabelfont.setColor(HSSFColor.BLACK.index);
  11. headerlabelfont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
  12. headerlabelcs.setFont(headerlabelfont);
  13. //////////////////////Excel Header Style/////////////////////////

代码示例来源:origin: Impetus/jumbune

  1. /**
  2. * Sets header style
  3. * @param worksheet the worksheet
  4. * @param fontName font name
  5. * @param fontColor font color
  6. * @param fontBoldweight font weight
  7. */
  8. public static void setHeaderStyle(Worksheet worksheet, String fontName,
  9. short fontColor, short fontBoldweight) {
  10. HSSFWorkbook workbook = worksheet.getWorkbook();
  11. HSSFFont font = workbook.createFont();
  12. font.setFontName(fontName);
  13. font.setColor(fontColor);
  14. font.setBoldweight(fontBoldweight);
  15. HSSFCellStyle cellStyle = workbook.createCellStyle();
  16. cellStyle.setFont(font);
  17. worksheet.setCellStyle(cellStyle);
  18. }

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

  1. public static void main(String[] args) throws IOException {
  2. try (HSSFWorkbook wb = new HSSFWorkbook()) {
  3. HSSFSheet sheet = wb.createSheet("new sheet");
  4. // Create a row and put some cells in it. Rows are 0 based.
  5. HSSFRow row = sheet.createRow(1);
  6. // Create a new font and alter it.
  7. HSSFFont font = wb.createFont();
  8. font.setFontHeightInPoints((short) 24);
  9. font.setFontName("Courier New");
  10. font.setItalic(true);
  11. font.setStrikeout(true);
  12. // Fonts are set into a style so create a new one to use.
  13. HSSFCellStyle style = wb.createCellStyle();
  14. style.setFont(font);
  15. // Create a cell and put a value in it.
  16. HSSFCell cell = row.createCell(1);
  17. cell.setCellValue("This is a test of fonts");
  18. cell.setCellStyle(style);
  19. // Write the output to a file
  20. try (FileOutputStream fileOut = new FileOutputStream("workbook.xls")) {
  21. wb.write(fileOut);
  22. }
  23. }
  24. }
  25. }

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

  1. HSSFWorkbook wb = new HSSFWorkbook();
  2. HSSFSheet sheet = wb.createSheet("FirstSheet");
  3. HSSFRow rowhead = sheet.createRow(0);
  4. HSSFCellStyle style = wb.createCellStyle();
  5. HSSFFont font = wb.createFont();
  6. font.setFontName(HSSFFont.FONT_ARIAL);
  7. font.setFontHeightInPoints((short)10);
  8. font.setBold(true);
  9. style.setFont(font);
  10. rowhead.createCell(0).setCellValue("ID");
  11. rowhead.createCell(1).setCellValue("First");
  12. rowhead.createCell(2).setCellValue("Second");
  13. rowhead.createCell(3).setCellValue("Third");
  14. for(int j = 0; j<=3; j++)
  15. rowhead.getCell(j).setCellStyle(style);

代码示例来源:origin: riotfamily/riot

  1. private void createHeadings(String... labels) {
  2. HSSFCellStyle style = wb.createCellStyle();
  3. HSSFFont font = wb.createFont();
  4. font.setFontName("Trebuchet MS");
  5. font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
  6. style.setFont(font);
  7. HSSFRow row = sheet.createRow(0);
  8. int col = 0;
  9. for (String label : labels) {
  10. HSSFCell cell = row.createCell(col++);
  11. cell.setCellStyle(style);
  12. cell.setCellValue(new HSSFRichTextString(label));
  13. }
  14. }

代码示例来源:origin: riotfamily/riot

  1. private void createHeadings(String... labels) {
  2. HSSFCellStyle style = wb.createCellStyle();
  3. HSSFFont font = wb.createFont();
  4. font.setFontName("Trebuchet MS");
  5. font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
  6. style.setFont(font);
  7. HSSFRow row = sheet.createRow(0);
  8. int col = 0;
  9. for (String label : labels) {
  10. HSSFCell cell = row.createCell(col++);
  11. cell.setCellStyle(style);
  12. cell.setCellValue(new HSSFRichTextString(label));
  13. }
  14. }

代码示例来源:origin: lanyuancom/lanyuan-2.0

  1. font.setFontName("宋体");
  2. if(position_title.equals(position)){
  3. font.setFontHeightInPoints((short)11);

相关文章