java.lang.IllegalArgumentException: Invalid column index (256). Allowable column range for BIFF8 is (0..255) or ('A'..'IV')

JIRA | 7 years ago
  1. 0

    Action: test opal-221 -- Implement the export to Excel command Step: 1) create fresh databases 'opal' and 'key' for opal 1.0.1 2) issue an upgrade 3) import a zip file with 1 completed interview exported from onyx1.6.4 cohort ontario (please check the attachment, it's a non-encrypted zip file) 4) show variable table list 5) export tables to an excel file based on the listed tables Result: in step 4), the listed tables shown as follows: opal-keys opal-keys.keys opal-data-ohs opal-data-ohs.Participants opal-data-ohs.CIPreliminaryQuestionnaire opal-data-ohs.BloodSamplesCollection opal-data-ohs.HealthQuestionnaireNurse opal-data-ohs.Weight opal-data-ohs.BoneDensity opal-data-ohs.SalivaSamplesCollection opal-data-ohs.BloodPressure opal-data-ohs.ArmSpan opal-data-ohs.SittingHeight opal-data-ohs.GripStrength opal-data-ohs.AnkleBrachial opal-data-ohs.UrineSamplesCollection opal-data-ohs.HealthQuestionnaireTouchScreen opal-data-ohs.Impedance418 opal-data-ohs.ConclusionQuestionnaire opal-data-ohs.Instruments opal-data-ohs.Consent opal-data-ohs.StandingHeight opal-data-ohs.Hips opal-data-ohs.Spirometry opal-data-ohs.Waist opal-data-ohs.Workstations opal-data in step 5) among the tables, 3 kinds of errors happened when 7 of them being exported (others were exported correctly): --> Error 1: happened in tables: opal-data-ohs.BloodSamplesCollection opal-data-ohs.SalivaSamplesCollection opal-data-ohs.UrineSamplesCollection Error info from opal-error.log java.lang.ClassCastException: java.util.ArrayList cannot be cast to java.lang.Boolean at org.obiba.magma.datasource.excel.support.ExcelUtil.setCellValue(ExcelUtil.java:30) at org.obiba.magma.datasource.excel.ExcelValueTableWriter$ExcelValueSetWriter.writeValue(ExcelValueTableWriter.java:229) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:182) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:158) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:138) at org.obiba.opal.core.service.impl.DefaultExportServiceImpl.exportTablesToDatasource(DefaultExportServiceImpl.java:70) at org.obiba.opal.core.service.impl.DefaultExportServiceImpl.exportTablesToDatasource(DefaultExportServiceImpl.java:52) at org.obiba.opal.core.service.impl.DefaultExportServiceImpl.exportTablesToExcelFile(DefaultExportServiceImpl.java:87) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy47.exportTablesToExcelFile(Unknown Source) at org.obiba.opal.cli.client.command.ExportCommand.execute(ExportCommand.java:35) at org.obiba.opal.cli.client.OpalConsole.prompt(OpalConsole.java:136) at org.obiba.opal.cli.client.OpalConsole.<init>(OpalConsole.java:103) at org.obiba.opal.cli.client.OpalConsole.main(OpalConsole.java:185) --> Error 2: happened in table: opal-data-ohs.Participants Error info from opal-error.log: java.lang.ClassCastException: java.util.ArrayList cannot be cast to java.lang.Long at org.obiba.magma.datasource.excel.support.ExcelUtil.setCellValue(ExcelUtil.java:36) at org.obiba.magma.datasource.excel.ExcelValueTableWriter$ExcelValueSetWriter.writeValue(ExcelValueTableWriter.java:229) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:182) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:158) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:138) at org.obiba.opal.core.service.impl.DefaultExportServiceImpl.exportTablesToDatasource(DefaultExportServiceImpl.java:70) at org.obiba.opal.core.service.impl.DefaultExportServiceImpl.exportTablesToDatasource(DefaultExportServiceImpl.java:52) at org.obiba.opal.core.service.impl.DefaultExportServiceImpl.exportTablesToExcelFile(DefaultExportServiceImpl.java:87) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy39.exportTablesToExcelFile(Unknown Source) at org.obiba.opal.cli.client.command.ExportCommand.execute(ExportCommand.java:35) at org.obiba.opal.cli.client.OpalConsole.prompt(OpalConsole.java:136) at org.obiba.opal.cli.client.OpalConsole.<init>(OpalConsole.java:103) at org.obiba.opal.cli.client.OpalConsole.main(OpalConsole.java:185) --> Error 3: happened in tables: opal-data-ohs.CIPreliminaryQuestionnaire opal-data-ohs.HealthQuestionnaireNurse opal-data-ohs.HealthQuestionnaireTouchScreen Error info from opal-error.log: 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:926) at org.apache.poi.hssf.usermodel.HSSFCell.<init>(HSSFCell.java:162) at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:141) at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:38) at org.obiba.magma.datasource.excel.ExcelValueTable.getVariableColumn(ExcelValueTable.java:85) at org.obiba.magma.datasource.excel.ExcelValueTableWriter$ExcelVariableWriter.writeVariable(ExcelValueTableWriter.java:68) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:170) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:148) at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:138) at org.obiba.opal.core.service.impl.DefaultExportServiceImpl.exportTablesToDatasource(DefaultExportServiceImpl.java:70) at org.obiba.opal.core.service.impl.DefaultExportServiceImpl.exportTablesToDatasource(DefaultExportServiceImpl.java:52) at org.obiba.opal.core.service.impl.DefaultExportServiceImpl.exportTablesToExcelFile(DefaultExportServiceImpl.java:87) at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy47.exportTablesToExcelFile(Unknown Source) at org.obiba.opal.cli.client.command.ExportCommand.execute(ExportCommand.java:35) at org.obiba.opal.cli.client.OpalConsole.prompt(OpalConsole.java:136) at org.obiba.opal.cli.client.OpalConsole.<init>(OpalConsole.java:103) at org.obiba.opal.cli.client.OpalConsole.main(OpalConsole.java:185)

    JIRA | 7 years ago
    java.lang.IllegalArgumentException: Invalid column index (256). Allowable column range for BIFF8 is (0..255) or ('A'..'IV')
  2. 0

    Unable to export project to Excel

    GitHub | 3 years ago | biofool
    java.lang.IllegalArgumentException: Invalid column index (256). Allowable column range for BIFF8 is (0..255) or ('A'..'IV')
  3. 0

    How to get more than 255 columns in an excel sheet using Apache POI 3.6

    Stack Overflow | 7 years ago | Tommy
    java.lang.IllegalArgumentException: Invalid column index (256). Allowable column range for BIFF8 is (0..255) or ('A'..'IV')
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [EVALSYS-775] Excel report export cannot handle more than 255 rows - Sakai

    sakaiproject.org | 1 year ago
    java.lang.IllegalArgumentException: Invalid column index (256). Allowable column range for BIFF8 is (0..255) or ('A'..'IV')
  6. 0

    如何使用Apache POI 3.6以获得在一个Excel工作表超过255列 -- IT专业问题解答 -- 他山知识网

    net.cn | 1 year ago
    java.lang.IllegalArgumentException: Invalid column index (256). Allowable column range for BIFF8 is (0..255) or ('A'..'IV')

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. POI
      HSSFRow.createCell
      1. org.apache.poi.hssf.usermodel.HSSFCell.checkBounds(HSSFCell.java:926)
      2. org.apache.poi.hssf.usermodel.HSSFCell.<init>(HSSFCell.java:162)
      3. org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:141)
      4. org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:38)
      4 frames
    3. org.obiba.magma
      DatasourceCopier.copy
      1. org.obiba.magma.datasource.excel.ExcelValueTable.getVariableColumn(ExcelValueTable.java:85)
      2. org.obiba.magma.datasource.excel.ExcelValueTableWriter$ExcelVariableWriter.writeVariable(ExcelValueTableWriter.java:68)
      3. org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:170)
      4. org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:148)
      5. org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:138)
      5 frames
    4. org.obiba.opal
      DefaultExportServiceImpl.exportTablesToExcelFile
      1. org.obiba.opal.core.service.impl.DefaultExportServiceImpl.exportTablesToDatasource(DefaultExportServiceImpl.java:70)
      2. org.obiba.opal.core.service.impl.DefaultExportServiceImpl.exportTablesToDatasource(DefaultExportServiceImpl.java:52)
      3. org.obiba.opal.core.service.impl.DefaultExportServiceImpl.exportTablesToExcelFile(DefaultExportServiceImpl.java:87)
      3 frames
    5. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      3. java.lang.reflect.Method.invoke(Unknown Source)
      3 frames
    6. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      3 frames
    7. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
      1 frame
    8. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    9. Unknown
      $Proxy47.exportTablesToExcelFile
      1. $Proxy47.exportTablesToExcelFile(Unknown Source)
      1 frame
    10. org.obiba.opal
      OpalConsole.main
      1. org.obiba.opal.cli.client.command.ExportCommand.execute(ExportCommand.java:35)
      2. org.obiba.opal.cli.client.OpalConsole.prompt(OpalConsole.java:136)
      3. org.obiba.opal.cli.client.OpalConsole.<init>(OpalConsole.java:103)
      4. org.obiba.opal.cli.client.OpalConsole.main(OpalConsole.java:185)
      4 frames