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屋！