POI Excel合并导致“修复记录：从/xl/styles.xml部分（样式）格式” [英] POI Excel Merging Causing "Repaired Records: Format from /xl/styles.xml part (Styles)"

问题描述

我已经使用这里指定的代码合并了两个excel文件。

）

任何帮助如何缓解这个问题将会很好。

解决方案

好了，调试一下POI代码后，如何应用样式。

下面解决问题解决问题

  newCellStyle.getCoreXf（）。 unsetBorderId（）; 
 newCellStyle.getCoreXf（）。unsetFillId（）; 
  

I have merged two excel files using the code specied here

http://www.coderanch.com/t/614715/Web-Services/java/merge-excel-files

this the block applying the styles for my merging cells

 if (styleMap != null)
{
  if (oldCell.getSheet().getWorkbook() == newCell.getSheet().getWorkbook())
  {
    newCell.setCellStyle(oldCell.getCellStyle());
  }
  else
  {
    int stHashCode = oldCell.getCellStyle().hashCode();
    XSSFCellStyle newCellStyle = styleMap.get(stHashCode);
    if (newCellStyle == null)
    {
      newCellStyle = newCell.getSheet().getWorkbook().createCellStyle();
      newCellStyle.cloneStyleFrom(oldCell.getCellStyle());
      styleMap.put(stHashCode, newCellStyle);
    }
    newCell.setCellStyle(newCellStyle);
  }
}

It all working as expected and going well in generating my XSSFWorkbook.

Problem starting when I try to open it:

I see below error

and my error report contains below

    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
    <logFileName>error072840_01.xml</logFileName>
    <summary>Errors were detected in file 'XYZ.xlsx'</summary>
    <repairedRecords summary="Following is a list of repairs:">
        <repairedRecord>Repaired Records: Format from /xl/styles.xml part (Styles)</repairedRecord>
    </repairedRecords>
</recoveryLog>

After all these my sheet opens up fine but without styles. I know there is a limitation on number of styles to be created and have counted the styles being created and I hardly see 4 created. I even know that this issue is with too many styles.

Unfortunately, POI has support to optimise only HSSFWorkbook (Apache POI delete CellStyle from workbook)

Any help in how to mitigate with this issue will be great.

解决方案

Well, after debugging bit of POI code and how styles are being applied and so.

Doing below solved the problem

newCellStyle.getCoreXf().unsetBorderId();
      newCellStyle.getCoreXf().unsetFillId();

这篇关于POI Excel合并导致“修复记录：从/xl/styles.xml部分（样式）格式”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！