Java POI 设置字体下划线、方框打勾、字体加粗

Java POI 设置字体下划线

---

办公设备租赁，找深圳惠源.

1.通过代码设置

// 设置下划线private XSSFRichTextString UnderLineIndex(String content, Font font) {font.setUnderline((byte)1);XSSFRichTextString richString = new XSSFRichTextString(content);// 该font应用于那些位置的字符richString.applyFont(6, content.length(), font);font.setUnderline((byte)0);return richString;}
1
2
3
4
5
6
7
8
9

2. 通过excel模板，直接字符串替换

private void fillCellValue(XSSFCell cell) {String stringCellValue = cell.getStringCellValue().replace("${recuritName}", "余波");cell.setCellValue( stringCellValue );
 }
1
2
3
4

Java POI 输出方框打勾

---

1.代码设置

 // 设置方框打勾private RichTextString fillTextRight(String content, Font font){RichTextString richTextString = new XSSFRichTextString("("\\\u25A1"");// 设置字体名称font.setFontName("Wingdings 2");richTextString.applyFont(, font);return richTextString;}
1
2
3
4
5
6
7
8
9
10

2.直接字符串输出

 cell.setStringCellValue("□");
 cell.setStringCellValue("☑");
1
2
3

Java POI 设置字体下划线

---

// 字体加粗private RichTextString blodText(String content, Font font, int start, int end ) {RichTextString richTextString = new XSSFRichTextString(content);font.setFontName("宋体");font.setBold(true);// 字体大小short fontHeight = font.getFontHeightInPoints();font.setFontHeightInPoints((short) 10);richTextString.applyFont(start, end , font);// 还原为原Fontfont.setFontHeightInPoints(fontHeight);font.setBold(false);//粗体显示return richTextString;}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15