POI中过滤掉带消除线的文字（Excel 2003 版）

最新推荐文章于 2023-12-04 14:40:05 发布

双层木屋

最新推荐文章于 2023-12-04 14:40:05 发布

阅读量2.5k

点赞数 1

分类专栏： Java 文章标签： excel string null

本文链接：https://blog.csdn.net/LouGnib/article/details/6006674

版权

Java 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

直接上代码：

HSSFRichTextString richTextString = cell.getRichStringCellValue();
String realString = richTextString.getString();

boolean isCellStrikeOut = false;
HSSFCellStyle cellStyle = cell.getCellStyle();
if (cellStyle != null) {
    HSSFFont font = workbook.getFontAt(cellStyle.getFontIndex());
    if (font.getStrikeout()) {
        isCellStrikeOut = true;
    }
}

if (richTextString.numFormattingRuns() == 0) {
    if (isCellStrikeOut) {
        return "";
    }

    return realString;
} else if (!isCellStrikeOut) {
    StringBuilder sb = new StringBuilder(realString);
    int lastIndex = realString.length();
    for (int i = richTextString.numFormattingRuns() - 1; i >= 0 ; i --) {
        short fontIndex = richTextString.getFontOfFormattingRun(i);
        HSSFFont font = workbook.getFontAt(fontIndex);
        if (font.getStrikeout()) {
            sb.delete(richTextString.getIndexOfFormattingRun(i), lastIndex);
        }

        lastIndex = richTextString.getIndexOfFormattingRun(i);
    }

    return sb.toString();
} else {
    StringBuilder sb = new StringBuilder();
    int lastIndex = realString.length();
    for (int i = richTextString.numFormattingRuns() - 1; i >= 0 ; i --) {
        short fontIndex = richTextString.getFontOfFormattingRun(i);
        HSSFFont font = workbook.getFontAt(fontIndex);
        if (!font.getStrikeout()) {
            sb.insert(0, realString.substring(richTextString.getIndexOfFormattingRun(i), lastIndex));
        }

        lastIndex = richTextString.getIndexOfFormattingRun(i);
    }

    return sb.toString();
}