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

Sakai JIRA | Lovemore Nalube | 7 years ago
  1. 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')
  2. 0

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

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

    Eval has: 42 responses, 467 total report eval items including repeated lecturer items. This error is throw when a user tries to export an eval report in excel: stack trace: org.sakaiproject.portal.api.PortalHandlerException: uk.org.ponder.util.UniversalRuntimeException: Error servicing SakaiRSF request --> Error invoking init method handle on bean rootHandlerBean --> You cannot have more than 255 columns in a given row (IV). Because Excel can't handle it at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:768) caused by: uk.org.ponder.util.UniversalRuntimeException: Error servicing SakaiRSF request --> Error invoking init method handle on bean rootHandlerBean --> You cannot have more than 255 columns in a given row (IV). Because Excel can't handle it at org.apache.poi.hssf.usermodel.HSSFCell.checkBounds(HSSFCell.java:908) at org.apache.poi.hssf.usermodel.HSSFCell.<init>(HSSFCell.java:168) at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:149) at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:133) at org.sakaiproject.evaluation.tool.reporting.XLSReportExporter.buildReport(XLSReportExporter.java:163) at org.sakaiproject.evaluation.tool.reporting.ReportExporterBean.export(ReportExporterBean.java:81) at org.sakaiproject.evaluation.tool.reporting.ReportHandlerHook.handle(ReportHandlerHook.java:57) at org.sakaiproject.evaluation.tool.utils.RootHandlerBeanOverride.handle(RootHandlerBeanOverride.java:28) at sun.reflect.GeneratedMethodAccessor7716.invoke(null:-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:23) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:17) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:77) at uk.org.ponder.rsac.support.RSACBeanLocatorImpl.createBean(RSACBeanLocatorImpl.java:553) at uk.org.ponder.rsac.support.RSACBeanLocatorImpl.access$000(RSACBeanLocatorImpl.java:75) at uk.org.ponder.rsac.support.RSACBeanLocatorImpl$1.run(RSACBeanLocatorImpl.java:449) at org.sakaiproject.genericdao.hibernate.HibernateGenericDao.invokeTransactionalAccess(HibernateGenericDao.java:580) at sun.reflect.GeneratedMethodAccessor7691.invoke(null:-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy9.invokeTransactionalAccess(null:-1) at org.sakaiproject.evaluation.dao.EvalDaoInvokerImpl.invokeTransactionalAccess(EvalDaoInvokerImpl.java:34) at org.sakaiproject.evaluation.tool.wrapper.ModelAccessWrapperInvoker.invokeRunnable(ModelAccessWrapperInvoker.java:38) at uk.org.ponder.rsac.support.RSACBeanLocatorImpl.createBean(RSACBeanLocatorImpl.java:447) at uk.org.ponder.rsac.support.RSACBeanLocatorImpl.access$000(RSACBeanLocatorImpl.java:75) at uk.org.ponder.rsac.support.RSACBeanLocatorImpl$1.run(RSACBeanLocatorImpl.java:449) at uk.org.ponder.rsac.RSACErrorBridge.invokeRunnable(RSACErrorBridge.java:38) at uk.org.ponder.rsac.support.RSACBeanLocatorImpl.createBean(RSACBeanLocatorImpl.java:447) at uk.org.ponder.rsac.support.RSACBeanLocatorImpl.getLocalBean(RSACBeanLocatorImpl.java:348) at uk.org.ponder.rsac.support.RSACBeanLocatorImpl.getBean(RSACBeanLocatorImpl.java:379) at uk.org.ponder.rsac.support.PerRequestInfo$1.locateBean(PerRequestInfo.java:49) at uk.ac.cam.caret.sakai.rsf.servlet.ReasonableSakaiServlet.service(ReasonableSakaiServlet.java:65) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:565) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:679) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:461) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:364) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301) at org.sakaiproject.tool.impl.ActiveToolComponent$MyActiveTool.forward(ActiveToolComponent.java:475) at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1216) at org.sakaiproject.portal.charon.handlers.ToolHandler.doTool(ToolHandler.java:188) at org.sakaiproject.portal.charon.handlers.ToolHandler.doGet(ToolHandler.java:93) at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:768) at javax.servlet.http.HttpServlet.service(HttpServlet.java:627) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:616) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:595)

    Sakai JIRA | 7 years ago | Lovemore Nalube
    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

    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')
  6. 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')

    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:921)
      2. org.apache.poi.hssf.usermodel.HSSFCell.<init>(HSSFCell.java:161)
      3. org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:141)
      4. org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:119)
      5. org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:97)
      5 frames
    3. org.sakaiproject.evaluation
      RootHandlerBeanOverride.handle
      1. org.sakaiproject.evaluation.tool.reporting.XLSReportExporter.buildReport(XLSReportExporter.java:163)
      2. org.sakaiproject.evaluation.tool.reporting.ReportExporterBean.export(ReportExporterBean.java:81)
      3. org.sakaiproject.evaluation.tool.reporting.ReportHandlerHook.handle(ReportHandlerHook.java:57)
      4. org.sakaiproject.evaluation.tool.utils.RootHandlerBeanOverride.handle(RootHandlerBeanOverride.java:28)
      4 frames