java richtext_POI richText和html的转换案例

private XSSFRichTextString parseHtmlStrToRichText(String htmlStr) {

Document document = parseHtmlStrToDocument(htmlStr);

XSSFRichTextString rts = parseDocementToRichText(document.getChildNodes().item(0));

return rts;

}

private Document parseHtmlStrToDocument(String content){

content = "" + content + "";

//html的换行标签变为excel的换行

content = content.replaceAll("
", "\n");

DocumentBuilderFactory documentbuilderfactory = DocumentBuilderFactory.newInstance();

DocumentBuilder documentBuilder;

Document document = null;

try {

documentBuilder = documentbuilderfactory.newDocumentBuilder();

document = documentBuilder.parse(new ByteArrayInputStream(content.getBytes("UTF-8")));

} catch (Exception e) {

e.printStackTrace();

}

return document;

}

private XSSFRichTextString parseDocementToRichText(Node contentNode) {

String wholeTextContent = contentNode.getTextContent();

XSSFRichTextString rts = new XSSFRichTextString();

rts.append(wholeTextContent);

setRichText(rts, contentNode, 0, null);

return rts;

}

private void setRichText(RichTextString rts, Node contentNode, int startIndex, XSSFFont parentFont) {

if (contentNode.getNodeType() == Node.TEXT_NODE) {

return;

} else {

String textContent = contentNode.getTextContent();

XSSFFont font = null;

if (!contentNode.getNodeName().equals("content")) {

font = getRichTextFontOfNode(contentNode, parentFont);

rts.applyFont(startIndex, startIndex + textContent.length(), font);

}

NodeList nodeList = contentNode.getChildNodes();

int fontLength = startIndex;

String subTextContent = "";

for (int i = 0; i < nodeList.getLength(); i++) {

Node node = nodeList.item(i);

subTextContent = node.getTextContent();

if (node.getNodeType() == Node.TEXT_NODE) {

} else {

setRichText(rts, node, fontLength, font);

}

fontLength += subTextContent.length();

}

}

}

private XSSFFont getRichTextFontOfNode(Node node, XSSFFont parentFont) {

XSSFFont font = new XSSFFont();

font.setFontName(FONT_NAME);

font.setFontHeightInPoints(RICH_FONT_SIZE_DEFAULT);

short fontHeight = RICH_FONT_SIZE_DEFAULT;

if (parentFont != null) {

fontHeight = parentFont.getFontHeightInPoints();

font.setFontHeightInPoints(fontHeight);

font.setColor(parentFont.getXSSFColor());

font.setBold(parentFont.getBold());

font.setUnderline(parentFont.getUnderline());

}

if ("span".equals(node.getNodeName())) {

String className = node.getAttributes().getNamedItem("class").getNodeValue();

switch(className) {

case RICH_CSS_01: {

font.setBold(true);

break;

}

case RICH_CSS_02: {

font.setUnderline(XSSFFont.U_SINGLE);

break;

}

case RICH_CSS_03: {

font.setFontHeightInPoints(RICH_FONT_SIZE_3);

font.setBold(true);

break;

}

case RICH_CSS_04: {

int[] rgbColor = P2StringUtil.hexToRgb(RICH_ARGB_BLACK);

XSSFColor xssfColor = new XSSFColor(new java.awt.Color(rgbColor[0], rgbColor[1], rgbColor[2]), new DefaultIndexedColorMap());

font.setColor(xssfColor);

break;

}

case RICH_CSS_05: {

int[] rgbColor = P2StringUtil.hexToRgb(RICH_ARGB_RED);

XSSFColor xssfColor = new XSSFColor(new java.awt.Color(rgbColor[0], rgbColor[1], rgbColor[2]), new DefaultIndexedColorMap());

font.setColor(xssfColor);

break;

}

case RICH_CSS_06: {

int[] rgbColor = P2StringUtil.hexToRgb(RICH_ARGB_BLUE);

XSSFColor xssfColor = new XSSFColor(new java.awt.Color(rgbColor[0], rgbColor[1], rgbColor[2]), new DefaultIndexedColorMap());

font.setColor(xssfColor);

break;

}

}

} else if ("font".equals(node.getNodeName())) {

int fontSize = Integer.parseInt(node.getAttributes().getNamedItem("size").getNodeValue());

switch(fontSize) {

case 1:

fontHeight = RICH_FONT_SIZE_1;

break;

case 2:

fontHeight = RICH_FONT_SIZE_2;

break;

case 3:

fontHeight = RICH_FONT_SIZE_3;

break;

case 4:

fontHeight = RICH_FONT_SIZE_4;

break;

case 5:

fontHeight = RICH_FONT_SIZE_5;

break;

case 6:

fontHeight = RICH_FONT_SIZE_6;

break;

default:

fontHeight = RICH_FONT_SIZE_7;

break;

}

font.setFontHeightInPoints(fontHeight);

}

return font;

}

private String parseRichTextToHtmlStr(XSSFCell cell) {

String htmlStr = "";

String cellType = cell.getCellType().toString();

if (!"STRING".equals(cellType)) {

htmlStr = InstructionUtil.getCellValueByCell(cell);

return htmlStr;

}

XSSFRichTextString rts = cell.getRichStringCellValue();

String wholeContentText = rts.getString();

if (StringUtils.isEmpty(wholeContentText)) {

return wholeContentText;

}

if (rts.numFormattingRuns() == 0) {

XSSFCellStyle cellStyle = cell.getCellStyle();

XSSFFont font = cellStyle.getFont();

htmlStr = parseFontToHtmlStr(font, wholeContentText);

} else {

for(int i=0; i

String subContent = wholeContentText.substring(rts.getIndexOfFormattingRun(i), rts.getIndexOfFormattingRun(i)+rts.getLengthOfFormattingRun(i));

XSSFFont font = rts.getFontAtIndex(rts.getIndexOfFormattingRun(i));

if (!"".equals(subContent)) {

htmlStr += parseFontToHtmlStr(font, subContent);

}

}

}

return htmlStr;

}

private String parseFontToHtmlStr (XSSFFont font, String contentText) {

String htmlStr = "";

StringBuffer sb = new StringBuffer();

XSSFColor color = font.getXSSFColor();

String colorClass = null;

boolean underlined = false;

boolean isBold = font.getBold();

if (color != null && color.getARGBHex() != null) {

switch (color.getARGBHex()) {

case RICH_ARGB_BLACK:

colorClass = RICH_CSS_04;

break;

case RICH_ARGB_RED:

colorClass = RICH_CSS_05;

break;

case RICH_ARGB_BLUE:

colorClass = RICH_CSS_06;

break;

}

}

if (Font.U_SINGLE == font.getUnderline()) {

underlined = true;

}

short fontHeight = font.getFontHeightInPoints();

short fontSize = 3;

boolean isDefaultFontSize = false;

if (fontHeight <= RICH_FONT_SIZE_1) {

fontSize = 1;

} else if( fontHeight == RICH_FONT_SIZE_DEFAULT) {

isDefaultFontSize = true;

} else if(fontHeight <= RICH_FONT_SIZE_2) {

fontSize = 2;

} else if(fontHeight<= RICH_FONT_SIZE_3) {

fontSize = 3;

} else if(fontHeight<=RICH_FONT_SIZE_4) {

fontSize = 4;

} else if(fontHeight<=RICH_FONT_SIZE_5) {

fontSize = 5;

} else if(fontHeight<=RICH_FONT_SIZE_6) {

fontSize = 6;

} else {

fontSize = 7;

}

if (colorClass != null) {

sb.append("");

}

if (underlined) {

sb.append("");

}

if (isBold) {

sb.append("");

}

if (!isDefaultFontSize) {

sb.append("");

}

//excelの値の特殊文字(例：など)をescape

contentText = StringEscapeUtils.escapeXml11(contentText);

sb.append(contentText);

if (!isDefaultFontSize) {

sb.append("");

}

if (isBold) {

sb.append("");

}

if (underlined) {

sb.append("");

}

if (colorClass != null) {

sb.append("");

}

htmlStr = sb.toString();

htmlStr = htmlStr.replaceAll("\\R", "
");

return htmlStr;

}