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.