7 Replies Latest reply: Nov 21, 2012 1:01 PM by Avinash_Varma RSS

    BI Publisher Excel Template: Referencing data in two sheets


      I have an Excel Template with Sheet1 and XDO_METADATA sheet. When I use XDO_?ELEMENT_NAME? in sheet1 everything is fine.

      Now my question. Is ist possible to add another sheet in the excel-file - sheet2. And then reference data in this sheet as well, using XDO_?ELEMENT_NAME? ?
      So far I only get this error, when I call the preview:

      java.lang.ArrayIndexOutOfBoundsException: -1
           at java.util.Vector.elementData(Unknown Source)
           at java.util.Vector.elementAt(Unknown Source)
           at oracle.xdo.excel.user.biff.RowBlock.getRow(RowBlock.java:488)
           at oracle.xdo.excel.user.bimpl.BSheet.getRow(BSheet.java:942)

      Or is there another solution?

      Thanks a lot