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


      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.