Article - CS317968
Failed to export importable spreadsheet in XLS format for large BOM in Windchill PDMLink
Modified: 07-Aug-2024
Applies To
- Windchill PDMLink 11.0 to 13.0
Description
- Failed to export importable spreadsheet in XLS format for large BOM
- It throws error message as below: Caused by: java.lang.IllegalArgumentException: Invalid column index (256). Allowable column range for BIFF8 is (0..255) or ('A'..'IV')
at org.apache.poi.hssf.usermodel.HSSFCell.checkBounds(HSSFCell.java:982)
at org.apache.poi.hssf.usermodel.HSSFCell.<init>(HSSFCell.java:153)
at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:159)
at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:114)
at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:38)
at com.ptc.windchill.ixb.exporter.Xml2Xls.addCell(Xml2Xls.java:488)
at com.ptc.windchill.ixb.exporter.Xml2Xls.exportPart(Xml2Xls.java:970)
at com.ptc.windchill.ixb.exporter.Xml2Xls.export2Xls(Xml2Xls.java:662)
at com.ptc.windchill.ixb.exporter.forms.XlsExportFormProcessor.convertExportJarToXls(XlsExportFormProcessor.java:441)
at com.ptc.windchill.ixb.exporter.forms.XlsExportFormProcessor.doOperation(XlsExportFormProcessor.java:205)
at com.ptc.core.components.forms.DefaultFormProcessorController.executeDoOperation(DefaultFormProcessorController.java:538)
at com.ptc.core.components.forms.DefaultFormProcessorController.performExecuteDoOperationAndPostProcess(DefaultFormProcessorController.java:342)
at com.ptc.core.components.forms.DefaultFormProcessorController.execute(DefaultFormProcessorController.java:263)
at com.ptc.core.components.forms.FormDispatcher.callControllerExecute(FormDispatcher.java:146)
at com.ptc.core.components.forms.FormDispatcher.callFormProcessorController(FormDispatcher.java:116)
at com.ptc.core.components.forms.FormDispatcher.execute(FormDispatcher.java:93)
... 53 more
This is a printer-friendly version of Article 317968 and may be out of date. For the latest version click CS317968