cn.afterturn.easypoi.excel.html.helper.CellValueHelper Maven / Gradle / Ivy

Go to download
package cn.afterturn.easypoi.excel.html.helper;

import java.util.HashMap;
import java.util.Map;

import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFFont;
import org.apache.poi.xssf.usermodel.XSSFRichTextString;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import com.google.common.xml.XmlEscapers;

/**
 * Cell值帮助类
 * @author JueYue
 *  2015年5月9日 下午10:31:32
 */
public class CellValueHelper {
    /**
     * Excel 格式
     */
    private boolean             is07;

    private int                 cssRandom;

    private Map fontCache = new HashMap();

    public CellValueHelper(Workbook wb, int cssRandom) {
        this.cssRandom = cssRandom;
        if (wb instanceof HSSFWorkbook) {
            is07 = false;
        }else if (wb instanceof XSSFWorkbook) {
            is07 = true;
            cacheFontInfo(wb);
        } else {
            throw new IllegalArgumentException(
                    "unknown workbook type: " + wb.getClass().getSimpleName());
        }
    }

    /**
     * O7 版本坑爹bug
     * @param wb
     */
    private void cacheFontInfo(Workbook wb) {
        for (short i = 0, le = wb.getNumberOfFonts(); i < le; i++) {
            Font font = wb.getFontAt(i);
            fontCache.put(font.getBold() + "_" + font.getItalic() + "_" + font.getFontName()
                          + "_" + font.getFontHeightInPoints() + "_" + font.getColor(),
                font.getIndex() + "");
        }

    }

    public String getHtmlValue(Cell cell) {
        if (CellType.BOOLEAN == cell.getCellType()
            || CellType.NUMERIC == cell.getCellType()) {
            cell.setCellType(CellType.STRING);
            return cell.getStringCellValue();
        } else if (CellType.STRING == cell.getCellType()) {
            if (cell.getRichStringCellValue().numFormattingRuns() == 0) {
                return XmlEscapers.xmlContentEscaper().escape(cell.getStringCellValue());
            } else if (is07) {
                return getXSSFRichString((XSSFRichTextString) cell.getRichStringCellValue());
            } else {
                return getHSSFRichString((HSSFRichTextString) cell.getRichStringCellValue());
            }
        }
        return "";
    }

    /**
     * 03版本复杂数据
     * @param rich
     * @return
     */
    private String getHSSFRichString(HSSFRichTextString rich) {
        int nums = rich.numFormattingRuns();
        StringBuilder sb = new StringBuilder();
        String text = rich.toString();
        int currentIndex = 0;
        sb.append(text.substring(0, rich.getIndexOfFormattingRun(0)));
        for (int i = 0; i < nums; i++) {
            sb.append("");
            currentIndex = rich.getIndexOfFormattingRun(i);
            if (i < nums - 1) {
                sb.append(XmlEscapers.xmlContentEscaper()
                    .escape(text.substring(currentIndex, rich.getIndexOfFormattingRun(i + 1))));
            } else {
                sb.append(XmlEscapers.xmlContentEscaper()
                    .escape(text.substring(currentIndex, text.length())));
            }
            sb.append("");
        }
        return sb.toString();
    }

    /**
     * 07版本复杂数据
     * @param rich
     * @return
     */
    private String getXSSFRichString(XSSFRichTextString rich) {
        int nums = rich.numFormattingRuns();
        StringBuilder sb = new StringBuilder();
        String text = rich.toString();
        int currentIndex = 0, lastIndex = 0;
        for (int i = 1; i <= nums; i++) {
            sb.append("");
            currentIndex = rich.getIndexOfFormattingRun(i) == -1 ? text.length()
                : rich.getIndexOfFormattingRun(i);
            sb.append(
                XmlEscapers.xmlContentEscaper().escape(text.substring(lastIndex, currentIndex)));
            sb.append("");
            lastIndex = currentIndex;
        }
        return sb.toString();
    }

    private String getFontIndex(XSSFFont font) {
        return fontCache
            .get(font.getBold() + "_" + font.getItalic() + "_" + font.getFontName() + "_"
                 + font.getFontHeightInPoints() + "_" + font.getColor());
    }
}