Hutool导出Excel 在一个单元格设置多个字体样式

ExcelWriter writer = ExcelUtil.getWriter(true);//第二行第一列CellStyle cellStyle1 = writer.createCellStyle(1, 0);CellStyle cellStyle1 = writer.createCellStyle(1, 0);cellStyle1.setAlignment(HorizontalAlignment.CENTER);//水平居中cellStyle1.setVerticalAlignment(VerticalAlignment.CENTER);//垂直居中cellStyle1.setWrapText(true);//自动换行//第一种字体样式Font font1 = writer.createFont();font1.setFontName("黑体");font1.setFontHeightInPoints((short) 18);//第二种字体样式Font font3 = writer.createFont();font3.setFontName("仿宋_GB2312");font3.setFontHeightInPoints((short) 16);//单元格内容String txt1 = "第一行";int l = txt1.length();String txt = txt1 + "\r\n（第二行）";//RichTextString两种实现类XSSFRichTextString,HSSFRichTextString //HSSFRichTextString text = new HSSFRichTextString (txt);XSSFRichTextString text = new XSSFRichTextString(txt);text.applyFont(0, l, font1);text.applyFont(l + 1, txt.length(), font3);writer.writeCellValue(0, 1, text);writer.setStyle(cellStyle1, 0, 1);//设置行高writer.setRowHeight(1, 60);