SAP Knowledge Base Article - Preview

2435932 - Error in Excel converter or MissingResource for class com.sap.ip.bi.export.office.impl.excel2007.MsExcel2007Converter

Symptom

When doing an export to Excel an error occurs. Depending on the output format, the error stack differs at the beginning but has the same "Caused by" section in the related log. This issue occurs on local mode as well as in platform mode.

  • Export as XLS:
    Error in Excel converter
     at com.sap.ip.bi.export.office.impl.excel2000.MsExcel2000Converter.getBinaryResultContainer(MsExcel2000Converter.java:156)
    ...
    Caused by: java.lang.IllegalArgumentException: The workbook already contains a sheet of this name
     at org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet(HSSFWorkbook.java:785)
     at com.sap.ip.bi.export.office.impl.excel2000.Excel2000Writer.write(Excel2000Writer.java:240)
     at com.sap.ip.bi.export.office.impl.excel2000.Excel2000Document.writeContentToStream(Excel2000Document.java:102)
     at com.sap.ip.bi.export.office.impl.excel2000.Excel2000Document.writeOfficeHtmlDocumentToStream(Excel2000Document.java:65)
    ...
  • Export as XLSX: 
    MissingResource for class com.sap.ip.bi.export.office.impl.excel2007.MsExcel2007Converter, key: MsExcel2007Converter_0001, locale: en
     at com.sap.ip.bi.export.office.impl.excel2007.MsExcel2007Converter.getBinaryResultContainer(MsExcel2007Converter.java:157)
    ...
    Caused by: java.lang.IllegalArgumentException: The workbook already contains a sheet of this name
     at org.apache.poi.xssf.usermodel.XSSFWorkbook.createSheet(XSSFWorkbook.java:636)
     at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:584)
     at com.sap.ip.bi.export.office.impl.excel2007.Excel2007Writer.write(Excel2007Writer.java:244)
    ...


Read more...

Environment

SBOP Design Studio 1.6 SP6 Patch Level 0

Product

SAP BusinessObjects Design Studio all versions

Keywords

Export to Excel,com.sap.ip.bi.export.office.impl.excel2000.MsExcel2000Converter, Design Studio , KBA , BI-RA-AD , Design Studio End Of Maint Note 2622437 , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.