hi everyone,
When I output the data to a CSV file, I found that the Excel writer component of BIOVIA Pipeline Pilot has a limit on the number of columns to write data to. The error information as shown in the following figure.
Invalid column index (256). Allowable column range for BIFF8 is (0..255) or ('A'..'IV') 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:994) at org.apache.poi.hssf.usermodel.HSSFCell.(HSSFCell.java:163) at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:140) at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:39) at com.scitegic.excel.HSSFExcelWriter.createCell(HSSFExcelWriter.java:93) at com.scitegic.excel.ExcelWriter.createCell(ExcelWriter.java:229) at com.scitegic.excel.ExcelWriterComponent.onProcess(ExcelWriterComponent.java:137) at com.scitegic.pilot.Pilot.callOnProcess(Pilot.java:441) CComponentJavaPlugin::onProcess: Pipeline Pilot exception rethrown -> 'Excel Writer' ('Write ABC.csv'); Location: 28 - error during Data Record Processing phase CProtocolStd::onProcess: Pipeline Pilot exception rethrown CProtocol::onProcess: Pipeline Pilot exception rethrown CComponentRunner::CallProtocolOnProcess: exception caught, calling onFinalize before rethrow Protocol New Protocol1, user YLI7: Pipeline Pilot exception caught Protocol New Protocol1, user YLI7: Protocol failed: Pipeline Pilot error Pipeline Pilot Server version 22.1.0.2935 Server OS: Windows