String orsoContentBefore = "Please prepare the ORSO cheques for the below clients for ";
String orsoContentMiddle = " ORSO submissions on or before ";
richTextString = getRedUnderlineRichText(headstyleFont, headstyleFontRedUnderline, forMonthYear, beforDayMonthYear, orsoContentBefore,
orsoContentMiddle);
HSSFCell orsoCell = row.createCell(0);
orsoCell.setCellValue(richTextString);
HSSFFont headstyleFont = wb.createFont();
headstyleFont.setFontName("Times New Roman");
headstyleFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
headstyleFont.setFontHeightInPoints((short) 11);
private HSSFRichTextString getRedUnderlineRichText(HSSFFont headstyleFont, HSSFFont headstyleFontRedUnderline, String forMonthYear, String beforDayMonthYear,
String mpfContentBefore, String mpfContentMiddle) {
String content = mpfContentBefore + forMonthYear + mpfContentMiddle + beforDayMonthYear;
HSSFRichTextString richText
java excel设置cell部分内容红色并有下划线
最新推荐文章于 2023-06-01 23:46:19 发布