2 Replies Latest reply on Feb 16, 2009 1:51 AM by Robert Aboui

    Seam - Excel data validation fields

    Robert Aboui Newbie
      Hi,

          I'm using seam to populate an Excel template. The template contains multiple worksheet's and is being generated using seam with no problems to begin with.
          Now I have a few data validation groups (lists) defined in the excel template on multiple worksheets.
          On a last worksheet when I attempt to reference these data validation lists for some reason I start getting exceptions whenever I attempt to generate the spreadsheet.

          Do seam & jxl support excel data validation lists? Is this a bug?
          Any help or details would be great. Part of the stack trace below.

      Thanks. R.

      org.jboss.seam.excel.ExcelWorkbookException: Could not create workbook
           at org.jboss.seam.excel.jxl.JXLExcelWorkbook.createWorkbook(JXLExcelWorkbook.java:368)
           at org.jboss.seam.excel.ui.UIWorkbook.encodeBegin(UIWorkbook.java:312)
           at javax.faces.component.UIComponent.encodeAll(UIComponent.java:934)
           at javax.faces.component.UIComponent.encodeAll(UIComponent.java:942)
           at com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java:592)
           at org.ajax4jsf.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:108)
           at org.ajax4jsf.application.AjaxViewHandler.renderView(AjaxViewHandler.java:196)
           at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:109)
           at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
           at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
           at javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)
              .....................
      Caused by: java.lang.NullPointerException
           at jxl.read.biff.File.<init>(File.java:91)
           at jxl.Workbook.getWorkbook(Workbook.java:268)
           at jxl.Workbook.getWorkbook(Workbook.java:253)
           at org.jboss.seam.excel.jxl.JXLExcelWorkbook.createWorkbook(JXLExcelWorkbook.java:352)
           ... 51 more