1 Reply Latest reply on Nov 4, 2009 1:47 PM by Nicklas Karlsson

    Excel header area (not the formal header)

    Larry Strezo Newbie

      I have been having trouble defining a header section (not the formal header) at the top of my Excel document. I have tried using two identically named worksheets, but the data that I want at the top of the worksheet never appears.
      This is what I am trying to do in spirit:

         <e:worksheet name="ProcessTracking">
          <e:cell value="Instance Identifier: #{selectedProcessDefinition.explicitId}"/>
          <e:cell value="User: #{identity.username}"/>
         <e:worksheet name="ProcessTracking" value="#{processMetricExportList}" var="processes">          
           <e:column style="xls-column-autosize: true" >
                <f:facet name="header">
                <e:cell value="Name"/>
                <e:cell value="#{processes.processDefinitionName}"/>
           <e:column style="xls-column-autosize: true" >
                <f:facet name="header">
                <e:cell value="Instance Identifier"/>
                <e:cell value="#{processes.explicitId}"/>

      Any guidance anyone could provide would be greatly appreciated.
      Thanks in advance

        • 1. Re: Excel header area (not the formal header)
          Nicklas Karlsson Master

          assuming 1-based (col,row) format

          Current situation:

          1. First you create a worksheet named ProcessTracking

          2. Then you place the Instant Identifier at (1,1)

          3. Then you place the username at (2,1)

          4. Then you append to a worksheet named ProcessTracking

          But at what coordinates is the processMetricExportList placed? Yup. (1.1), overwriting the stuff already there

          Try using a startRow=2 for the second worksheet.