java - 如果多个工作表包含 RichText，则将它们合并到一个工作簿中时，RichText 单元格从工作表 2 开始显示为空白

Question

我有多个 Excel 工作表，每个工作表包含几个 RichText 单元格，但是当我使用 poi-ooxml 将所有 Excel 工作表合并到一个工作簿中时，第一个工作表显示正确，但在后续工作表中，我们丢失了 RichText 单元格值，并且单元格显示为空白.

Answer 1

This issue is now fixed for me.
i have added below lines of code when relationship type is Shared String ("http://schemas.openxmlformats.org/officeDocument/2006/relationships/sharedStrings"

):

sd = SstDocument.Factory.parse(p.getInputStream());
    targetsd = SstDocument.Factory.parse(partTarget.getInputStream());
    List<CTRst> ctRstArray = sd.getSst().getSiList();
    String sharedString = null;
    for (CTRst ctRst : ctRstArray) {
        if(ctRst.getRList() != null && ctRst.getRList().size()>0){
            List<CTRElt> rList = ctRst.getRList();
            targetsd.getSst().addNewSi().getRList().addAll(rList);
        }else if(ctRst.getRPhList() != null && ctRst.getRPhList().size() > 0){
            List<CTPhoneticRun> rphList = ctRst.getRPhList();
            targetsd.getSst().addNewSi().getRPhList().addAll(rphList);
        }else {
            sharedString = ctRst.getT();
            CTRst ctrst = targetsd.getSst().addNewSi();
            ctrst.setT(sharedString);
        }
    }



earlier the lines of code was:

sd = SstDocument.Factory.parse(p.getInputStream());
    targetsd = SstDocument.Factory.parse(partTarget.getInputStream());
    List<CTRst> ctRstArray = sd.getSst().getSiList();
    String sharedString = null;
    for (CTRst ctRst : ctRstArray) {

            sharedString = ctRst.getT();
            CTRst ctrst = targetsd.getSst().addNewSi();
            ctrst.setT(sharedString);               
    }