1. You could try the merge command for the title


2. Dropdowns? (not supported) Multiple lines per cell? (ui:repeat)

Or if you want to get low-level, use JExcelAPI directly and push the generated bytes to the browser.

Sorry, subtables is not supported and probably never will be. Try to model your table differently and use the merge to merge the columns in the parent table.

Since it's just a vertical list you could do it with ui:repeat:

<rich:column>
  <e:cell>
     <ui:repeat value="#{merchant.profiles}" var="profile">
        <h:outputText profile.getName}" />
        <!-- some kind of excel sign for linebreak -->
     <ui:repeat>
  </e:cell>
</rich:column>

What documentation/version? Those existed a long time ago and disappeared (somewhere before 2.1 RC2?) in favor of css attributes?

ui:repeat and other facelet tags are one level above the excel tags so they don't need permission to be nested.

Try using a normal line break char \n but remember to set the cell wrapping to true.

Don't use that version, it's so old it can break your computer and possibly your car, too! Use the one in 2.1.x

Hi Nicklas,

Need help.

I had created a excel using seam excel support. My excel sheet is creted as desired except I am not able to change the color of any text in the tag

<e:cell/>

conditionally. Below is the code snippet that I am using to make it work -

<e:cell value="#{employee.name}" style="xls-font-size: 8; xls-font-color:#{employee.resigned ? 'black' : 'red' }"/>

Please suggest if I am wrong somewhere in the usage.

Thanks.

employee is simple java bean.

I put system.out.println in employee.isResigned() method.

The above mentioned <e:cell/> executed only once despite that the list 'employees' has 10 records. The code snippet is below that I am using -

<e:worksheet name="employees" value="#{employees}" var="employee">

      <e:cell value="#{employee.name}" style="xls-font-size: 8; xls-font-color:#{employee.resigned ? 'black' : 'red' }"/>

</e:worksheet>

Please suggest, how can I make that work?

It seems that EL are not parsed inside style attribute in e:cell.
Could you confirm?

EL are parsed inside style attribute in e:cell only for first row of the worksheet.

For the further rows in the collection, it uses the cache value of styleclass or style attributes.

So there's no way to colour my column cells under some circumstances?